Power Apps Sort Gallery By Calculated Field

Can gallery items be sorted by the Calculated field in Power Apps? Yes, we can sort the records by the Calculated field. This tutorial is all about the Power Apps sort gallery by calculated field.

This Power Apps tutorial will explain the Power Apps sort gallery by calculated field. Like:

  • How to sort Power Apps gallery by SharePoint calculated field
  • Sort Power Apps gallery by calculated field from a collection

Power Apps Sort Gallery by Calculated Field From SharePoint

Here, we will discuss how to sort the Power Apps gallery by SharePoint calculated field with a simple scenario:

Scenario:

I have a SharePoint Online list named “Travel Requests” that contains the below columns:

  • Trip Title = It is a default single line of text; I just renamed it as “Trip Title”
  • Airline = This is a location field
  • Estimated Airline = It is a Number field that contains the total number of recovered cases
  • Estimated Hotel Cost = This is a “Calculated field” that calculates the total number of unrecovered cases based on the confirmed and recovered fields
  • Total Estimated Amount = This is a “Calculated field” that calculates the sum of Estimated Airfare and Estimated Hotel Cost.

Refer to the below screenshot:

powerapps sort gallery control by SharePoint list calculated field
  • To add a Calculated field [Total Estimated Amount] in the SharePoint list, follow the code below, which calculates the value based on two other fields as shown below.
Formula:  =[Estimated Airfare]+[Estimated Hotel Cost]
how to sort gallery by calculated field in powerapps
  • Now, I want to sort all these calculated values in descending order and display all the records on the Power Apps gallery control, as in the screenshot below.
how to sort gallery by sharepoint calculated field in powerapps

To achieve it, follow the steps below. Such as:

See also  How to Patch Power Apps Collection to SharePoint List?

1. Create Power Apps Canvas app using the respective SharePoint list -> Select the Power Apps Screen -> Insert a Gallery control and set its Items property to the code below.

Items = SortByColumns(
    'Travel Requests',
    "TotalEstimatedAmount",
    SortOrder.Descending
)

Where,

  • ‘Travel Requests’ = SharePoint Online List
  • “TotalEstimatedAmount” = SharePoint Calculated Field
how to sort gallery by sharepoint list calculated field in powerapps

2. Save, Publish, and Preview the app. The Power Apps gallery will sort and display each record from the SharePoint list based on the calculated field descending order, as shown below.

how to sort gallery by calculated field in powerapps app

This is how to work with Power Apps sort gallery by SharePoint calculated field.

Power Apps Sort Gallery by Calculated Field [From Collection]

Next, we will see how to sort a Power Apps gallery by calculated column using a collection.

Example:

I have created a Power Apps collection named “colProducts” using my SharePoint list, i.e., [Order Details], as in the screenshot below.

how to sort powerapps gallery by calculated field

Now, I want to add a Calculated column [“Total Amount“] to the Power Apps collection. Also, sort [Either ascending or Descending], and display the collection records on a gallery control based on the calculated field.

Refer to the below screenshot:

how to sort powerapps gallery control by calculated field

To work around this example, follow the below steps.

1. Go to Power Apps app -> Select the App object and set its OnStart property as:

OnStart = ClearCollect(
    colProducts,
    'Order Details'
)

Where,

  • colProducts = Power Apps Collection Name
  • ‘Order Details’ = SharePoint Online List

2. Then, click on the App’s Run OnStart button to get the Power Apps collection as shown below.

how to sort gallery control by calculated field in powerapps

3. I want to add a calculated field [Total Amount] to the Power Apps collection using the code below.

OnStart = ClearCollect(
    colfinal,
    AddColumns(
        colProducts,
        "Total Amount",
        ThisRecord.Quantity * ThisRecord.Price
    )
)

Where,

  • colfinal = Power Apps 2nd collection name
  • AddColumns() =This function can help to add a column to a table, and the formula specifies the value in that column
  • colProducts = Power Apps 1st collection name
  • “Total Amount” = Calculated column name
  • ThisRecord.Quantity * ThisRecord.Price = This is a logical test to get the values from other respective fields
sort gallery control by calculated field in powerapps

4. Again, click on the App’s Run OnStart button to get the Power Apps collection, as shown below.

sort gallery by calculated field in powerapps

5. Now, go to the Power Apps Screen -> Insert a Gallery control and set its Items property to get the calculated field below.

Items = colFinal
sorting a powerapps gallery control by calculated field

6. But, our requirement is sorting a gallery control by calculated column. For that, insert a Sort icon and set its OnSelect property as:

OnSelect = Set(
    varColumn,
    "Total Amount"
);
Set(
    varOrder,
    If(
        varOrder = SortOrder.Ascending,
        SortOrder.Descending,
        SortOrder.Ascending
    )
)

Where,

  • varColumn, varOrder = Power Apps Variable Names
sorting a powerapps gallery by calculated field

7. select Gallery control and change its Items property to the code below.

Items = SortByColumns(
    colfinal,
    varColumn,
    varOrder
)
how to sorting a powerapps gallery control by calculated field

8. Save, Publish, and Preview the app. The gallery control will sort and display each record from the Power Apps collection by clicking a sort icon [Either ascending or descending], as in the screenshot below.

how to sorting a powerapps gallery by calculated field

This is all about how to sort a Power Apps gallery by calculated field.

See also  Power Apps Barcode Scanner - How to Use

Conclusion

From this Power Apps tutorial, we learned all the information about the Power Apps sort gallery by calculated field, like:

  • How to sort Power Apps gallery by SharePoint calculated field
  • Sort Power Apps gallery by calculated field [From Collection]

You may also like:

>