How to Filter E-mails in Get Outlook Mail Messages, where E-mail subject does not contain a string

So I’m trying to get all the E-mails in a folder, where their subject does not contain a certain string(Which is the Current Date)

I tried using this code for the filter part in outlook

"@SQL=(urn:schemas:httpmail:subject NOT LIKE '%"+Date.Today.ToShortDateString+"%')"

But it seems using NOT LIKE is not possible. Is it possible to directly filter it out?

1 Like

HI @Shinjid

Try this expression
Either use → Not item.Subject.Contains(Date.Today.ToShortDateString)

Have a look on the document

Regards
Gokul

I mean like filtering directly using get outlook mail messages, under filter field. I got the Filter expression from the site, but I can’t find a filter for this one.

1 Like

Did you find a solution for this?