
Bit of an unusual one; but I am looking at a solution to manage physical records, which are ordered in a specific way.
I have the sort order set, but I'm looking for the SharePoint list to also show a 'position number' of each item - so that when browsing the data you can easily find the corresponding physical item.
My thinking is a Flow that looks at the SharePoint data, and applies a number to a 'position' column in each record in sequence based on the sort order I set - if that makes sense?
i.e with an alphabetical sort...
Apples, Pears, Bananas
...would become...
1 Apples, 2 Bananas, 3 Pears
Add in another record and the Flow would re-number the list:
1 Apples, 2 Bananas, 3 Kiwis, 4 Pears
Would appreciate any ideas as to how I could achieve this. Thanks!