List.FindText

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

Syntax

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

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

Find the text values in the list {"a", "b", "ab"} that match "a".

List.FindText({"a", "b", "ab"}, "a")

Result:

{"a", "ab"}