List.Distinct

Returns a list of values with duplicates removed.

Syntax

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

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.

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

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

Result:

{1, 2, 3}