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

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
timl
Super User
Super User

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

 

 

 

 

 

ajyendra24
Frequent Visitor

Hi,

 

Thanks for response.

 

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

 

Thanks

Ajyendra

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
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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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