Power Query
Search…
List.AnyTrue

List.AnyTrue

Returns true if any expression is true.
function (list as list) as logical

Description

Returns true if any expression in the list list is true.

Category

List.Membership functions

Examples

Determine if any of the expressions in the list {true, false, 2 > 0} are true.
1
List.AnyTrue({true, false, 2>0})
Copied!
true
Determine if any of the expressions in the list {2 = 0, false, 2 < 0} are true.
1
List.AnyTrue({2 = 0, false, 2 < 0})
Copied!
false
Last modified 3yr ago