cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajyendra24
Level: Powered On

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 Team
Community Support Team

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

 

 

 

 

 

ajyendra24
Level: Powered On

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 Team
Community Support Team

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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,688)