Table of contents
TOC
Collapse the table of content
Expand the table of content

List.FindText

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Searches a list of values, including record fields, for a text value.

List.FindText(list as list, text as text) as list  

Arguments

ArgumentDescription
listThe List to search.
textThe value to search for.

Example

List.FindText(  
  
{  
  
    [field1 = "t1", field2 = "t2" ],  
  
    [field1 = "test1", field2 = "test2" ],  
  
    [field1 = "another test", field2 = 5 ],  
  
    [field1 = 1, field2 = 2 ]  
  
}, "test")  
  
equals  
  
{  
  
    [field1 = "test1", field2 = "test2" ],  
  
    [field1 = "another test", field2 = 5 ]  
  
}  
  
List.FindText(  
  
{  
  
    [ Field1 = "hello", Field2 = "world" ],  
  
    [ Field1 = "hello1", Field2 = "hello2" ],  
  
    [ Field1 = "another test", Field2 = 5 ],  
  
    [ Field1 = 1, Field2 = 2 ]  
  
}, "hello")  
  
equals  
  
{  
  
    [Field1="hello", Field2 = "world"],  
  
    [Field1 = "hello1", Field2 = "hello2"]  
  
}  
© 2018 Microsoft