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

Table.FindText

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table containing only the rows that have the specified text within one of their cells or any part thereof.

Table.FindText (table as table, text as text) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
textThe text to compare against.

Example

Table.FindText(Table.FromRecords(  

{  

      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  

      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  

      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  

      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  

}  

), "Bob")  
CustomerIDNamePhone
1Bob123-4567
© 2018 Microsoft