← Back to List functions

List.MatchesAny

This function returns true if any of the values in the provided list meet the specified condition function. Otherwise, it returns false.

Syntax

List.MatchesAny(list as list, condition as function) as logical

About

This function returns true if any of the values in the provided list meet the specified condition function. Otherwise, it returns false.

Explanation

Determine whether any of the values in the list {9, 10, 11} are greater than 10 using the Power Query M function List.MatchesAny. The output will be true. On the other hand, when checking if any of the values in the list {1, 2, 3} are greater than 10 using the same function, the output will be false.