
Announcements
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!
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,