Hi
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")
you know what:) how magically delegation warning appeared - same way magically dissapeared.
I guess some authoring version had bugs and MS fixed it.
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 |
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1