
Announcements
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.
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.