You’re offline. This is a read only version of the page.
17
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.
@atuldeo, use the ClearCollect function in the OnVisible property of the screen then use the collection instead of the Filter.
| 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
|
@AhmedSalih its actually on the the items property of the gallery
and there is a lot of code inside Filter, Search or SortbyColumns.
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.
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
|
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
