Nested apply to each loop to avoid in power automate

Question

Hi ,

I have situation where I have to create around 6000 items in SharePoint list by manually trigger power automate flow. each items has some data based on 9 category, each day of month(30 or 31) and each hours (24 hours) of the day, that means 9x30x24 items to create. This flow will run each month manually.

With apply to each action in the power automate flow , I can create items in SP list however this will take for ever to run the flow that I would like to avoid and it may impact the system to be slow down.

Does anyone has other solution to avoid 3 nested apply to each loop to create such mass items ?

Thank you so much in advance!

Answer 1

Hi @kem104,

Per my research, I would recommend you to refer to following article to improve the performance of Loops in power automate. Power Automate Apply To Each Loops 20X Faster

Since our forum focus on SharePoint and I am not familar with Power Automate, I could only doing some research online. If my answer doesn't solve your issue, you could raise a new ticket in Microsoft Power Automate Community. This is a Microsoft forum dedicated to discussing Power Automate. You might get some more professional advice there. Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.