Delegation warning

(0) Share

Report

Posted on by Youssef_Arouay

162

Hi,

I use this code for items prop for a data table beside others conditions to filter. For this one I have delegation warning with || and with 'in'. How to deal with for both cases if my data is under 2000rows and if it is more that 2000 !

code :

(IsEmpty(ManagerListFilter_MyTS.SelectedItems) || IsBlank(ManagerListFilter_MyTS.SelectedItems)) 
                || ManagerName in ManagerListFilter_MyTS.SelectedItems.Title,
 
 
   : Delegation warning

Categories:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (2)

Answers (0)

Kushal_M 64 on at

Like (0)

Report

Delegation warning

Hello Youssef_Arouay,

Please try the below formula to avoid delegation issues with any number of datasets.

IsEmpty(ManagerListFilter_MyTS.SelectedItems)
||
CountIf(
ManagerListFilter_MyTS.SelectedItems,
Title = ManagerName
) > 0

🏷️ Please tag me @Kushal_M, if you still have any queries related to the solution or issue persists.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 151,951 Most Valuable Professional on at

Like (0)

Report
Delegation warning

Hi @Youssef_Arouay,

Firstly, you can try this assuming ManagerName is a Single Line of Text field.
If( IsEmpty(ManagerListFilter_MyTS.SelectedItems), YourListName, Ungroup( ForAll( ManagerListFilter_MyTS.SelectedItems As _Items, Filter( YourListName, ManagerName = _Items.Title ) ), Value ) )

Also can you please post (in Text) your full filter - there may be a way to"pre-filter" this.

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

Was this reply helpful? Yes No