Updated on

List.FindText is a Power Query M function that finds values in a list containing a specified text value. The function returns a list of values that include the given text value.

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


   list as list,
   text as text,
) as list


Returns a list of the values from the list list which contained the value text.


Find the text values in the list {“a”, “b”, “ab”} that match “a”.

// Output: {"a", "ab"}
List.FindText( {"a", "b", "ab"}, "a" )

Learn more about List.FindText in the following articles:

Other functions related to List.FindText are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: