Skip to main content
Best answer

AQS Search with Office 365

  • Nov 18, 2024 3:26 PM UTC
  • 3 replies
  • 417 views

Hello! I am really really struggling with the claimed “AQS” ability of the Office 365 connection.

 

I want to have a trigger which fires when I have a “New Email Matching Search” which is unread, and received 14 day ago.

 

I have used all the of the Microsoft guidance for Outlook: https://support.microsoft.com/en-us/office/how-to-search-in-outlook-d824d1e9-a255-4c8a-8553-276fb895a8da and Outlook.com: https://support.microsoft.com/en-gb/office/search-mail-and-people-in-outlook-on-the-web-b27e5eb7-3255-4c61-bf16-1c6a16bc2e6b.

 

I have tried every combination of everything, and at ths point I can’t even get the basics to work properly, for example, received:“this week” (grabbed straight from the Microsoft support) is returning an email from the 14th November, and then the 3rd November - nothing else.  The “isread” or “read” syntaxes seem not to work at all.

 

What is it that I’m missing? Is this connection just totally broken? Am I using the wrong AQS? Does anyone have any experience where they got this to work as expected?

 

Thank you!

Best answer by JammerS

Hi ​@willbsit,

 

Welcome to the Community.

 

The "New Email Matching Search" trigger in Office 365 uses Keyword Query Language (KQL), not Advanced Query Syntax (AQS), which might explain your issue. Try using a KQL query like

IsRead:no AND Received>=11/5/2024 AND Received<=11/19/2024

to find unread emails received within the specified date range. Test your query in the Outlook web app search bar first, and if problems persist, contact Microsoft Support for further assistance.

 

Let us know if you have further questions.

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • Answer
  • Nov 19, 2024 3:22 AM UTC

Hi ​@willbsit,

 

Welcome to the Community.

 

The "New Email Matching Search" trigger in Office 365 uses Keyword Query Language (KQL), not Advanced Query Syntax (AQS), which might explain your issue. Try using a KQL query like

IsRead:no AND Received>=11/5/2024 AND Received<=11/19/2024

to find unread emails received within the specified date range. Test your query in the Outlook web app search bar first, and if problems persist, contact Microsoft Support for further assistance.

 

Let us know if you have further questions.


  • Author
  • Beginner
  • Nov 19, 2024 8:14 AM UTC

Thank you for that insight, the Step itself in the configuration says AQS:

 

This does already seem to be working better.

 

Thank you so much!


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Nov 21, 2024 10:02 AM UTC

That’s awesome ​@willbsit! A huge thanks to ​@JammerS for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗