Sort Gallery by multiple columns

(0) Share

Report

Posted on by tengilrachid

I have a gallery that i filtered by 2 dropdown plus a searchbox, i would like to add 6 Sort icons like below:

Here is my Gallery items :

Filter(

If( Filtersttyp.Selected.Result="Alla" And Filterprio.Selected.Result="Alla",Avtal,
Filtersttyp.Selected.Result="Alla" And Filterprio.Selected.Result<>"Alla",
Filter(Avtal,Avtalsprioritet.Value=Filterprio.Selected.Result),
Filtersttyp.Selected.Result<>"Alla" And Filterprio.Selected.Result="Alla",
Filter(Avtal,Avtalstyp.Value=Filtersttyp.Selected.Result),
Filtersttyp.Selected.Result<>"Alla" And Filterprio.Selected.Result<>"Alla",
Filter(Avtal,Avtalsprioritet.Value=Filterprio.Selected.Result And Avtalstyp.Value=Filtersttyp.Selected.Result)),

StartsWith(Title, SearchBox.Text))

Hope that you help me to add those 6 Sort icons! Appreciate your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tengilrachid ,

1\ Set the onvisible property of your screen:

Set(Thevar2,true)

2\ You could use this formula on the onselect property of each Sort icon:

Icon1: Set(Thevar,1);Set(Thevar2,!Thevar2)

Icon2: Set(Thevar,2);Set(Thevar2,!Thevar2)

...

3\ You could use a similar formula on the items property of the gallery:

If(Thevar=1,If(Thevar2,SortByColumns(LIST139,"Title",Ascending),SortByColumns(LIST139,"Title",Descending)),Thevar=2,If(Thevar2,SortByColumns(LIST139,"Test",Ascending),SortByColumns(LIST139,"Test",Descending)),LIST139)

You could use this formula

to replace my LIST139.

Also, please replace my column name with your column name.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
tengilrachid 13 on at

Like (0)

Report
Copy link

Link copied!

. its not working with choices column (Would you like to add a choice column to LIST139 and provide Gallery items)
2. How can i add Sorting : If(Thevar=1,If(Thevar2,SortByColumns(Avtal,"...... to my filter
Filter(
If( Filtersttyp.Selected.Result="Alla" And Filterprio.Selected.Result="Alla",Avtal,
Filtersttyp.Sele.............

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

if your database have less than 2000 record you can use SortByColumn. Code will be simple.

Was this reply helpful? Yes No