Create Variable for Multiple Row Creation in Sharepont List

(0) Share

Report

Posted on by PeterDonohue

162

My scenario is:

Form > Flow > Populate sharepoint list - Currently 1 SP list item (row) per form.

I'm wondering how I can put a question in the Form to take a Number and then based on that number create that many rows and copy the information into them.

E.g.

Type: Cube
Volume: 6

The flow would then create 6 rows, each with the title Cube

Cheers

Categories:

Building flows

All responses (5)

Answers (0)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Just take the Create Item actioin and put it inside a DoUntil Loop that is controlled by a counter. Read the values of the form, store the number in a variable, enter the loop, and keep looping until a counter is equal to or greater than the variable you stored from the form.
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PeterDonohue,

As the value format of your Form, I only provide a way how to create multiple rows according to the value of Volume.
Please have a reference on the screenshot as below:Please have a try and I hope it can help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PeterDonohue,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu
PeterDonohue 162 on at

Like
a
(0)

Report
Copy link

Link copied!

I am yet to get it to work so will not accept a solution. Too often I see these as accepted and they are not actually correct
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PeterDonohue,

So, you could provide more information about your requirements, then we can do better assist you.

What's the Cube's type means? Is it the column name of SharePoint?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.