top of page

Create a list items using an array in Power Automate

Morning all,


I came across this post on the Power Automate forums:


"Title: Create a list items using an array in Power Automate


Hello Power Users,

 

I have a sample array in the below format and would like to loop. through it to create list items inside a SharePoint list.

 

Array :  ["AAA, BBB, CCC",

              "DDD,EEE,FFF",

               "GGG,HHH,III"]

Can anyone please help!

 

Thank you so much in advance!"


Ok, lets take a look.


First of all, create a new flow, call it whatever you want, I have gone with the post title. I have created, and instant flow, as I think that is easiest here.


The next step is to create an Array variable:


Step 1 Initialize ArrayVariable

Your flow will look like this:


Flow progress so far


Next initialize another variable, call it Index, type = Integer and a value of 0, like below:

Step 2 Initialize Index variable

Next add an Apply to each, for the Select an Output from Previous Steps, select the ArrayVariable:


Step 3 - Apply to each

Inside the Apply to Each step, add an Increment variable, and choose Index, and increment it by 1:



Step 4 - Increment Index variable

Next add a compose:


Step 5 - Compose current item

The inputs will be the Current item, you ca write this as an expression if you want as item()


Finally, add your outputs of the compse (within the apply to each) to your SharePoint site:


Step 6 - Create item in SharePoint

This will then create the items in the SharePoint list you have selected:


Result in SharePoint

The beauty of this method is that you can have as many items in your array at the start for example:


I have added more lines to the ther ArrayVariable:



Adding additional lines to the Array

And hey presto, all of the items have been added:


Result in SharePoint after more array items have been added

Here is the full flow end to end:


Power Automate cloud flow structure end to end, all steps

7 Comments


I really liked how the blog clearly explained creating list items in Power Automate using arrays it made a tricky concept feel simple and doable. The step by step guidance was super practical, especially for beginners. While reading, I couldn’t help thinking how helpful it would be if I could just pay to do my exam, but tutorials like this remind me learning it myself is far more rewarding.

Like

Understanding contract management courses in dubai is essential for professionals working in construction and infrastructure. The College of Contract Management provides comprehensive training focused on real-world challenges. The course emphasizes practical skills needed to handle disputes effectively. Many have benefited from the course and advanced their careers.

Like

Step into the spotlight in Retro Bowl 26, the ultimate American football strategy simulation. Build your dream NFL team, call the plays, and lead your squad to gridiron glory.

Edited
Like

As a controls project manager, I've learned that success depends on a clear grasp of a project's financial details. UNICCM's ECITB course was crucial for my career, as it provided a masterclass in reading cost forecasts and schedule variances. I constantly use the program's case studies as a benchmark for my own work. I'd definitely suggest looking at their course outline on the UNICCM website.

Like

What are natural forms, and why do they matter? UniCCM’s blog uncovers how these organic shapes—from tree branches to waves—have influenced human culture and design throughout history. The piece bridges nature and creativity in a way that’s both informative and visually inspiring. Whether for schoolwork or creative exploration, this guide is a valuable resource. Visit UniCCM to explore nature’s impact on human imagination.

Like

Subscribe Form

©2019 by Jon Does Flow. Proudly created with Wix.com

bottom of page