In Dataverse we have two entities,' Appointments' and 'Contacts'. We need to find Appointment records without a value in the 'Assigned Contact' lookup field.
Using the condition:
IsBlank('Assigned Contact')
inside the Filter function yields the correct results, however this approach makes the function non-delegable. We need to scale past the 2000 record limit for non-delegable functions.
Is there another way to test for NULL/Blank Lookup Field Values in Power Apps? IsBlank seems to be delegable when used with any field other than a lookup.
Thank You.