Indicates where a list includes all the values in another list.
function (
list
as list,values
as list, optionalequationCriteria
as nullable any) as logical
Indicates whether the list list
includes all 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 and 4.
List.ContainsAll({1, 2, 3, 4, 5}, {3, 4})
true
Find out if the list {1, 2, 3, 4, 5} contains 5 and 6.
List.ContainsAll({1, 2, 3, 4, 5}, {5, 6})
false