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

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

 

 

 

 

 

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

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,998)