web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Incremental increase M...
Power Automate
Answered

Incremental increase Microsoft Lists

(0) ShareShare
ReportReport
Posted on by 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)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard