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.
71 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?
