List.ContainsAny(list as list, values as list, optional equationCriteria as 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.

Reference Data

Power Query M Functions / List Functions / List.ContainsAny