Unanswered

Delegation Warning

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am using below lookup formula but it throwing me delegation warning.
LookUp(
Journeys,
'Camp Lookup'.'safety vwAllCamps' = LookUp(
'safety vwAllCamps',
Camp = ComboBox7_1.Selected.Camp,
'safety vwAllCamps'
),
Journey_ID
)

Delegation warning is for below part-
LookUp(
'safety vwAllCamps',
Camp = ComboBox7_1.Selected.Camp,
'safety vwAllCamps'
)

Also it giving me delegation for below code-

Filter(Journeys,!IsBlank('Camp Lookup'))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

For the first one:

Do you have a 'safety vwAllCamps' column in your 'safety vwAllCamps' list? If not, then this is causing the issue. Your lookup requires 2 parameters, 3 optional. First is the datasource, second is the criteria and the third (optional) is what you want the Lookup to return.

For the second one:

You cannot delegate the !IsBlank. You can delegate 'Camp Lookup' = Blank(), but not the negative of that.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,
Do you have a 'safety vwAllCamps' column in your 'safety vwAllCamps' list?
Ans- Yes, it's a GUID column.

For the second one:
You cannot delegate the !IsBlank. You can delegate 'Camp Lookup' = Blank(), but not the negative of that.
Ans- 'Camp Lookup' = Blank(), this is not working beacuse Camp lookup is my lookup column so I am able to equate it with blanks, throws error saying "Invalid argument type"

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

So the first thing to really ask...is this a problem (the delegation warning that is). Will you have more than 2000 records in your list that you need to perform delegable criteria against? If not, then I would resume what you have and ignore the warning.

As for the other two questions:

- ah, so this is Dataverse!

- for the second - I don't believe it was checking for blank that you even wanted - I believe you wanted to find those that were NOT blank. Which again, just isn't delegable.

Was this reply helpful? Yes No