Incremental increase Microsoft Lists

(0) Share

Report

Posted on by CU05121554-0

Hi there,

I am very new to Power Automate and want to create a a flow which automatically adds '1' to the previous number in a specific column of my Microsoft list.

I currently have 37 values in my list and I want to allow any user who adds a new item to the list to automatically have the row increase by 1.

I know you can utilise the ID column for this feature however for some reason my ID starts at 87!

Please can anyone help?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Copy link

Link copied!
Hi @samraby4 ,

I suppose you have a number column in this list. Users will add new items to this list without filling this column and what you want is using a flow to fill the column automatically.

If this is the case, you can use a simple flow to achieve the goal:

1. When an item is created

2. Get items, order by this column desc, top count 1.

3. Update item, column value use expression

first(outputs('Get_items')['body/value'])?['ColumnName']

Best regards,

Was this reply helpful? Yes No