Create a list items using an array in Power Automate
- Jon Russell

- Jun 8, 2024
- 1 min read
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:
Your flow will look like this:
Next initialize another variable, call it Index, type = Integer and a value of 0, like below:
Next add an Apply to each, for the Select an Output from Previous Steps, select the ArrayVariable:
Inside the Apply to Each step, add an Increment variable, and choose Index, and increment it by 1:
Next add a compose:
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:
This will then create the items in the SharePoint list you have selected:
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:
And hey presto, all of the items have been added:
Here is the full flow end to end:














Interesting article with useful explanations and an enjoyable reading experience from beginning to end. I appreciate blogs that genuinely focus on helping readers understand topics instead of simply filling articles with unnecessary technical details everywhere online. Your writing style made the complete discussion much more engaging and easier to follow overall. During my recent online search for similar resources, I also checked allpanelexch9 and found helpful information there too. Keep posting more quality and informative blog content regularly.
Me gusta cómo el artículo plantea ideas prácticas sin complicarlas demasiado, algo que siempre se agradece. Además, me recordó a sportium por esa combinación de dinamismo y experiencia de usuario bien cuidada. Da gusto encontrar contenidos que realmente invitan a seguir leyendo.
Mình có lần lướt đọc mấy trao đổi trên mạng شيخ روحاني thì thấy nhắc nên cũng tò mò mở ra xem thử cho biết. Mình không tìm hiểu sâu rauhane chỉ xem qua trong thời gian ngắn để quan sát bố cục s3udy cách sắp xếp các mục và trình bày nội dung tổng thể. Cảm giác là các phần được trình bày khá gọn, các mục rõ ràng nên đọc lướt cũng không bị rối Berlinintim, với mình như vậy là đủ để nắm tin cơ bản rồi. q8yat
Mình có lần lướt đọc mấy trao đổi trên mạng شيخ روحاني thì thấy nhắc nên cũng tò mò mở ra xem thử cho biết. Mình không tìm hiểu sâu rauhane chỉ xem qua trong thời gian ngắn để quan sát bố cục s3udy cách sắp xếp các mục và trình bày nội dung tổng thể. Cảm giác là các phần được trình bày khá gọn, các mục rõ ràng nên đọc lướt cũng không bị rối Berlinintim, với mình như vậy là đủ để nắm tin cơ bản rồi. q8yat
Really enjoyed this walkthrough—I've struggled before with looping through arrays in Power Automate and ending up with messy or inefficient flows, so seeing it broken down this clearly made it click. What stood out to me was how practical the approach is, especially when dealing with dynamic data rather than static inputs. It actually reminded me of using Schon's reflective model, where you learn by doing and then refining your approach based on what works and what doesn’t—in this case, testing flows, spotting inefficiencies, and improving structure. I’ve often overcomplicated things with nested loops, so this feels like a cleaner, more maintainable solution. It also makes me think about how small design choices in automation can have a big impact…