List.FindText Function in Power Query

The List.FindText function searches a list of values, including record fields, for a text value.

Note: The List.FindText function is case-sensitive.

Syntax

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

Example:

Power Query M

let
  Source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  Return = List.FindText(Source, "ca")
in
  Return

The output of the above code is shown below in the following image:

List.FindText function in Power Query
Previous Next