I have a SharePoint list that is essentially a ToDo list tracking all of the assignments that come in from the business (chose Sharepoint because it was more flexible/customizable). The list is accessed on a daily basis by leadership to rank priorities. The priorities are integer values and sometimes the team lists up to 20 or 30 priorities. If they change #15 to #1 then they need to go back and fix the rankings of the first 14, which doesn't happen often. Ultimately what ends up happening to avoid renumbering is we get priority 1.1, 1.7, 5, 5.1, etc.
I am looking for a way to automate the renumbering process and make it so the priorities are 0 decimal point #s. I thought about trying to add a formula to the Priority field, but wasn't sure what it would be or how it would force the unique values. So, I started a power automate workflow that kicks off at the end of the day and adds the rank value to an array for the items created/modified that day, but I am stuck on how to compare the array to the list rankings and adjust them accordingly. Any thoughts on how to create that loop (or a better way to force unique, auto-incrementing numbers in sharepoint) is appreciated!
