Unanswered

I want to create multiple rows in a table in excel based on qty entered into a form, any suggestions?

(0) Share

Report

Posted on by adam0s

As the title says, I am looking to add a number of identical rows to a table in excel based on the qty entered into a form that also captures the rest of the data that will be building that row. For example, form captures order data and a quantity, then the flow adds rows to a table in excel equal to the number entered into the quantity field on the form.

Grateful for any help I can get.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @adam0s

You could use the expression range on an apply to each.

Range creates an array of numbers from start to finish i.e. 1 to number of rows.

So in the above example I received 4 via the compose and it added 4 identical rows.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
adam0s 47 on at

Like (0)

Report

Thank you for the response @DamoBird365 This looks like the start of what I need but I am unsure of how to relate it to my input, in this case I do not always want it to create the same number of identical rows, there is a field in the initial form trigger that specifies a quantity, how can I use your solution with that field so that each time the form is submitted it will produce a number of rows equal to the quantity entered on the form?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @adam0s

The above example is dynamic. It creates a range from 1 to the dynamic value albeit in my example the value is fixed at 4. If you replace the 4 with your answer from the form, it will run from 1 to the dynamic answer provided.

Hope that makes sense.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
adam0s 47 on at

Like (0)

Report

It does, I think where I am still stuck is in creating the range in the apply to each, can you show me exactly what you put there?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @adam0s

It's sneakily visible on the screenshot as a comment.

range(1,outputs('compose'))

but you can replace the outputs('compose') with the dynamic value for the form field or stick your form field into a compose, whatever you feel more confident with.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
adam0s 47 on at

Like (0)

Report

I see it now, totally missed it.

Ok, I added the dynamic content to the compose and I am getting the following error:

so the compose is getting the right number from my test form fill, I have tried both

range(1,outputs('Compose'))
and
range(1,outputs('Get_response_details')?['body/r76acd7a9c92e48a4bd69112bb4f5dd07'])
which is what it enters when I add the dynamic content to this step directly and I get that error either way, is this a syntax error or am I missing something?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @adam0s

Almost there. The data from your form is returned as a string, I didn't think of that one. You need to use the expression int().

i.e.

range(1,int(outputs('Get_response_details')?['body/r76acd7a9c92e48a4bd69112bb4f5dd07']))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
adam0s 47 on at

Like (1)

Report

Yes, that worked! I have accepted your original post as the solution. Thank you for your help!

Was this reply helpful? Yes No