Outlook 365 Connector - Search Query inconsistency on 'Subject:'

[Drezdent]

I am on Designer 2021.4 using the Outlook 365 input v1.0.0

My issue is that the Search Query seems to work perfectly for 'From:' queries.  But when I try to apply a 'Subject:' query I get sporadic results.  I have a few email Subjects that the tool has no issue pulling in.  The number of words or characters in the 'Subject:' do not seem to be a factor as I have some single word and multi word queries that appear to work consistently.  But some I put in, and the tool simply will not pull the email into the flow.  I cannot determine a driving factor for this.  

To be clear, it is not that the query works one day, then the next day it doesn't. It either consistently works, or consistently doesn't.  For instance:

Query - Subject:Associate Detail Report - This will always pull in the email I am expecting

Query - Subject:Daily Proposed Report 2023 - This will never pull in the email I am expecting

I have tried to do partial subject, entire subject, single word, multi word, without numbers, with numbers, with attachment, without attachment...I simply cannot make a determination on why the tool is recognizing emails with some queries and not with others.  I know that not all outlook queries work with this tool.  But I do know I am using the 'Subject:' query successfully in some cases.  So I know it works.  If anyone has any insight at all, I would be eternally grateful for you assistance in understanding this.

[Anu1989s]

Even I'm facing similar issue. Please let me know if you were able to fix this issue. 

[bzimmer]

I am also having the same issues.

Have you had any luck searching on date? I can't figure that out either.

edit: Way to search between dates = "Received:01/01/2023..06/01/2023"

https://learn.microsoft.com/en-us/previous-versions/office/developer/exchange-server-2010/ee693615(v...

[AshRez]

I know this is old, but for anyone looking for this information, this might help:

Not all outlook search query works, but you can try all you can until you get what you need, or close to it.

This link helped me understand how Outlook search query string works:
https://support.microsoft.com/en-us/office/how-to-search-in-outlook-d824d1e9-a255-4c8a-8553-276fb895...

Also, you can use the search in outlook application on the top bar, and use it with the arrow down dropdown to fill the fields with your criteria. then copy this search string into Alteryx Outlook input tool.

1- if you searching for any keywords just type it in there, note that the space means "OR" but if you want to be specific you can use OR, AND, NOT. if you want to use exact phrase, keep it in double quotes, example, "Bobby Moore" , or ("Bobby Moore" AND 13) to find emails with both conditions applies.
2- if you want to have the search based on specific field, must have the field name followed by colon ":", example subject:"bobby moore"
3- combine multiple search filed criteria you have space between it, example:  subject:"bobby moore" received:2025-03-01..2025-03-07

if you search using subject:bobby moore, it would mean to search for any email that has bobby or moore in the subject.

Also notice that searching relative dates doesn't seem to work in Alteryx, example received:"this week", but works in Outlook search.
also if you want to include the time (little tricky, because time won't match what you see in your inbox), you can use datetime format as follow:

2025-03-01T20:10:00

I hope that helps someone.