Unanswered

Sequential Number for SharePoint list

(0) Share

Report

Posted on by LauraH2

Hi all,

Very new to Power automate, and I'm trying to create a flow which adds a sequential number to a list whenever a new item is created. The number needs to start from 15000, so I can't use the auto-generated ID column, and apparently it also doesn't work to use that with a calculated column.

I've tried to build a flow using "when item created" > "get items" > "Compose" > "update item" but I'm coming unstuck at the formula for the 'compose".

we have a column currently called "Test Num" where we want the sequential number to be added, with an existing item which has "20000" in the "test num" column. Every formula I try either comes back with 'invalid formula' or simply doesn't update the test item when I add one. Any ideas please?

Categories:

Building flows

I have the same question (1)

All responses (4)

Answers (1)

annetoal 1,934 Moderator on at

Like (0)

Report

This posting might help you: Solved: Increment a column value by +1 when a new submit o... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
LauraH2 11 on at

Like (0)

Report

Hi,
Thank you for this, I may need to use it!

To expand on that - I was hoping not to need to use a second list to create the number - is there no way around that?

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

I'm not sure why you would need a second list. Please explain and include screen shots to illustrate.

Was this reply helpful? Yes No
Verified answer

LauraH2 11 on at

Like (0)

Report

Apologies! I realised I mis-read the instructions on the other post (definitely new to this!). But have also managed to sort it but using a flow of "when an item is created" > "Compose" (with formula: add(triggerOutputs()?['body/ID'], 14000) < this is because we don't want our numbering to start from 1) > "Update Item" (using the ID, Title and any other mandatory fields dynamic content under “When an item is created”, and the [Name of column where you want the sequential number to appear]: Use the dynamic content for “Compose: Outputs”.

We also found an option step, after "when an item is created" - "Get Items", where we can include [Name of column where you want the sequential number to appear] in the 'Order by' section to, well, order the list by that number.

Thank you though!

Was this reply helpful? Yes No