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

List.FindText

Owen Duncan|Last Updated: 4/19/2018

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