Deal with Delegation

(0) Share

Report

Posted on by enriqueglopez

516 Moderator

Hi guys, I have N Sharepoint List in my App.

I need to deal with delegation warnings in this code:

If(
 stringPermitAsign = "H1",
 Filter(
 ListH1,
 Deleted = false &&
 Linked = Blank() && <-- The warning is in this ampersand
 !IsBlank(LookUp(AuxiliarList, PermitID = Title, Status <> "Draft"))
 ),
 stringPermitAsign = "H2",
 ...
)

I need to show in a gallery the items that accomplish this requirements:

Deleted column value FALSE
Linked column value BLANK
It exists in other list (AuxiliarList), the column PermitId is equals to Title and Status is not Draft.

Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @enriqueglopez

Check out @WarrenBelz 's blog, where he provides a detailed explanation of utilizing non-Delegable filters and eliminating Delegation warnings.

https://www.practicalpowerapps.com/delegation/with-statement-managing-delegation/

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Any helpful example of how could I solve this problem? Thanks

Was this reply helpful? Yes No
juangonzalezAuc 101 on at

Like (0)

Report
Copy link

Link copied!

try IsBlank(Linked) instead and let me know

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Doesn't work, makes the warning bigger

Was this reply helpful? Yes No
juangonzalezAuc 101 on at

Like (0)

Report
Copy link

Link copied!
to be clear:

If( stringPermitAsign = "H1", Filter( ListH1, Deleted = false && IsBlank(Linked) && <-- The warning is in this ampersand !IsBlank(LookUp(AuxiliarList, PermitID = Title, Status <> "Draft")) ), stringPermitAsign = "H2", ... )
changes the warning? Is still a delegation warning?
IsBlank is a delegable function as Blank() is not.

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, look at this:

Was this reply helpful? Yes No
KaiE 39 on at

Like (0)

Report
Copy link

Link copied!
I would use Not() Function:
If( stringPermitAsign = "H1", Filter( ListH1, Deleted = false && IsBlank(Linked) && <-- The warning is in this ampersand Not(IsBlank(LookUp(AuxiliarList, PermitID = Title, Status <> "Draft"))) ), stringPermitAsign = "H2", ... )

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sadly that doesn't work

Was this reply helpful? Yes No
juangonzalezAuc 101 on at

Like (0)

Report
Copy link

Link copied!

His Answer with your original code should work:

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!

I don't know why, but is not working for me:

PermitID is a String column.

Was this reply helpful? Yes No