web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Updating SharePoint li...
Power Apps
Answered

Updating SharePoint list sorting via list item update

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @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?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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. 

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    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 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

     

    This works great. Thanks for your help!

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @MAV_CB 

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard