Returns a list of values from the input list that contain the specified text value.
Syntax
List.FindText(list as list, text as text) as list
About
Returns a list of values from the input list that contain the specified text value.
Explanation
Locate the text values in the list {"a", "b", "ab"} that contain the text "a". To achieve this, use the Power Query MList.FindText function as follows: MList.FindText({"a", "b", "ab"}, "a"). The result will be: {"a", "ab"}.