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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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