List.ContainsAny
Indicates where a list includes any of the values in another list.
function (list
as list,values
as list, optionalequationCriteria
as nullable any) as logical
Indicates whether the list
list
includes any of the values in another list, values
. Returns true if value is found in the list, false otherwise. An optional equation criteria value, equationCriteria
, can be specified to control equality testing.List.Membership functions
Find out if the list {1, 2, 3, 4, 5} contains 3 or 9.
List.ContainsAny({1, 2, 3, 4, 5}, {3, 9})
true
Find out if the list {1, 2, 3, 4, 5} contains 6 or 7.
List.ContainsAny({1, 2, 3, 4, 5}, {6, 7})
false
Last modified 4yr ago