Hi @FC-16060954-0
As your SharePoint list already exists, don’t assume the first item ID is 1.
SharePoint already has a built-in auto-incrementing ID column. You can use that ID, but you need to calculate the correct offset so that the next new item becomes reference number 16000.
First, show the built-in ID column in your SharePoint view and check the highest current ID.
For example, if the highest current ID is 25, the next new item will normally be ID 26.
To make ID 26 become reference number 16000, calculate:
16000 - 26 = 15974
Then in Power Automate, update your Reference Number column using:
add(triggerOutputs()?['body/ID'],15974)
That would give:
ID 26 = 16000
ID 27 = 16001
ID 28 = 16002
So the general rule is:
Reference Number = SharePoint ID + offset
where:
offset = 16000 - next SharePoint ID
Make sure the flow trigger is When an item is created, not When an item is created or modified, so the flow does not keep triggering itself.
Let me know if it worked!
