Power Platform Community Forum Thread Details

Hi everyone,

On the back of my post in the Dataverse section here, I am facing a delegation warning when attempting to filter results by whether one or many of the multiselected values in my Choice columns appears in a collection (or alternatively a combo box, can use either).

The code is as per the following logic:

Filter('MyTable' As t,
true in
ForAll(myCollection As c, c.'Valid Choice ID' in Concat(t.'MyChoices', Value & ",")))

So, if my table MyChoices column has Choices of "A","B" and the collection/combo box has a value of "A" and/or "B" included, the row will be returned.

Works fine but I'd rather have a solution that supports delegation even though the likelihood of exceeding the limit in this case is extremely remote.

Thought I'd repost this aspect here as it is more appropriate. I will explore a many-to-many relationship if this can't be resolved but would like to keep things simple if possible.

Categories:

Building Power Apps