I am trying to trigger my Cloud Flow whenever a certain field on a linked entity is not null. Is there any way how to achieve that using the CDS (current) connector?
The equivalent OData query looks like this:
https://mysecretURL.crm4.dynamics.com/api/data/v9.1/accounts?$filter=(_originatingleadid_value ne null and originatingleadid/dw_hubspotid_str ne null) and (originatingleadid/leadid ne null)
I tried the following, but it wont work:
I receive the following error message:
Hi @StefanBre ,
To my understanding you are filtering on linked entity which is not even there in Plugins / Workflows , so ideally you can only filter by look up value and not fields inside that entity.
thank you for your reply.
This is really a pity, I was hoping that this would work with Cloud Flows. Too bad! I just wanted to avoid unnecessary executions of the flow.
Considering Flow as an alternate solution to Plugins / Workflows available in D365 , it is trying to follow similar route. You can only trigger plugin / workflow based on parent record attributes and not linked ones.
If you want to achieve this functionality please put the current entity filtering attributes and then in next action use get record based on the lookup value and then do your filtering after it.