Generate auto increment sequence number in Power automate for a SharePoint column

(0) Share

Report

Posted on by Iantaylor2050

531

I have a ItemNum column in SharePoint list. I need to autogenerate ItemNum in the sequence 1000, 1001, 1002, 1003, etc.

For this, I have a initialized a variable SeqNum, autoincrementing it by 1 and assigning it to SharePoint column. But the auto increment doesnt work. Any idea where I am going wrong? Below is the screenshot for the same.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report

Are you creating a lot of items within a loop, or do you want to create individual items periodically?

If you wanted to ensure you get the next sequence, you can use Get items set to Top Count of 1 and sort by ItemNum in Descending order. This will return the largest ItemNum in your list. You can then add 1 to the number and use that value as your next ItemNum for the item you are creating.

Was this reply helpful? Yes No
Iantaylor2050 531 on at

Like (0)

Report

Hi @grantjenkins

I am creating individual items periodically

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Hopefully this is what you're looking for.

For this example, I have the following list with no items (empty list). Note that Item No is of type Number with internal name ItemNo.

See full flow below. I'll go into each of the actions.

I'm not sure what your trigger is, so I've just used a Manual trigger with a Text input called Title that I'll use to populate the Title field.

Get items retrieves the item with the largest Item No in the list. Note that it has Order By set to ItemNo desc and Top Count set to 1.

Create item uses the Title we entered in our Manual trigger for the Title, and the following expression to calculate the next Item No. If we look at the expression from the inside out, we get the first item returned and get the Item No. If no item returned (no items currently in the list) we will default the initial value to 999 using coalesce. We then convert that to an int, then add 1 to it. So the first item will be 999 + 1. The second item will be 1000 + 1, etc.

add(int(coalesce(first(outputs('Get_items')?['body/value'])?['ItemNo'], 999)), 1)

After running the flow a few times, passing in a Title each time, we would get the following results.

Was this reply helpful? Yes No