How to add multiple Sorts on a Gallery

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

I was following this video here:

https://www.youtube.com/watch?v=8bNCBe2wzYI

I have a gallery, that is pulling from my Engineers table.

So my thinking was, as there are two different teams mixed in there.

If I click the button that says EXO, it changes the variable below:

Set(var_engineertype,"Online")

Clicking the other will change it to "On-Prem"

In the items of my gallery, I have this:

Filter(Engineers,EngineerType.Value=var_engineertype)

This is working as expected. It switches the engineers.

I am having trouble figuring out the filtering AND MULTIPLE Sorting.

So for my onvisible screen, I ahve this:

Refresh(Engineers);
UpdateContext({var_Eng:Blank()});
UpdateContext({var_TotalCasesSort:Blank()});
UpdateContext({var_TotalCrits:Blank()});
UpdateContext({var_LastAssigned:Blank()});
UpdateContext({var_LastCritAssigned:Blank()});
If(!IsBlank(var_Eng),SortByColumns(Engineers,"EngineerDisplayName",If(var_Eng=true,Ascending, Descending)));
If(!IsBlank(var_TotalCasesSort),SortByColumns(Engineers,"TotalAssigned",If(var_TotalCasesSort=true,Ascending, Descending)));
If(!IsBlank(var_TotalCrits),SortByColumns(Engineers,"CritAssigned",If(var_TotalCrits=true,Ascending, Descending)));
If(!IsBlank(var_LastAssigned),SortByColumns(Engineers,"LastAssigned",If(var_LastAssigned=true,Ascending, Descending)));
If(!IsBlank(var_LastCritAssigned),SortByColumns(Engineers,"LastCritAssigned",If(var_LastCritAssigned=true,Ascending, Descending)));

On each of my Sort Icons, I ahve this:

UpdateContext({var_TotalCasesSort:Blank()});
UpdateContext({var_TotalCrits:Blank()});
UpdateContext({var_LastAssigned:Blank()});
UpdateContext({var_LastCritAssigned:Blank()});
UpdateContext({var_Eng:!var_Eng});

So my thinking was, each time I click on a Sort above a specific Column, it would blank the other variables out, and sort that specific column Ascending or Descending, depending on true or false.

This was not working.

I am starting to think I have to change the items portion of the gallery WITH my sorting.

That is where I am getting lost.

Anyone help with setting this up?

I want to be able to sort by engineer type first to fill the gallery with those specific engineers.

Then, be able to sort the columns just by clicking on the specific Icons. Not combing the sorting just either sort by Engineer, or Sort by Total Cases, etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@lardo5150

Hi again (and yes, I still have your other post to respond to...will do shortly!)

So, you have some things in your OnVisible formula that do nothing and will only slow down your app.

Things like:

If(!IsBlank(var_Eng),SortByColumns(Engineers,"EngineerDisplayName",If(var_Eng=true,Ascending, Descending)));

Will actually do nothing. SortByColumns returns a table, you are not using that table for anything nor assigning it to anything...so, it is just app cycles that are wasted.

You don't need all of those variables for what you are trying to do.

And, Yes, you will need to be focused on the Items property of your Gallery.

In general, for the sort icons of your columns, you will have the following formula:

With({_colName: "<columnNameHere>", _defaultSortAscending: true}, UpdateContext({lclSortAscending: If(lclSortColumn= _colName, !lclSortAscending, _defaultSortAscending) } ); UpdateContext({lclSortColumn: "<columnName>"});

Then your Gallery Items property would become:

SortByColumns(Engineers, lclSortColumn, If(lclSortAscending, Ascending, Descending) )

To avoid dealing with setting variables initially...change the formula to this:

SortByColumns(Engineers, Coalesce(lclSortColumn, "<defaultSortColumn>"), If(Coalesce(lclSortAscending, true), Ascending, Descending) )

Just replace the defaultSortColumn with the name of the column you want to sort by default. And change true to false if you want descending by default.

I hope this is helpful for you.

Was this reply helpful? Yes No
lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

dude, you are a machine.
I had to modify some of that to get it to work exactly how I wanted, but it is ALL working!
I just "bought you a cup of coffee".... 🙂

Was this reply helpful? Yes No