Table.FindText

Updated on

Table.FindText is a Power Query M function that returns rows in a given table containing specified text. The function returns an empty table if the text is not found.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

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

Description

Table.FindText returns all the rows that contain the given text in the table. It searches for text in table and returns matching rows or an empty table if not found.

Examples

Find the rows in the table that contain “Bob”.

// Output: Table.FromRecords( {[CustomerID = 1, Name = "Bob", Phone = "123-4567"]} )
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"
 )

Other functions related to Table.FindText are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-findtext