Sort the PowerApps Data/Collection by Specific Column On Click

In PowerApps, we can use the SortByColumn functions to sort the Items/Table by specific column.

We will run how to sort the table by specific column On button click.

1. I have a sample Product SampleData excel sheet with below columns, which is hosted on OneDrive business.
2. I have already created a basic PowerApp with Products Sample Data
3. Add the  Sort icon from Icons  on the header, where I added the UpdateContext formula against the onSelect property, which create a context variable for current screen.
   UpdateContext({SortByOrder:!SortByOrder})

   1	UpdateContext({SortByOrder:!SortByOrder})

    

4. Added the Products item in Gallery view, where I added the SortByColumns formula against the Items property and Sorting by “Item” column. We can sort items with multiple columns like

   ClearCollect( SortByQuantity, SortByColumns( Table1, “Item”, Ascending, “Total”, Descending ) )

   SortByColumns FORMULA PowerApps

   //FORMULA SortByColumns( Table, ColumnName, SortOrderTable ) //Implementation SortByColumns(Table1, "Item", If(SortByOrder, Descending, Ascending))

   1 2 3 4 5 6

   //FORMULA SortByColumns( Table, ColumnName, SortOrderTable )     //Implementation SortByColumns(Table1, "Item", If(SortByOrder, Descending, Ascending))

   

5. Now run the App, you will in Ascending order (SortOrder.Ascending is the default), now Click on the Sort Icon it will sort item by Decreasing order. See below screenshot