Skip to main content

Notifications

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:
  • Suggested answer
    Mohandar Profile Picture
    74 on 15 Nov 2024 at 13:57:19
    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
    2 on 10 Sep 2024 at 08:56:44
    256 rows limit
    Thanks, worked for me just perfectly fine :)
  • hectorcardona Profile Picture
    3 on 03 May 2024 at 00:28:05
    Re: 256 rows limit

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

  • AHC_Codestone Profile Picture
    4 on 01 Nov 2022 at 15:41:41
    Re: 256 rows limit

    Thanks - this worked for me!

  • Yi66 Profile Picture
    58 on 13 Jul 2022 at 03:08:31
    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
    3 on 17 May 2022 at 12:28:48
    Re: 256 rows limit

    Great. It works

  • JB-2 Profile Picture
    4 on 18 Nov 2021 at 14:06:37
    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
    2 on 17 Sep 2020 at 11:28:57
    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
    6 on 10 Jul 2020 at 19:47:14
    Re: 256 rows limit

    Nope, it has not increased yet.

  • Community Power Platform Member Profile Picture
    on 10 Jul 2020 at 14:39:47
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard