FILTER DELEGATION LARGE DATA SET

(0) Share

Report

Posted on by YamiteKudasai

195

Hello everyone,

Good day!

I would like to ask what is the best way to avoid delegation using my filter below.

The first filter I used. But i'm having delegation the blue one.
Sort(
 Distinct(
 Filter(
 'Service Region Market',
 !(Vendor)
 ),
 Service.Value
 ),
 "Result"
)

Next one is same with first.
Sort(
 Distinct(
 Filter(
 'Service Region Market',
 !IsBlank(Vendor)
 ),
 Service.Value
 ),
 "Result"
)

Last is: Having incompatible comparison
Sort(
 Distinct(
 Filter(
 'Service Region Market',
 Vendor <> Blank()
 ),
 Service.Value
 ),
 "Result"
)

Thanks in advance for your help. guys!

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 151,875 Most Valuable Professional on at

Like (0)

Report

Re: FILTER DELEGATION LARGE DATA SET

Hi @YamiteKudasai ,

You have two issues here - Distinct is not Delegable, neither is Not() which includes <> and !IsBlank. You therefore cannot do what you want in a Delegable manner. Also what type of field is Service - you would normally not be able to do a Distinct on that?

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
YamiteKudasai 195 on at

Like (0)

Report

Re: FILTER DELEGATION LARGE DATA SET

Hi @WarrenBelz , Service is a lookup column

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

Re: FILTER DELEGATION LARGE DATA SET

The real code below. When I used collection its okay. But I don't want to use collection since the data is so big. I need to do it direct to datasource filter.

Was this reply helpful? Yes No
WarrenBelz 151,875 Most Valuable Professional on at

Like (0)

Report

Re: FILTER DELEGATION LARGE DATA SET

Hi @YamiteKudasai ,

Third reason - you cannot use Distinct on a Lookup column without using AddColumns, which is also not Delegable. Unless you want to do a big collection, you cannot do this.

Was this reply helpful? Yes No