Unanswered

Collection Showing delegation

(0) Share

Report

Posted on by ursNani

215

Hi ,

I am filtering data ON Screen visible . here is my code ClearCollect(CollALL,Filter('Development Specs','Revision?'<>true && 'Parts in SAP?'=true)) .

But it is showing delegation warning . Please help me

Thank you

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ursNani

Using "Not" (or <> in your case) is not delegable to your datasource.

Depending on the size of your list, there are several ways to work around it.

I hope this is helpful for you.
ursNani 215 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Hi
Please help me how i can remove delegation warning .

Thanks
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ursNani

As mentioned - this depends on the size of the list. How big is the list?
ursNani 215 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Now it has 3k+ items and its still counting
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ursNani

So your criteria for the <> is never going to be delegable (or at least not any time soon).

You would need to either:

A) Implement a different logic in a column in your datasource (i.e. a 'Not Revision?' column) that would contain the Not of your Revision column.

B) If your Parts In SAP result set will be less than 2000, then you can change your formula to the following:

With({_preFilter: Filter('Development Specs', 'Parts in SAP?')}, ClearCollect(CollALL, Filter(_preFilter, !'Revision?') ) )

C) Pull all records into your app (bad choice, but if there is no other option!)