← Back to Table functions

Table.FindText

Returns a table that includes only the rows containing the specified text in any part of their cells.

Syntax

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

About

Returns a table that includes only the rows containing the specified text in any part of their cells.

Explanation

Identify the rows in the table that include the name "Bob". Use the Power Query function MTable.FindText with the Table.FromRecords command to achieve this. The table consists of several rows with customer information such as ID, name, and phone number. The function will search for the name "Bob" in the table and return the row that contains this name. The output will display the row with CustomerID 1, Name "Bob", and Phone number "123-4567".