Share via


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}.

Usage

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

Output

{1, 2, 3}

Equation criteria