web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dataverse Trigger Filt...
Power Automate
Answered

Dataverse Trigger Filter for null Lookup not working

(0) ShareShare
ReportReport
Posted on by 92

I have a flow on create of a Contact and want it to trigger when a custom lookup {publisher}_joincampaignid is null.

 

The trigger parameter copied from FetchXML Builder is (_{publisher}_joincampaignid_value eq null)

 

I can save the flow successfully, but it then fails with the message:

 

Exception parsing (_{publisher}_joincampaignid_value eq null) submitted for attribute filterexpression of callback registration. Target entity: contact. Exception: Microsoft.OData.ODataException: Could not find a property named '_{publisher}_joincampaignid_value' on type 'CallbackRegistration.contact'.

 

I have another flow that checks has an equivalent filter for currency: (_transactioncurrencyid_value eq null) and this doesn't give an error.

 

Is this a bug, or have I got something wrong in the filter?

 

Any help would be appreciated.

Categories:
I have the same question (0)
  • Verified answer
    alex_mcla Profile Picture
    92 on at

    To close this out in case anyone is looking into this issue, this was solved by changing the filter to ({publisher}_joincampaignid eq null) - note no underscore before the publisher.

     

    So, at the time of writing, it seems that some lookups work with the underscore and _value, and other don't.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard