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}
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for