question

RajpurohitJyoti-0465 avatar image
0 Votes"
RajpurohitJyoti-0465 asked YiLu-MSFT commented

Import maximum 5000 excel items into sharepoint list using power automate

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.

121674-image.png

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.

121659-image.png

Kindly help me in this.

Thank You.


office-sharepoint-online
image.png (48.3 KiB)
image.png (10.7 KiB)
image.png (63.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered YiLu-MSFT commented

Hi @RajpurohitJyoti-0465
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.


121952-image.png


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

121962-image.png


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.



image.png (11.9 KiB)
image.png (38.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you @YiLu-MSFT
I have gone through this document - https://docs.microsoft.com/en-us/power-automate/limits-and-config
but I didn't find number of items per plan and what is the price for that.

For pagination threshold If I go with other plan like "MediumLow1" will it allow me, number of items as 100,000 ?

121937-image.png

Could you please help me in that.


0 Votes 0 ·
image.png (5.5 KiB)
YiLu-MSFT avatar image YiLu-MSFT RajpurohitJyoti-0465 ·

Hi @RajpurohitJyoti-0465

Yes, number of items as 100,000 will be allowed by "MediumLow1", however, the price of it is not in our area, thank you for your understanding.

0 Votes 0 ·
YiLu-MSFT avatar image YiLu-MSFT RajpurohitJyoti-0465 ·

Hi @RajpurohitJyoti-0465
Would you please provide some update of this issue? I am free to listen.

0 Votes 0 ·