List.FindText

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" )

Related articles

Learn more about List.FindText in the following articles:

• Lists in Power Query M / List Functions (200+ Examples)
  The complete guide to Lists in Power Query M. Learn from practical examples and master Power Query’s most powerful List functions. » Read more

Related functions

Other functions related to List.FindText are:

• List.Alternate
• List.First
• List.FirstN
• List.Last
• List.LastN
• List.Max
• List.MaxN
• List.Min
• List.MinN
• List.Range
• List.Repeat
• List.Select

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