Skip to main content

Notifications

Power Automate - Building Flows
Answered

256 rows limit

Posted on 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:
  • Suggested answer
    Mohandar Profile Picture
    Mohandar 74 on at
    256 rows limit
    if you are in new designer mode pagination option is not available in new designer mode. You have to turnoff new designer and then change connector setting with pagination.
  • SW-10090850-0 Profile Picture
    SW-10090850-0 2 on at
    256 rows limit
    Thanks, worked for me just perfectly fine :)
  • hectorcardona Profile Picture
    hectorcardona 3 on at
    Re: 256 rows limit

    Thanks, very helpful. It works perfectly for my 10.000+ rows excel file

  • AHC_Codestone Profile Picture
    AHC_Codestone 4 on at
    Re: 256 rows limit

    Thanks - this worked for me!

  • Yi66 Profile Picture
    Yi66 58 on at
    Re: 256 rows limit

    dude, this 5000 only for basic.  we need more then needs to be premium. but most ppl are basic plan. come on now

  • santybanty20 Profile Picture
    santybanty20 3 on at
    Re: 256 rows limit

    Great. It works

  • JB-2 Profile Picture
    JB-2 4 on at
    Re: 256 rows limit

    This solution worked perfectly for me.  Thank you very much for sharing.  I agree with one of the other people below, it would be helpful if the limit was higher.

     

  • rcpimenta Profile Picture
    rcpimenta 2 on at
    Re: 256 rows limit

    you have to increase the limit on the sharepoint too

     

    https://stackoverflow.com/questions/6093955/exceeds-the-list-view-threshold-5000-items-in-sharepoint-2010

  • ZachTakingIt Profile Picture
    ZachTakingIt 6 on at
    Re: 256 rows limit

    Nope, it has not increased yet.

  • Re: 256 rows limit

    Gents, do you have any updates on the row limitation?  Has it been increased beyond 5000?

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard