cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Maximum records used in dataTable in PowerApps

Hi Experts,

 

I have around more than 5000 records in Account as well as contact Entity. I am using dataTable in Powerapps to display data into rows and Columns Format. So Is there any limit of records ? I just saw somewhere that only maximum 2000 records is the limit.

 

Please let me know what excatly the answer is ?

 

Thanks 

Ajyendra

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Maximum records used in dataTable in PowerApps

Hi @ajyendra24 ,

What @timl talked about is delegation limit.

The reson why you get wrong result is because of this too.

If your record number is larger than 2000 and you do not use delegable functions, your app will not perform well (may get wrong result).

This is PowerApps itself limit, not data table limit.

To avoid this, firstly you need to change this non-delegable limit to 2000.delegation.jpg

 

Secondly, please modify your functions. Only use delagable functions.

Please refer this doc, all the delegable functions in CDS are listed there:

https://docs.microsoft.com/en-us/connectors/commondataservice/

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Maximum records used in dataTable in PowerApps

Hi Ajyendra,

The 2,000 row limit is the maximum number of records that PowerApps can retrieve, if we were to use a non-delegable query.  There are more details in the documentation, within the section "PowerApps delegable functions and operations for the CDS for Apps".

https://docs.microsoft.com/en-us/connectors/commondataservice/

 

This 2,000 row limit is most noticeable with SharePoint datasources where query delegation support is not as good as the CDS.

In terms of the data table control, I don't think there's a practical maximum number of records that we can display with the control. If there were a limit, I would guess it would be around 4 billion (corresponding with the limit of a Javascript array), or the limit would occur when your browser/computer runs out of available memory. 

As a test, I added 60k records to a collection and set the items property of the control to this table. I gave up scrolling through the table when I got to around record 12,800.

image.png

 

 

 

 

 

Highlighted
Frequent Visitor

Re: Maximum records used in dataTable in PowerApps

Hi,

 

Thanks for response.

 

I am applying filter on that table after that filter the result I get is not proper.

 

Thanks

Ajyendra

Highlighted
Community Support
Community Support

Re: Maximum records used in dataTable in PowerApps

Hi @ajyendra24 ,

What @timl talked about is delegation limit.

The reson why you get wrong result is because of this too.

If your record number is larger than 2000 and you do not use delegable functions, your app will not perform well (may get wrong result).

This is PowerApps itself limit, not data table limit.

To avoid this, firstly you need to change this non-delegable limit to 2000.delegation.jpg

 

Secondly, please modify your functions. Only use delagable functions.

Please refer this doc, all the delegable functions in CDS are listed there:

https://docs.microsoft.com/en-us/connectors/commondataservice/

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,079)