web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Incremental increase M...

Power Automate

Answered

Incremental increase Microsoft Lists

(0) Share

Report

Report

Posted on by CU05121554-0

13

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee 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

Join the conversation