Gallery Search and Sort function

(0) Share

Report

Posted on by AshishJaiswal

776

Hi Experts,

I am using below formula

SortByColumns(Filter([@'datasourcesharepointlist'], StartsWith(Title,SearchBox.Text)), "Title", If(SortDescending1, Descending, Ascending))

Now this is only working to sort on one column (title column)

How can i sort on other columns ?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report

Instead of colum name in your gallery code use variable like "varColum"
and onClick of your sorting arrow update the variable with columname using UpdateContext. So whichever sorting icon you click column name will be changed according

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@zmansuri ,

Hello,

Thank you for replying to my post.

Could you guide me how to write it. I am not a developer. I just learn from youtube and blogs 😃

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

Like (1)

Report

Gallery:
SortByColumns(Filter([@'datasourcesharepointlist'], StartsWith(Title,SearchBox.Text)), varColumn, If(SortDescending1, Descending, Ascending))

Sorting Button Beside Name field:
OnClick:
UpdateContext({varSort :"Name"});
UpdateContext({SortDescending1:!SortDescending1});

Sorting Button Beside availability fields:

OnClick:
UpdateContext({varSort :"Availability "});
UpdateContext({SortDescending1:!SortDescending1});

In Short every time you click your sorting button beside field name. It will set the column name of that field in the variable varColumn
So in your gallery code where right now you have written "Title", which is why it is sorted by title. It will be varColumn instead of Title. And varColumn will change with buttoin click

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@zmansuri

Awesome this works but now I am running into a delegation issue of 500 items (My list has more than 3000 + items)

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

Like (0)

Report

unfortunately delegation will be there when using SortByColumns with variables. You can try this:
running different sorting based on condition. Like keep the code on sorting buttons same. But change your gallery code to this:
If(varColumn="Name",
SortByColumns(
Filter([@'datasourcesharepointlist'], StartsWith(Title,SearchBox.Text)), "Name", If(SortDescending1, Descending, Ascending)),
if(varColumn="Availability",
SortByColumns(Filter([@'datasourcesharepointlist'], StartsWith(Title,SearchBox.Text)), "Availability", If(SortDescending1, Descending, Ascending))))

and so on.. So instead of usinf variable directly in sorting logic. You are running different sorting logics based on condition.

Was this reply helpful? Yes No