Labeling Items in a List in Order

(1) Share

Report

Posted on by CSilva

Hello, I currently have an application that collects hundreds of items into a SharePoint list. Although the items are tagged with numbers (SORTID) in ascending order, those numbers aren't always sequential (ex: 1, 2, 3, 6, 88, 100).

Recently, there has become a need to grab these records in the correct order, then update the SORTID to be in sequential ascending order (1, 2, 3, 6, 88, 100 needs to become 1, 2, 3, 4, 5, 6).

Is there a way to patch those items from start to finish in order? I have been trying to use an incrementing variable in a ForAll statement, but haven't had any luck.

Any help is greatly appreciated.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi CSilva,

This works here when tested.
With( { _Numbers: With( { _List: Sort( SPListName, SORTID ) }, ForAll( Sequence(CountRows(_List)), Patch( Index( _List, Value ), {NewNo: Value} ) ) ) }, Patch( SPListName, ForAll( _Numbers As _Data, { ID: _Data.ID, SORTID: _Data.NewNo } ) ) )

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 Buy me a coffee

Was this reply helpful? Yes No
CSilva on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the response, @WarrenBelz.

When I use the example you gave while working with a collection, I get an error stating, "The data source supplied to the function is invalid." Do you know why that is?

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

Like
a
(1)

Report
Copy link

Link copied!

Works fine here - I also used a collection (ensure there is an ID field in it). You only need to replace SPListName with your data source (two places). Also ensure that you have the SORTID numeric field in the table.

Was this reply helpful? Yes No