On Power Apps, I have a dashboard to display all orders made by users. The dashboard is to let users know their order status either their order is in "In Preparation", "Order Received" or "Completed" status. I am using SharePoint List as the data source. Below is the dashboard I have created.
There are two conditions that I like the dashboard to follow.
Order Date & Time: The latest order made by user will lead the flow of the menu on the dashboard screen. In this case, SMT 1 is the first order created by users and in SPL. Thus, dashboard will display the order made by SMT 1 first. Order Urgency: There are two levels of order urgency: Normal and Urgent. In this case, Urgent orders will override the order in first condition. For example, SMT 3 and SMT 4 orders. Even though SMT 3 made the order ahead than SMT 4, I would like the dashboard gives the priority to SMT 4 and display SMT 4 orders first, followed by SMT 3.
I am using gallery and container to make the dashboard anyway.
I`d appreciate if any of you guys could lend me some help and show me guidance on the solution to this issue.
Thank you.
1 Answer
You have to use the SortByColumns() function in Power Apps for such requirements.
For example, you can use the formula like below:
SortByColumns(
SPListName,
"OrderUrgency",
SortOrder.Descending,
"OrderDateTime",
SortOrder.Ascending
)
Where OrderUrgency and OrderDateTime are the internal names of your SharePoint list columns. You can get the internal name of your column by following this article: How to find the Internal name of columns in SharePoint Online?
