Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Increment index for distinct value in a specific column

Hi everyone, 


I'm trying to create a simple use case with flow for personnal training, however I still have problems. 


The context is that we have cyclists people in a race, they start in the same city at the same time and after they have few steps in different towns (each city has number to identify if it's the first or second step for example). The aim with flow is for the user directly on his mobile phone to add a row in the excel sheet (with his current location,time etc...) when he clicks on the button dedicated for. 


I'm looking for a solution concerning incrementing the step's number (column "numero_etape" in the excel below) when a new city (column "etape") is detected. 


Here are some screenshots to better understand what my problem is and the way I tried to solve it. 










What I try to achieve is when the user is located in a town which has already been entered in the excel sheet, the added row takes the same step's number previously assigned to this town. Furthermore, when the user is in a new city, I would like the new step's number to be the actual maximum step's number + 1. 


I hope I've been clear enough.


Thank you in advance. 

Community Support
Community Support

Hi @Morgane ,


Does your problem still exists?


Best regards,



Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-alzhan-msft ,


Thanks for responding and yes it does!

Do you have any suggestions to solve it ?


King regards. 

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,443)