Get max auto generate id and assign it where value is 1

[moilyas]

Hi - I'm using MS Flows. I want to get max auto generate id. Add 1 in it and update an existing value where number is 1.

Hi - I'm using Flows. I want to get max auto generate id from column A. Add 1 in it and update an existing value where number is 1.

so lets suppose

- Column A is auto incremented and max value is 6

- I want to get hold of 6 and add 1 in it so it becomes now 7

- assign 7 in the same Column A where value is 1 (mean updating Column A with number 7 where value is 1)

Any idea please? Thanks

[v-siky-msft · Accepted solution]

Hi @moilyas ,

I made a test on my side based on your description, the following flow steps are for your reference.

Hope this helps.

Sik