In operator alternative to avoid delegation

(0) Share

Report

Posted on by Tono_Analyst2

127

Hi,

I have multiple SharePoint Lists and I am trying to filter contents in one list based on a dropdown selection driven by another list.

Please refer to the example I have made below:

I am currently using an 'in' operator to show all fruit brands associated to the selected dropdown.

What alternative method (loophole) can I implement to avoid the delegation warning caused by the in operator which is not delegable.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Tono_Analyst2 ,

Firstly, in and Search are not Delegable (as you know). How many items are in the list and are you using any other filters in conjunction with in?

Was this reply helpful? Yes No
Tono_Analyst2 127 on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

How many items are in the list
I currently have 5 in the list driving the dropdown box (will increase overtime to maybe10~30). In the list that is being filtered, there will be 2000+ items (exceeding the delegation limit).

are you using any other filters in conjunction with in?
In my actual use case, yes. I have a filter within in a filter in a rough format as follows:
filter(List, ID in filter(...).ID)
The reason I have nested filtering is because there are numerous related lists. I am filtering the 'end list' by a selected element at the 'top list'

I have tried to simplify my question in the fruit example and wish to achieve the below functionality whilst avoiding delegation errors (if possible).

Filter( 'ListB', IsBlank(DropDown.SelectedItems) || 'GUID' in DropDown.Selected.GUID )
I apologise in advance for the confusion.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,463 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Tono_Analyst2 ,

I asked the question on other filters as you can "pre-filter" with a delegable filter and then if the result is under 2,000 items, apply the non-delegable filter to it, but this is not the case for you.

Assuming GUID is numeric, you could do a Collection

ForAll( DropDown.SelectedItems As aGUID, Collect( colB, If( IsBlank(DropDown.SelectedItems), 'ListB', Filter( 'ListB', 'GUID' = aGUID ) ) ) )

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No