List.IsDistinct
Syntax
List.IsDistinct(list as list, optional equationCriteria as any) as logical
About
Returns a logical value whether there are duplicates in the list list; true if the list is distinct, false if there are duplicate values.
Example 1
Find if the list {1, 2, 3} is distinct (i.e. no duplicates).
Usage
List.IsDistinct({1, 2, 3})
Output
true
Example 2
Find if the list {1, 2, 3, 3} is distinct (i.e. no duplicates).
Usage
List.IsDistinct({1, 2, 3, 3})
Output
false