Unanswered

Sudden delegation warning on Lookup

(0) Share

Report

Posted on by julijazas

820

I newer leave my apps with delegation warning and it was working fine probably before some update and i noticed a delegation warning on my formula on my lookup part. This is the formula. Database is dataverse.

can you help to improve it?

If(
LookUp(Filter(Transactions,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektoNuorodaCard.Selected.'Projekto pavadinimas'),
SearchID = ThisItem.new_Projectname.'Projekto pavadinimas' & ThisItem.new_componentname & FilterDarboTipasCard.Selected.new_stagename, true
),

"Įrašas egzistuoja",
"Įrašas neužfiksuotas")

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @jja, use collection instead of the Filter inside the LookUp. Create a collection somewhere:

ClearCollect(collection,Filter(Transactions,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektoNuorodaCard.Selected.'Projekto pavadinimas'))

Then:

If(LookUp(collection,
SearchID = ThisItem.new_Projectname.'Projekto pavadinimas' & ThisItem.new_componentname & FilterDarboTipasCard.Selected.new_stagename, true
),

"Įrašas egzistuoja",
"Įrašas neužfiksuotas")

If my reply helped you, please give a 👍 , & if it solved your issue, please give a 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No

julijazas 820 on at

Like (0)

Report

@AhmedSalih
you know what:) how magically delegation warning appeared - same way magically dissapeared.
I guess some authoring version had bugs and MS fixed it.

Was this reply helpful? Yes No