Share
ReportHello
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.
All responses (
Answers (
32,506
