Power Query
Search…
List.FindText

List.FindText

Returns a list of values (including record fields) that contain the specified text.
function (list as list, text as text) as list

Description

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

Category

List.Selection

Examples

Find the text values in the list {"a", "b", "ab"} that match "a".
1
List.FindText({"a", "b", "ab"}, "a")
Copied!
{"a", "ab"}
Last modified 3yr ago