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".
List.FindText({"a", "b", "ab"}, "a")
{"a", "ab"}
Copy link
On this page
List.FindText
Description
Category
Examples