web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Export more than 5000 ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 58

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 ?

Categories:
  • takolota1 Profile Picture
    4,980 Moderator on at

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

  • Yi66 Profile Picture
    58 on at

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

  • takolota1 Profile Picture
    4,980 Moderator on at

    @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-External-Data/td-p/1365410

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard