List.Sort Function in Power Query

The List.Sort function returns a sorted list using the optional comparison criterion.

Syntax

List.Sort(list as list, optional comparisonCriteria as any) as list

Example: Sort the given list.

Power Query M

let
  Source = {"India", "America", "Canada", "Japan", "Australia", "England"}, 
  Return = List.Sort(Source)
in
  Return

The output of the above code is shown below:

List.Sort function in Power Query
Previous Next