Gallery sorting not working

(0) Share

Report

Posted on by BCBuizer

22,505 Super User 2025 Season 2

Hi All,

I'm creating a gallery in which items can be sorted by the user using two arrow icons to move them up or down:

Pressing the icons updates a column called 'Sorting order', for instance:

OnSelect= Set(varSort,ThisItem.SortOrder);
Patch(collection,LookUp(collection,SortOrder=Text(Value(varSort+1))),{SortOrder:varSort});
Patch(collection,LookUp(collection,ID=ThisItem.ID),{SortOrder:Value(varSort)+1})

In turn, the gallery is sorted, based on the value of the Sort Order column:

Items = 
Sort(
 Filter(
 collection,
 IsBlank(LinkedDocument)
 ),
 "SortOrder",
 Descending
)

As you can see in the above picture, initially this gives the correct order (the number is ThisItem.'Sort Order'). When clicking on either of the item, the values of the Sort Order change correctly, yet the order of the items in the gallery doesn't (clicked 'Up' on the bottom, red item):

Can anybody give an idea of what should do to get the order of the item in the gallery to what it should be? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@BCBuizer

The trick is changing the proper records in your table and realizing that once you change one, then logic for the next on is missing.

Easier to demonstrate than to explain.

Please see the attached app. Download it and save it. Then in PowerApps, edit an existing app or create a new app, then then go to File -> Open Then Browse for the file you downloaded.

It is a full operational re-ordering gallery. The only formulas in it are on the OnSelect of the up and down arrows. The data used is created in the OnCheck action of Toggle1 in it. Nothing else going on.

Take a look and see if it is helpful for you.

GalleryReOrder.msapp

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hello Randy,

Thanks for the reply. I see your point, but I though I had addressed that.

When running your app the sorting works, but when I adapted the code for the arrows to my app, the result was the same.

OnSelect= With({_current: LookUp(collection, Value('Sort Order')=ThisItem.'Sort Order' +1)}, UpdateIf(collection, 'Sort Order'=ThisItem.'Sort Order', {'Sort Order': ThisItem.'Sort Order'+1}); Update(collection, _current, Patch(_current, {'Sort Order': ThisItem.'Sort Order'})); )

Could the issue be in the fact that 'Sort Order' is a text type column?
*Edit: I just changed the column type to number and it doesn't make a difference.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@BCBuizer

Your sort order should be numeric.

Your formula for the down arrow:

With({_current: LookUp(collection, 'Sort Order'=ThisItem.'Sort Order' +1)}, UpdateIf(collection, 'Sort Order'=ThisItem.'Sort Order', {'Sort Order': ThisItem.'Sort Order'+1}); Update(collection, _current, Patch(_current, {'Sort Order': ThisItem.'Sort Order'})); )

...is correct - except you should not be using the Value function on Sort Order.

This above should be giving you what you need.

If not, try to invoke the down button and then take a look at your collection to see what values it has for the two rows in question.

Also, just to be sure, your Items property on the Gallery should be:

Sort( Filter( collection, IsBlank(LinkedDocument) ), 'Sort Order' )

NOTE: This is an alteration of your original Items property as it was not correct.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Thanks Randy!

Turns out I was sorting by "SortOrder" instead of 'Sort Order'.... Thanks for pointing that out!

Was this reply helpful? Yes No