cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jyotiRajpurohit
Frequent Visitor

Import maximum 30,000 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 import 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.

jyotiRajpurohit_0-1628593457042.png

 

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 for number of items as 100,000 ?

jyotiRajpurohit_2-1628592464107.png

 

 

Kindly help me in this.

Thank You.

2 REPLIES 2
Nogueira1306
Community Champion
Community Champion

Hey

The maximum itens in a SP list is 5k. So, it will not work

jyotiRajpurohit
Frequent Visitor

Hi @Nogueira1306 

In SharePoint list view threshold is 5000, but we can have more than 5,000 items.

You can see here, I have added 19,000 items in the list.

jyotiRajpurohit_0-1628668980311.png

According to this article, We can have large data in the SharePoint list

jyotiRajpurohit_1-1628669348150.png

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,859)