Maximum records used in dataTable in PowerApps

[ajyendra24]

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

[timl]

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.

[ajyendra24]

Hi,

Thanks for response.

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

Thanks

Ajyendra

[v-yutliu-msft · Accepted solution]

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.

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,