SORT A Collection By One Or More Columns

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/sort-a-collection-by-one-or-more-columns/. Author: Matthew Devaney.

SORT A Collection By One Or More Columns Input collection: myCities35 City Country Population Los Angeles United States 4000000 Toronto Canada 2930000 New York United States 8500000 Vancouver Canada 1780000

Output collection: mySolution35a (sort by Highest to Lowest Population) City Country Population New York United States 8500000 Los Angeles United States 4000000 Toronto Canada 2930000 Vancouver Canada 1780000 Solution code: //Create a collection

ClearCollect(myCities35, {City: Los Angeles , Country: United States , Population: 4000000 }, {City: Toronto , Country: Canada , Population: 2930000 }, {City: New York , Country: United States , Population: 8500000 }, {City: Vancouver , Country: Canada , Population: 1780000 } ); //Sort by column code

ClearCollect(mySolution35a,Sort(myCities35,Population,Descending)); Code language: PHP ( php )

Output collection: mySolution35b (sort by Country and Population) City Country Population Toronto Canada 2930000 Vancouver Canada 1780000 New York United States 8500000 Los Angeles United States 4000000 Solution code: //Create a collection

ClearCollect(myCities35, {City: Los Angeles , Country: United States , Population: 4000000 }, {City: Toronto , Country: Canada , Population: 2930000 }, {City: New York , Country: United States , Population: 8500000 }, {City: Vancouver , Country: Canada , Population: 1780000 } ); //Sort by multiple columns code

ClearCollect( mySolution35b, SortByColumns(myCities35, Country ,Ascending, Population ,Descending) ); Code language: PHP ( php )