Showing results for 
Search instead for 
Did you mean: 
Not applicable

PowerApps limitation (Column and Rows)

Hello Guys, I have an sharepoint lists with more than 10k of rows, and it has 127 columns.

I tried to load it on PA but got an error saying that the limit of columns was exceed.


Do you guys know a way I can load it on PA or today, it is not possible yet?


Helper III
Helper III

There is a experimental feature in powerapps setting page.

Increase the value according to your requirement.


Hope this helps.



Hi @Pat_Wickramage


Curious: Have you tried this setting with Sharepoint lists > 2000 rows? I was under the understanding this was the max limit. Interested to know if you've used it for lists larger than than. 


Take care

I have tried it in Excel DBs placed in OneDrive for business & it works.

So give it a try.

@Pat_Wickramage Cool. I'll have to give it a try. 


@Anonymous, you should look into "the Delegation Issue" for Sharepoint lists > 2000 rows just to be familiar. You won't be able to use some Functions on that list. 

Not applicable

I tried but did not work 😞


I still got the limit error, I set to 2000 the value, but the gallery shows an error, when the error not appear, the gallery just stays blank :c


Maybe some Patch or Collection functions can reduce the amount of rows?


Community Champion
Community Champion

Sounds like a COLUMN limit rather than ROWS. I haven’t run into that before. Maybe consider breaking the 127 into sub-tables then reference back to original table to reduce?
Not applicable

 I liked the idea....But, how do I do the reference using SP lists?


If I could know the columns limit of a SP lists in PA would help...


Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,549)