Power Query
published
Search
K
Comment on page

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".
List.FindText({"a", "b", "ab"}, "a")
{"a", "ab"}