Announcements
Hi,
My power apps has over 5500+ records in MS Dataverse table. and in a screen where it needs to fetch all those records is showing "Delegation warning". I have attached the code snipet with the underlined delegation warning.
Please suggest me a workaround which I can use to remove this warning as I am not able tp search all the items in the database which is also very annoying for my clients.
Hello, @atuldeo , create a collection with your filter:
ClearCollect( colName, YOUR FILTER)
Then use the collection with the SortByColumn and search instead of the filter and everything else should be the same.
Note: ClearCollect can be in the OnVisible property of the screen where you have your formula or wherever you call that Formula.
If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.
I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.
Visit my Blog: www.powerplatformplace.com
Hi @atuldeo,
Functions such as Text and Lower are not delegatable. To resolve the delegation issue, you could set the value of Text(PocCurrentStatus) in a variable outside of this filter function and use the variable instead in the filter. Same goes for the lower function, you'll probably need to convert your lclPocFilterRequestor to mixed case to match the data source.
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
@AhmedSalih its actually on the the items property of the gallery
and there is a lot of code inside Filter, Search or SortbyColumns.
Even if I remove the Lower function then also I am seeing the delegation warning and even if I do make it mixed case won't it like not recognize some or the other users on the app?
Will StartsWith() be used in that place?
@atuldeo, use the ClearCollect function in the OnVisible property of the screen then use the collection instead of the Filter.
Tried creating the variable outside filter Function using Set() and UpdateContext() nothing worked for me, Also tried delegable function StartsWith() in that particular line but it did not help again
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
