Answered

Delegable Filtering of Records With Blank Lookup Value in Dataverse

(0) Share

Report

Posted on by memersond

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.

Categories:

Using Apps Using Formulas

All responses (2)

Answers (1)

memersond 4 on at

Like (0)

Report

Re: Delegable Filtering of Records With Blank Lookup Value in Dataverse

This is great. Exactly what I needed. Thank You.
Verified answer

Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Delegable Filtering of Records With Blank Lookup Value in Dataverse

Hi @memersond ,

You could create a view on the Dataverse side that applies this criteria and then utilize the view instead in the Canvas App. Just a thought...

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew