Increment Excel number series

[Pat_Wickramage]

Hi All,

Having bit a of a trouble while trying to increment a number series on a table.

Basically the last number is read from a PostgreSQL database and posted on the first line.

I can get that done, but cannot increment it to the rest of the lines.

Any suggestions would be highly appreciated.

My project is in a standstill coz of this.

Cheers

[Achavan · Accepted solution]

Hi @Pat_Wickramage ,

1. Initialize variable of type integer and initialize with value (which is first row number/key)

2. apply to each looping

3. Use increment variable 

Did I answer your question? Please consider to mark my post as a solution to help others.

[Pat_Wickramage]

Thanks @Achavan 
I tried that.

But it was on a infinite loop updating the entire column rather than each cell.
And 'loop until' is a problem cause the number of rows keep changing based on daily export.

Have I missed something?

[flaviatakushi · Accepted solution]

@Pat_Wickramage. see this example of flow and check if it works:

You may have to adjust the trigger and parameters according to your needs.

Cellvalue: int(items('Apply_to_each')?['AD_User_Training_ID'])

If this helps you, please mark as solution.

[Pat_Wickramage]

Thanks guys figured it out.
This is all I had to do.

If it's a never ending one, use 'do-until'
Cheers