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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
memersond 4 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No