Sort Button to Sort Due Dates

(0) Share

Report

Posted on by kat7777777

112

Happy Friday!

I have created an action tracker within PowerApps. I have a due date column on my SP list. I am wanting to have a sort button on my gallery that when selected will sort all of the actions by their due dates. The ones closer to being due being at the top. What should I add into my OnSelect property of my button? Do I also need to add something else into my gallery's items as well? Thanks in advance!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kat7777777

On your OnSelect propety your code should look like:
SortByColumns( <SP LIST>, "DueDate", SortOrder.Descending )

The Sort function sorts a table based on a formula.
The SortByColumns function can also be used to sort a table based on one or more columns.

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
AndrewR1 1,572 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kat7777777 The On Select Property of your button I would do something like setting a contextual variable:
UpdateContext({DueDate:!DueDate})
Then in you gallery Items Property I assume you using a SortByColumns you would need to add the following:
SortByColumns( YouSPList, "DueDate", If(DueDate,SortOrder.Descending,SortOrder.Ascending) )
This will then give you the ability to switch between the descending and ascending order.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew
kat7777777 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, This is what I currently have in the items property of my gallery. Filter( [@'101 HR Action Tracker'], (Progress.Value = "Not Started" || Progress.Value = "In Progress") && (IsBlank(Dropdown1.Selected) || CategoryDuplicate = Dropdown1.Selected.Value) ) I have a drop down in place is why it is entered this way. When I try to add in the additional coding you provided, I receive an error. Do you have any advice?
PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
The Syntax would look like this

SortByColumns( YouSPList, "DueDate", If(DueDate,SortOrder.Descending,SortOrder.Ascending) )

Replace YouSPList with your Filter function
Verified answer

AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @kat7777777 you will just replace yourSPList with your filter:

SortByColumns( Filter( [@'101 HR Action Tracker'], (Progress.Value = "Not Started" || Progress.Value = "In Progress") && (IsBlank(Dropdown1.Selected) || CategoryDuplicate = Dropdown1.Selected.Value)), "DueDate", If(DueDate,SortOrder.Descending,SortOrder.Ascending) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew