Skip to main content
Answer

AQS Search with Office 365

  • November 18, 2024
  • 3 replies
  • 262 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.

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
  • November 19, 2024

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
  • November 19, 2024

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
  • November 21, 2024

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! 🤗