List.FindText

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

Syntax

List.FindText(
   list as list,
   text as text,
) as list

Description

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

Examples

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: https://learn.microsoft.com/en-us/powerquery-m/list-findtext