web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Display records in gal...

Power Apps

Suggested Answer

Display records in gallery in the same order as in SP list

(1) Share

Report

Report

Posted on by MP-13011217-0

158

Hello!

I have a SP list with records where I can move a record by dragging it down or up - change it's position in a list. All of orders have it's ID number and I noticed that when I view my list on the app, the gallery is displaying my SP list in order by ID number. How do I view this list in gallery in the same order as it is in SP list, please?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Mitanshu 1,656 Moderator on at

Like (0)

Report
Copy link

Link copied!
If your SharePoint list does not already have a field to track the custom order (since users can drag and drop), you should add a "Position" or "Order" column to your SharePoint list. This column can be a Number field where you manually or programmatically set the order for each record.

If you allow users to drag and drop records, you’ll need to update the "Position" column to reflect the new order.

You need to modify the Items property of the gallery to order the records based on the "Position" column instead of the default ID.

SortByColumns(YourSharePointListName, "Position", Ascending)

Was this reply helpful? Yes No
WarrenBelz 155,212 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MP-13011217-0

SharePoint "order" is by default sorted by the ID. I suspect your SharePoint view is sorted by another field and you need to sort in Power Apps by the same field/s

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No

Join the conversation