How to search only for one specific word in "Get Outlook Mail Message"?

Help Activities
, , ,
1

Hello,

I am trying to filter messages from Outlook and I want to retrieve all messages that include the specific word “keyword” in the subject line, but exclude “keywords” and other combined words.

I have tried:
“@SQL=”“urn:schemas:httpmail:subject”" like ‘keyword’
but that only retrieves all mails where the subject is “keyword” and not subject fields that are e.g. “keyword and something else”.

I have also tried the following:
“@SQL=”“urn:schemas:httpmail:subject”" like ‘% keyword %’ OR ““urn:schemas:httpmail:subject”” like ‘% keyword’ OR ““urn:schemas:httpmail:subject”” like ‘keyword %’ OR ““urn:schemas:httpmail:subject”” like ‘keyword’"
but this also includes subject fields that are e.g: “this is a keyword”.

Any ideas?

2

The queries are formatted the same whether you’re using 365 or regular Outlook activities.