Hi,
I'm using Dataverse tables for my Canvas Power App. In the OnSelect property of one of my buttons in a gallery i've got this piece of code:
If(
LookUp(BillingProcessLists,GUID('Billing Milestone ID') = ThisItem.'Billing Milestone','Head Approver ID') = Office365Users.MyProfile().Id,
Set(accountSheetViewingMode,"approver"),
Set(accountSheetViewingMode,"viewer")
);
I'm using lookup to find a record in my BillingProcessLists table, trying to get it by comparing GUID values. My Gallery has items from the Billing Milestones table (CRM default table). Now, Billing Milestones has a unique GUID like every dataverse table does, in my app i'm saving those GUID's as text in the BillingProcessLists table. Many BillingProcessList records can reference only one Billing Milestones record.
My issue with this setup is that i get the delegation warning, even though i'm using Lookup by GUID which is supposed to be delegable as per this resource: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-common-data-service#power-apps-delegable-functions-and-operations-for-dataverse
Anybody got any idea what is causing the issue?
