Share
Report
8Hi all,
I have a question regarding how to automatically increment a row with a number (1 greater than the preceding row) in MS Excel whenever a new row is added in the ID column (see below). I am using an MS Form as a trigger to add a new row and the concept seems really straightforward, however I have not been able to get it to work. In my latest attempt as shown below, I am able to increment but it will add the same row anywhere from 12 times - 148 times. I am not sure what is missing and am open to any ideas on how to achieve the incrementation.
This is the current flow that I have. I am posting the overview and then the in-depth dynamic content (three parts) used to build the flow.
Flow Overview
Part 1
Part 2
Part 3
Excel Result
Note that this 15 times is added in one run, from one response to the flow. Sometimes it can be more than 15 using the same flow (and nothing has changed).
I have checked and I do not have concurrency enabled, and I have tried building flows using the following functions:
- integer function
- add function
- call the last row using last and then adding + 1
- composed various outputs
-Append Array Variable
- Converted to a string and then add string
And I have faced issues regarding the fact that the integer function requires an integer and although I have an integer, not sure what is going wrong. When I did compose the output of add, I got it to add a row, but it consistently said 1 for each entry and would not increment. I am sure this is pretty simple but not sure why I have not got it to work. I am open to any flow ideas to achieve my function.
Thank you so much for the help!
All responses (
Answers (
