Forum Discussion
Indexing Ideas Needed - Parts I.D. Order in Libraries : Ex.) Parts R1 thru R10, R2...
I do this quite regularly, although usually with a number column rather than anything alphanumeric. You'll need to build this with 2 flows in Power Automate. The first one (if you need it) to do the initial indexing. Then the second one which has a SharePoint "when a new item is created" trigger, gets the maximum part ID number, increments it by 1 then an update item action to set the letter and the new part number
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
I thank you for your great suggestions! I am at the novice level as far as Power Automate is concerned having used it in a limited way so far. I am willing to learn it to help resolve this SP library issue. Please provide any further insights based on the attempts at clarifying my issue below. Thanks again!
PROBLEM 1 & issue clarification: ONLY the part I.D. system is alphanumeric and was created by another with no leading zero(es) placeholder and before MS SharePoint was introduced (by me) last year.
PROBLEM 2: The part I.D.'s are added sporadically: There is no alpha or numeric order to their addition to or deletion from the library. Actually, this problem applies to a few other site libraries as well.
RESULT: The Number column value (number) then must be manually changed for each associated alphanumeric part I.D. to maintain the part I.D.'s in a correct incremental alphanumeric order.
(FYI: The Number column is usually hidden from users)
Best regards,
Clint