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

(1) Share

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 (2)

Answers (0)

Suggested answer

Mitanshu 1,650 Moderator on at

Like (0)

Report
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 153,084 Most Valuable Professional on at

Like (0)

Report

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