cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gatchaman
Frequent Visitor

Adding multiple rows with the same flow (Excel)

Hello,

I am having a bit of trouble with one of my flows.

I have a form in PowerApps I use to add lines to an Excel file.

The onSelect Runs the flow in wich I put all the values for columns 

Gatchaman_0-1645608739952.png

No Issue so far the flow works fine and adds the line.

 

My issue:

I need to add duplicates of the submited lines. Instead of adding one. I need to add as many as selected in this field here.

Gatchaman_1-1645608958084.png

Say for example the user fills the form and puts a 3 in this field. I need the flow to add the line 3 times instead of one as it does now.

 

I am having a few things I don't understand:

The first is how do I send the value of that field with the flow.

if I simply add it with the rest I will logically get an error

 

Gatchaman_2-1645609229592.png

It will be an invalid number of arguments as this field has no corresponding column in the datasource and is not passed in the connector.

Gatchaman_3-1645609594813.png

The other question would be

How do I use this value to indicated how many rows to add

I assume I would add an action using Control and forEach but it's a bit fuzzy.

I would appreciate any pointer, thank you very much!

 

1 REPLY 1
mattias1172
Responsive Resident
Responsive Resident

I'm not familiar enough with PowerApps to advise on how to get the number value, but if you can get it and set a variable such as "Counter" equal to that number, you can use a "Do until" action with the "Counter" variable. 

mattias1172_0-1645650204329.png

A setup similar to this where you have the "add a row" action and you decrement the "Counter" variable on each run.

mattias1172_1-1645650333518.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,338)