Answered

Advanced sort by date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to apply sorting to my items in the gallery. Here is the formula in my sort ↑↓ button:

UpdateContext({varSort: !varSort})

and here in my item gallery:

SortByColumns(Filter(Ticket, User().Email = Requestor.Email , "Modified",If(varSort = true, Descending))

by default the item will be sort using modified date.

So now, I wanted to add the option for the user to sort between Modified and Created date when sorting. I have added two buttons as such:

Set(toggleModified, false);Set(toggleCreated, true)

But I can't seem to work and combine the formulas or are there any easier workaround to do this? Thank you in advanced!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

If you only have two sort options, you only need one toggle

Sort( Filter( Ticket, Requestor.Email=User().Email ), If( ToggleModified, Modified Created, ), If( varSort, Descending, 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. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Thank you so much it works well and simple enough!

Was this reply helpful? Yes No