Can someone help with with that task:

In a table (in excel) in a column I have some number(A).

I want the flow to take that number (A) and to create number of rows equels to Number (A)

For example if number(A) is 4, then in another table to be added 4 rows

Thank you

CodePudding user response：

I've made an assumption on the source and destination tables. This concept can be adjusted and applied to suit your own scenario.

I'd be using Office Scripts to do this. If you've never used it then feel free to consult the Microsoft documentation to get you going ...

You can use that approach or all of the actions that are available in PowerAutomate which will achieve the same sort of thing.

IMO, Using Office Scripts is much easier. Creating a large flow can be a real pain in the backside to deal with given there'll be a whole heap of actions that you'll need to throw in to reach the same outcome.

CodePudding user response：

Here you need to use a VB macro Create a loop to add the number of lines In the loop, the limit is the value of the cell