List.ContainsAny

Syntax

List.ContainsAny(list as list, values as list, optional equationCriteria as any) as logical

Description

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

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.ContainsAny