Can we use LIKE operator in Outlook Filters?

[rtallapudi (Rama Satyanarayana Tallapudi)]

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 ?

[rtallapudi (Rama Satyanarayana Tallapudi)]

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:

[Palaniyappan (Palaniyappan P)]

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

Cheers @rtallapudi

[Palaniyappan (Palaniyappan P)]

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

Cheers @rtallapudi

[rtallapudi (Rama Satyanarayana Tallapudi)]

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

[amaresan (Amaran)]

@rtallapudi

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

[rtallapudi (Rama Satyanarayana Tallapudi)]

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)

[byuli]

Hello,
Try this in the Filter field:

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

Regards

[rtallapudi (Rama Satyanarayana Tallapudi)]

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

[amaresan (Amaran)]

@rtallapudi

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

Main.xaml (10.2 KB)

[rtallapudi (Rama Satyanarayana Tallapudi)]

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 what might be the reason.

[amaresan (Amaran)]

@rtallapudi

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

Uncheck the properties & check it

Cheers