List.Contains
This function determines if a specified value is present in a given list. It will return true if the value is found, and false if it is not. Additionally, an optional value called equationCriteria can...
This function determines if a specified value is present in a given list. It will return true if the value is found, and false if it is not. Additionally, an optional value called equationCriteria can be provided to customize the equality testing process.
Determine whether the number 3 is included in the list {1, 2, 3, 4, 5}.
Usage:
Power Query MList.Contains({1, 2, 3, 4, 5}, 3)
Output:
true
----------------------------------------
Determine whether the number 6 is included in the list {1, 2, 3, 4, 5}.
Usage:
Power Query MList.Contains({1, 2, 3, 4, 5}, 6)
Output:
false