web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Automate - Building Flows
Answered

256 rows limit

Like (10) ShareShare
ReportReport
Posted on 16 Apr 2019 14:35:46 by

I am trying to import up to 50,000 lines from a table in excel into a SharePoint list.

 

I have it working but it is currently capped at 256 rows. I have been doing some searchign on here and have found that other people have had the same issue but they have solutions based on using the 'Get Rows' action, however i dont seem to have this as a possible action?

 

I am using 

Capture.PNG

 

Capture.PNG

Capture.PNG#

 

Everything runs ok but i just hit the limit of 256, without using the 'Get Rows' action which i dont seem to have i cant find a way around it?

Categories:
I have the same question (0)
  • Verified answer
    v-bacao-msft Profile Picture
    on 17 Apr 2019 at 01:00:15
    Re: 256 rows limit

    Hi @Anonymous ,

     

    Please click Settings, then enable Pagination to increase the limit to the expected value.

    Image reference:

    10.PNG11.PNG

    Please take a try.

     

    Best Regards,

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 809 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 712 Super User 2025 Season 2

#3
stampcoin Profile Picture

stampcoin 373 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete