Power Query
published
Search
K
Comment on page

List.Contains

List.Contains

Indicates whether the list contains the value.
function (list as list, optional value as nullable any, optional equationCriteria as nullable any) as logical

Description

Indicates whether the list list contains the value value. Returns true if value is found in the list, false otherwise. An optional equation criteria value, equationCriteria, can be specified to control equality testing.

Category

List.Membership functions

Examples

Find if the list {1, 2, 3, 4, 5} contains 3.
List.Contains({1, 2, 3, 4, 5}, 3)
true
Find if the list {1, 2, 3, 4, 5} contains 6.
List.Contains({1, 2, 3, 4, 5}, 6)
false