cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pat_Wickramage
Helper III
Helper III

Increment Excel number series

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

 

increment excel.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Achavan
Resolver II
Resolver II

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 

Achavan_0-1620279676187.png

 

 

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

View solution in original post

flaviatakushi
Community Support
Community Support

@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.

 

flaviatakushi_0-1620872137870.png

flaviatakushi_1-1620872176046.png

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

 

If this helps you, please mark as solution.

View solution in original post

4 REPLIES 4
Achavan
Resolver II
Resolver II

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 

Achavan_0-1620279676187.png

 

 

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

View solution in original post

Pat_Wickramage
Helper III
Helper III

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
Community Support
Community Support

@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.

 

flaviatakushi_0-1620872137870.png

flaviatakushi_1-1620872176046.png

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

 

If this helps you, please mark as solution.

View solution in original post

Pat_Wickramage
Helper III
Helper III

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

Web capture_18-5-2021_132716_australia.flow.microsoft.com.jpeg

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

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,732)