cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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?

 

7 REPLIES 7
Pat_Wickramage
Level: Powered On

Re: PowerApps limitation (Column and Rows)

There is a experimental feature in powerapps setting page.

Increase the value according to your requirement.

 

Hope this helps.

 

Cheers

Super User
Super User

Re: PowerApps limitation (Column and Rows)

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

Pat_Wickramage
Level: Powered On

Re: PowerApps limitation (Column and Rows)

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

So give it a try.

Super User
Super User

Re: PowerApps limitation (Column and Rows)

@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. 

Anonymous
Not applicable

Re: PowerApps limitation (Column and Rows)

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?

 

Super User
Super User

Re: PowerApps limitation (Column and Rows)

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?
Anonymous
Not applicable

Re: PowerApps limitation (Column and Rows)

 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

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,770)