Increment index for distinct value in a specific column

[Morgane]

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. 

[v-alzhan-msft]

Hi @Morgane ,

Does your problem still exists?

Best regards,

Alice       

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.

[Morgane]

Hello @v-alzhan-msft ,

Thanks for responding and yes it does!

Do you have any suggestions to solve it ?

King regards.