How to auto increment an id when a new item is added (calculated column)

(0) Share

Report

Posted on by missmichelleuk

Hello

I am using a sharepoint list for a log and have the following columns configured:

'Category' 3 Choices, Drop Down Menu
'UniqueID' Calculated column using an IF formula (suited to lists not excel) to return a 4 digit number with a prefix of either A, B, C depending on Choice selected in Column 1 'Category'.
Each time I create a new entry this works (I get the correctly prefixed 4 digit number but obviously this does not autoincrement so the I get A0000 or B0000 continuously.) Ideally I need the number to auto increment with each new entry by 1.
I have researched multiple solutions using Power Automate 'When an Item is created', 'Get Items' etc. potentially using a third column 'AutoID' (Number column only) but am really struggling to configure, particularly with steps further into flow.
I am new to Power Automate - I am seeking a simple flow to enable the original 'UniqueID' calculated column to increase by 1 each time a new item is created.
If any experienced users can advise on how feasible this is and can make suggestions, I would be thrilled. A simple solution with as detailed steps as you can would be much appreciated.
Ideally I would like the 'UniqueID' column to auto increment by 1 each time a new item is created keeping the prefix determined by the choice so A0001, B0002, B0003, C0004 etc.

Categories:

I have the same question (0)

All responses (3)

Answers (0)

Sort by