List.Distinct

Syntax

List.Distinct(list as list, optional equationCriteria as any) as list

About

Returns a list that contains all the values in list list with duplicates removed. If the list is empty, the result is an empty list.

Example 1

Remove the duplicates from the list {1, 1, 2, 3, 3, 3}.

List.Distinct({1, 1, 2, 3, 3, 3})
1
2
3