cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yi66
Helper II
Helper II

Export more than 5000 rows data from excel to share point list

I have a flow, export excel attachment data to sharepoint list, everything works perfect. But it only allow 5000 rows in the pagination (but I have about 25,000 rows of data) ?  Anyone know export more than 5000 rows data from excel to share point list ?

3 REPLIES 3
takolota
Super User
Super User

Go to the 3 dots & settings on the Excel get data action. Turn on pagination & set it to anything 1-100000.

what if our plan are basic ? does it need to be premium plan?

@Yi66 

 

If you only have a basic license & limited daily actions, then you can try using SharePoint batch actions like batch create & batch update.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-Extern...

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (2,402)