Table.FindText

Table.FindText
Returns all the rows that contain the given text in the table.
function (table as table, text as text) as table
Description
Returns the rows in the table table that contain the text text. If the text is not found, an empty table is returned.
Category
Table.Row operations
Examples
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"]})

Table.FilterWithDataTable

Table.First

Last modified 4yr ago