Sort Button to Sort Due Dates

(0) Share

Report

Posted on by kat7777777

106

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

I have the same question (0)

All responses (5)

Answers (1)

SpongYe 5,609 Super User 2025 Season 2 on at

Like (0)

Report
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! 🍻

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
kat7777777 106 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report
The Syntax would look like this

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

Replace YouSPList with your Filter function

Was this reply helpful? Yes No
Verified answer

AndrewR1 1,572 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No