How do I add as filter in the 'Filter Query' (OData): JSON field 'addressused' does not exists?

[Ayyappa]

Hi

I am connecting to 'ActivityParties' in CDS and trying to use some filters. I already have 2 filters in it and they are working. I need to add a third filter.

ActivityParties has some JSON key values where "addressused" key exists if it is of type 'contact' and does not exists if it is some other type say Account.

I want to add the filter such that I filter out the JSON values if "addressused" field does not exists in it.

Please could you guide me

[ManishJain]

Hi @Ayyappa ,

Is this your custom entity ? 

Thanks

[Ayyappa]

No, it’s out of box Dynamics CRM entity

[v-alzhan-msft · Accepted solution]

Hi @Ayyappa ,

I have made a test and sorry for I don't see any function to check if a field is exist in the data filter and I'm afraid that there is no any way to achieve it in Microsoft flow currently.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.