Answered

256 rows limit

Like (10) Share

Report

Posted on 16 Apr 2019 14:35:46 by Community Power Pla...

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

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:

Tables

All responses (18)

Answers (1)

Suggested answer

Mohandar 74 on 15 Nov 2024 at 13:57:19

Like (0)

Report

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 2 on 10 Sep 2024 at 08:56:44

Like (1)

Report

256 rows limit

Thanks, worked for me just perfectly fine :)
hectorcardona 3 on 03 May 2024 at 00:28:05

Like (1)

Report

Re: 256 rows limit

Thanks, very helpful. It works perfectly for my 10.000+ rows excel file
AHC_Codestone 4 on 01 Nov 2022 at 15:41:41

Like (1)

Report

Re: 256 rows limit

Thanks - this worked for me!
Yi66 58 on 13 Jul 2022 at 03:08:31

Like (1)

Report

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 3 on 17 May 2022 at 12:28:48

Like (1)

Report

Re: 256 rows limit

Great. It works
JB-2 4 on 18 Nov 2021 at 14:06:37

Like (2)

Report

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 2 on 17 Sep 2020 at 11:28:57

Like (1)

Report

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 6 on 10 Jul 2020 at 19:47:14

Like (1)

Report

Re: 256 rows limit

Nope, it has not increased yet.
Community Power Pla... on 10 Jul 2020 at 14:39:47

Like (1)

Report

Re: 256 rows limit

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

Community site session details

256 rows limit

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

256 rows limit

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates