Unanswered

Delegation issue with my Dataverse table

(0) Share

Report

Posted on by atuldeo

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
atuldeo 17 on at

Like (0)

Report

@AhmedSalih its actually on the the items property of the gallery
and there is a lot of code inside Filter, Search or SortbyColumns.

Was this reply helpful? Yes No
atuldeo 17 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
atuldeo 17 on at

Like (0)

Report

Will StartsWith() be used in that place?

Was this reply helpful? Yes No
atuldeo 17 on at

Like (0)

Report

Will StartsWith() be used in that place?

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No

atuldeo 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No