Forum Discussion

Brass Contributor

Oct 30, 2025

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 ...

Document Library

Rob_Elliott

Bronze Contributor

Oct 31, 2025

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)

Clint_E_Hill

Brass Contributor

Nov 03, 2025

Hi Rob,

Your thoughts and suggestions are appreciated.

(It appears my initial reply was not uploaded for some reason.)

Although currently a Power Automate novice, I will learn the skills to resolve my alphanumeric part number system limitation dilemma expressed here.

Question 1: Could I successfully achieve this with only the second recommendation as you mentioned?

“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”

Question 2: What are the advantages of performing the first Power Automate performing the initial indexing?

Regards,

Clint Hill