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.

 

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.

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (3,356)