Means to bypass Powerapps delegation warning

[yohannes_adeba]

Dear Community

Greetings!

Please allow asking this 1 question regarding the PowerApps delegation warning which is bothering me a lot.

I've developed a power app to track recruitments and it is working well for the past 1+ years. Currently, I've around 500 items in it.

My question is below.

When the items exceed 4000 is there any license to bypass the delegation limit?

I.e. I've used the filter function and my first desire is to pay the license if there is any service to filter rows without limit.

To save time I don't want to customize my PowerApp to solve the delegation limit unless it's the only option.

If only a workaround is the solution do you've any advice/reference materials?

As stated above, my main desire is to pay if there is any solution to filter rows without limit. 

Thank you so much in advance for the support.

Yohannes T.

[rohentz]

Hi @yohannes_adeba how are you?

@yohannes_adeba thanks for use the community and regarding your question there is no license that will disable the delegation warning at application.

Delegation warnings is by design Understand delegation in a canvas app - Power Apps | Microsoft Learn and this help creators to check for behavior that with time can impact the application. Like the record limits that can be increased but with large datasets new data cannot be retrieved PowerApps data row limit for non-delegable queries | Microsoft Power Apps

My advised here based on a lot of support cases that I handle is to use expressions that can be delegated to the server and also filter and get the necessary data to run the application. Not retrieve all records or something like that. 

Please check this article Understand delegation in a canvas app - Power Apps | Microsoft Learn and this one Tips and best practices to improve performance of canvas apps - Power Apps | Microsoft Learn 

I hope that my information shared here helped to clarify the delegation question.

Best regards

Rodrigo Hentz

Microsoft Power Platform Support Engineer

[jimi_hendrix]

If you go into setting you can up this 500 item limit to 2000. 

Alternatively, you can bring in 2K records at a time, put into collections and then have a collection of the collections.. This is unlimited as far as I know.. the only limit is that you can only bring in 2K at a time into a collection. 

Just make sure when you make updates to the collection, you also make updates to the actual datasource as well.

[yohannes_adeba]

Many thanks, Jimi. If there is no limit to the collection this seems a better solution in my case.  I would be happy if you have an example of how to create a collection of collections.

Also When you say "Just make sure when you make updates to the collection, you also make updates to the actual datasource as well." are you implying using Patching? can you explain this more please?

Thanks a lot in advance.