Unanswered

Browsescreen sort with two IconsSort buttons

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello powerapps community!

I have seen some similar questions and answers for my problem on this forum, but i didn't understand them fully.

I have a browsescreen in my app which is sorted descending by "ID" on the moment. This is fine as default , but I also want the possibility to sort on date. It is important that the user must be able to switch back to sorting (descending/ascending) on "ID" as well. I think I need two IconSort buttons for this but I dont know ho to proceed from there. Anybody who can use his magic to help me?

Cheers,

Tata66

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Follow this :
https://powerusers.microsoft.com/t5/Building-Power-Apps/Issues-with-multiple-sort-options-on-gallery/m-p/410157
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you!

I have some questions though.

What are the SiteVisitDetails and SVTList in this?
Concurrent(ClearCollect(collAllSiteVisitDetails, SiteVisitDetails), ClearCollect(collAllSVTDetails, SVTList));

I am using a SP list with colummns.
I was also wondering what the "fac" is doing ?
Set(LastSort, "fac");

Cheers
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

For the clearcollect, you can ignore it. But if you are using a collection then you c an look at it. The fac is just a word they used in the visible variable, you can change to any word
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ：
Do you want to sort the records based on the two IconSort buttons？
Do you want to implement the following functions：
Default: The records will be sorted by "ID" .
Select Button1: The records will be sorted by "Date" .
Select Button2: The records will be sorted by "ID" .
I think the solution mentioned by @eka24 can solve your problem. I have reorganized it for you.
Step1:add a button(Date) and set it’s Onselect property to:

UpdateContext({DateSort:!DateSort}); /* “DateSort” is a custom environment variable that can be changed to “true” or “false”*/ UpdateContext({LastSort: "Y"}) /* “LastSort” is a custom environment variable. The value of “LastSort” is used to be a analyzing conditions of the If() function */

Step2: add a button(ID) and set it’s Onselect property to:

UpdateContext({IDSort: !IDSort}); UpdateContext({LastSort: "N"})

Step3: add a gallery and set it’s items property to:

If( LastSort = "Y", Sort( Test1, /*use your data source here*/ MYDATE, /*use your field name ”Date” here*/ If( DateSort, Descending, Ascending ) ), Sort( Test1, /*use your data source here*/ MYID, /*use your field name ”ID” here*/ If( IDSort, Descending, Ascending ) ) )

Beat Regards,
Bof