Forum Discussion
Indexing Ideas Needed - Parts I.D. Order in Libraries : Ex.) Parts R1 thru R10, R2...
GOAL: To resolve the subject line issue that is intensive and eliminates the following workaround. WORKAROUND A sequential number in a separate index number is formatted as a "Number". Many times ...
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)