Can we use LIKE operator in Outlook Filters?

I have tried to use the filter to get only the emails which contains specific Subject. I know that we can use simple if condition to get the results. But i need filter.
i have used below condition, but i can see syntax errors

I have gone thru the forum for any available solution, but I could not get it.

I can see the related link How to use UIPAth Outlook get Emails filter with LIKE operator but not =, but there is no solution.

Could any help me on this ?

I have corrected the Filter into Correct string format , now the errors were gone.

But while running the workflow , I am getting the exception Exception Type: System.Runtime.InteropServices.COMException:

1 Like

try with this
"[Subject] like ‘%Weekly%’ "

Cheers @rtallapudi

or we can use this in the filter property
“@SQL=urn:schemas:httpmail:subject LIKE '%Weekly%’”

Cheers @rtallapudi

Thank you for your response.
But unfortunately I am getting the exception Exception Type: System.Runtime.InteropServices.COMException in both the above cases.

image

@rtallapudi

@SQL= (urn:schemas:httpmail:subject Like ‘your Subject’)

Thank you for your response.

I have changed the filter condition as per your suggestion, here also I am getting the same exception Exception Type: System.Runtime.InteropServices.COMException

Attached the workflow for reference.

Main.xaml (9.2 KB)

Hello,
Try this in the Filter field:

“@SQL=”“http://schemas.microsoft.com/mapi/proptag/0x0037001f”" like ‘%YOUR WILDCARD HERE%’"

Regards

Hello @byuli ,
Getting the same exception with this filter also, Could you please let me know what does the link “http://schemas.microsoft.com/mapi/proptag/0x0037001f”" refers .

Thank you so much for your time.
Regards

@rtallapudi

Check below xaml it working for me … check & let me know…

Main.xaml (10.2 KB)

Now no exception errors are showing up. Thank you.

But it does not list listing out the emails ,even though there are couple of emails in the Inbox which satisfies the filter condition.

I am not sure :frowning: what might be the reason.

@rtallapudi

Please checked out the properties… in that xaml mention ReadOnly Unread message

Uncheck the properties & check it

Cheers