List.IsDistinct
Indicates whether there are duplicates in the list.
function (listas list, optionalequationCriteriaas nullable any) as logical
Returns a logical value whether there are duplicates in the list
list; true if the list is distinct, false if there are duplicate values.List.Selection
Find if the list {1, 2, 3} is distinct (i.e. no duplicates).
List.IsDistinct({1, 2, 3})
true
Find if the list {1, 2, 3, 3} is distinct (i.e. no duplicates).
List.IsDistinct({1, 2, 3, 3})
false
Last modified 4yr ago