Power Platform Community Forum Thread Details

I have built a power app that has multiple screens which fetch the data from dataverse.

For each table, we have lookup columns from different tables.

The screens display data from various tables from the dataverse.

The screens have filters that have dropdown functionality, where users select the required value from the filters and records are displayed in the form.

I am using delegable functions (search, filter, lookup, in). The issue I am facing is that the filtered data is more than 2000 records and therefore the data is not being displayed.

To overcome this, I have setup collections. Using collections, I am able to display > 2k records, but facing huge performance issues as the load time is more than 5 min.

The requirement around search is that 'in' operator should work, as users often type in characters from anywhere within a value (e.g. Microsoft should be fetched if I search 'of' or 'Micro' or any other such combinations)

Any pointers on how to improve this performance would be greatly appreciated.

Thanks

Categories:

General Questions

Hi @CU04120655-0,

There is a very good reason that Power Apps has a maximum Data Row Limit of 2,000 and is unlikely to increase it - browser or mobile device apps just do not have the capability to execute large queries "locally" and the more complex they get the slower they go. The only thing I will say with Collections is to use ShowColumns for only the fields you need - it reduces the size of the data being stored.

The idea (which you have noted in your post) is for Delegable queries, allowing them to be done "server side" and generally very quick regardless of the data set size. So I am wondering what in your query is not Delegable as Dataverse certainly supports the in Function and should display all matching records if the user wants to scroll far enough down.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn