Answered

Updating SharePoint list sorting via list item update

(0) Share

Report

Posted on by Community Power Pla...

Working with a SharePoint list that has a custom sorting order based on a number column. As a user, I want to be able to re-order the list items based on that Sort Order column value changing. So for example, if I have 3 rows, with a Sort Order value of 1,2 and 3 respectively, I want to update the 2nd row's Sort Order value to equal 3, and simultaneously make the 3rd row have a new sort order value of 2.

Clear as mud? Please let me know if anyone has tackled this kind of challenge before. I want to say the use of a ForAll function is somewhere in there but trying to work through the syntax.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MAV_CB

Yes, very clear. Question though...from a design perspective, are you planning to do this in a "arrow up" "arrow down" way, or from a arbitrary change of order?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Thanks Randy. Arrow up/arrow down way would be great from a UI perspective, but I'll take whatever method is practical.

Basically I have a list of 30+ questions broken out by Categories. So when I user is sorting the list of questions, they first would filter by Category, then re-arrange the questions in the order they want them displayed in.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Somewhat easier to demonstrate than to explain...

Attached is a sample app that demonstrates the reordering of a list.

It is UI based - meaning that the user initiates the action to change the order via up and down arrows.

Check the OnSelect actions of the up and down arrows. There is very little there, but it does what is needed.

I hope this is helpful.

@MAV_CB

MAV_CB.msapp

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Thanks @RandyHayes . Unfortunately I can't open the raw .msapp file. It needs to be exported from PowerApps environment and into a zip file.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MAV_CB

Please download the msapp file that was attached. Then go into PowerApps and either create a new app (doesn't matter what kind) or open an existing. Once in the designer, choose File, then Open and browse to the downloaded file. It will open, there is no export needed.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

*facepalm* Duh. Thanks, been a long week :).

This works great. Thanks for your help!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MAV_CB

LOL...no worries! Glad it helped out.

Was this reply helpful? Yes No