cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
uiterlex
Advocate I
Advocate I

Maximum 500 rows Excel table in PA?

I just tried my first PA with a supplier name table in Excel (download from Sharepoint list) which holds 9000 rows. I found out PA processes only 500 rows, also if I use a fliter in PA.

Is there a solution to this? Or will this limitation be dropped in the near future?

2 REPLIES 2
WendyLi
Microsoft
Microsoft

Hi uiterlex,

 

It is a limitation for the current version of PowerApps Preview. In general, PowerApps works with any size data source by delegating operations to the data source. For operations that can't be delegated, PowerApps will give a warning at authoring time and operate on only the first 500 records of the data source.

 

As PowerApps still is improved, the limitation would be improved in future.

 

There are two similar threads about this limitation, you can take a look at:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Data-source-500-item-limit-for-SP-list-and-256-i...

https://powerusers.microsoft.com/t5/PowerApps-Forum/Rollback-delegation/m-p/2131#M1188

 

Thanks,

Wendy

Hi,

 

Can anybody tell me the limitations on excel tables. I am trying to read data from a excel table with 10000 rows. I receive system out of memory exception.

 

Thanks,

Sru

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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.

Users online (1,068)