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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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