Answered

Sort UpDown icon

(0) Share

Report

Posted on by Sdjackson

Hi, I am struggling to get the Sort icon within the Browse Screen to work. On Start for the PowerApp I have set a variable as the user email and then have a function in the Gallery which means the user can only display their own entries: Filter('Purchase Order', CreatorEmail = varUser.Email). This was necessary since the entries staff are making are for sickness/absence and are sensitive.

I can't then get the Sort UpDown to work as this isn't doing anything. Currently it's OnSelect is: UpdateContext({SortDescending1: !SortDescending1})

I would like to sort based on 'Created' which is an entry in the SharePoint List but don't know what language to use. Can anyone help me?

Stuart

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sdjackson

You need to wrap your filter with a SortByColumns() and replace the column you wish to sort by in double quotes where I have "SortingColumn"

SortByColumns(Filter('Purchase Order', CreatorEmail = varUser.Email),"SortingColumn", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

To reverse the starting sort order in the toggle, put this formula in the Items property of the gallery.

SortByColumns(Filter('Purchase Order', CreatorEmail = varUser.Email),"SortingColumn", If(SortDescending1, SortOrder.Ascending, SortOrder.Descending))

To explain how this works, the double arrow Icon creates a context variable called SortDescending1 (although it could be anything).

UpdateContext({SortDescending1: !SortDescending1})

The toggle effect is produced by using var:!var, it is in effect saying if the variable is currently var, then make it the opposite ie. Not(var)
Sdjackson 97 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for replying. You've certainly helped my understanding (thank you) but I'm not quite there. I changed the Browse Gallery Items to be SortByColumns(Filter('Purchase Order', CreatorEmail = varUser.Email), Created, If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
Created is the date time stamp for each entry.
But, when I do that the Gallery view becomes blank and I get the following error:
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Sdjackson

Created needs to be in double quotes.

SortByColumns(Filter('Purchase Order', CreatorEmail = varUser.Email), "Created", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
Sdjackson 97 on at

Like
a
(0)

Report
Copy link

Link copied!

You're a genius. Thank you, I've learned and fixed the issue thanks to you.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!