cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TiagoFreire
Level 8

Outlook 365 Connector: ODATA query: filter Contacts by email address

Hi,

 

I am trying to find out whether a Contact with a specified email address already exists, but I am having trouble figuring out the exact syntax. 

 

My difficulty relies on the fact that the Contact has a collection of email addresses, not a single one, so I am not sure hw to filter a sub-property, and I would not like to fetch the whole Contact set and iterate one by one, it would not be efficient.

 

I have been tryint to bang the 'in' comparison operator. like this: 

 

 'someemail@addr.ess' in emailAddresses.Address

 'someemail@addr.ess' in emailAddresses/Address

 

But I am getting an invalid filter clause error. 

I am assuming that the 'in' operator would be able to look each item from the collection and return true on a match. Maybe I misunderstood the ODATA documentation? 

 

Any help is appreciated, thanks!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Outlook 365 Connector: ODATA query: filter Contacts by email address

Hi @TiagoFreire ,

 

Could you please share a screenshot of the configuration of your flow?

Please share more details about your flow and explain more details about your requirement and we could try to provide a proper workaround for you.

 

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.

TiagoFreire
Level 8

Re: Outlook 365 Connector: ODATA query: filter Contacts by email address

Here is the context: 

 

PROBLEM TO SOLVE:

1) parse all email addresses in the From: and CC: fields

2) check if a Contact already exists for each

3) if there is No Contact, create a contact.

 

What is working:

A PowerApps button sends in a text string - it's actually a JSON which I then parse into several parameters. 

One of those Parameters is a Message_ID for a specific email in a specific Outlook 365 account. 

I can fetch the message from the specified email account. 

 

What is not working: 

I want to use Get Contacts (V2) to fetch a collection of Contacts which have a specified email as one of its addresses, using a Filter Query.

The Filter Query will avoid having to do an exhaustive loop over every Contact, which is very time-consuming, and does not scale well. 

 

outlook 365 connector filter flow.png

invalid filter clause.png

 

The Body of the Output Error is: 

{
  "error": {
    "code": "BadRequest",
    "message": "Invalid filter clause",
    "innerError": {
      "request-id": "some-uuid-very-long",
      "date": "2019-08-02T20:15:29"
    }
  }
}

 

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 193 members 4,339 guests
Please welcome our newest community members: