Comment on page
Table.FindText
Returns all the rows that contain the given text in the table.
function (table
as table,text
as text) as table
Returns the rows in the table
table
that contain the text text
. If the text is not found, an empty table is returned.Table.Row operations
Find the rows in the table that contain "Bob".
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")
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"]})
Last modified 5yr ago