Answered

Delegable Filtering of Records With Blank Lookup Value in Dataverse

Like (0) Share

Report

Posted on 22 Sep 2021 01:54:40 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 22 Sep 2021 at 16:08:04

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 22 Sep 2021 at 09:39:25

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