Forum Discussion

Clint_E_Hill's avatar
Clint_E_Hill
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 I must export the library and add the number in MS Excel and paste these back into the library's index number column.

IDEAS ON RESOLUTION

Your thoughts on how to properly index the part I.D.s without a separate index number column are welcome including:

  • Alternative formatting to apply to the alphanumeric Part I.D. description in the Part I.D. column to promote correct indexing
  • Any programmed solutions

Best regards,

Clint Hill

 

Document Library

1 Reply

  • Rob_Elliott's avatar
    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)

     

     

Resources