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.

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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,585)