Import maximum 5000 excel items into sharepoint list using power automate

Question

Hi Team,

I have to import maximum 30,000 excel sheet items into SharePoint list using power automate. The help of pagination, I can get 5000 items but here we have requirement for more than that.

Also noticed one issue like if excel sheet has more than 5000 items.
for example excel sheet has 10,000 items, when I use "Excel Online (Business)" and I set pagination threshold as 5000 but it gets the 5120 items. while importing items into SharePoint list it gives an error in for each loop.

Kindly help me in this.

Thank You.

Answer 1

Hi @Jyoti Rajpurohit
As described here: Concurrency, looping, and debatching limits, for Low plans, the highest number of array items that a "apply to each" loop can process is 5000 while the number is 100000 for other plans.

Flows have different limits depending on their performance profile. There are five possible values, depending on the flow owner's plan.

Since the number of items in your excel exceeds 5000 and you may have a Low plan, this issue is caused by the limit of the “Apply to each”action. As per my knowledge, I’m afraid there is no workaround to such threshold issue unless you divide the large excel sheet into several small ones.

Also, this forum is dedicated to SharePoint related issues and I am not an expert on Power Automate Flow. You can raise a new thread in Power Automate community. Experts there will give you professional suggestion.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.