Filter in GetOutlookMailMessages

[akhi_s27 (Akhilesh S.)]

I am able to get messages from a given mailbox.
But am not able to get filtered messages.
What is the way to filter mails from a specific sender

Couldn’t Find anything here

[aksh1yadav (AKSHAY YADAV)]

hi @akhi_s27

Please refer this link:

How to filter messages in Get outlook mail messages

Siva Senthil May 10, 2016 12:42 ANSWERED I can retrieve messages using the activity “Get outlook mail messages”. However, I do not understand how to use the Filter property of the activity. What is the syntax of the VB Expression to use there?

and let me know if you have still any doubts.

Regards…!!

[akhi_s27 (Akhilesh S.)]

Thanks a lott for that…

But can you please help me solving my problem…

“”“urn:schemas:httpmail:subject”" LIKE ‘%20170203%’"
“@SQL=”“urn:schemas:httpmail:subject”" LIKE ‘%20170203%’"

This is what I have tried in the UiPath filter option.
But still getting a Condition is invalid error.
Can you please help?

[andrzej.kniola (Andrzej Knioła)]

Last time I tested only Jet syntax was working, see this topic:

I cant get wildcarts to work on filters in mail messages

Bo Fritzen October 03, 2016 10:47 ANSWERED I have been trying to get filters to work in mail messages but at this point I have only been successful with “[Subject] = ‘some text string’”. What I can’t get to work is using wildcart or anything else f.ex. LIKE, IN, CONTAINS, %, * or [%] I have been reading what I could find regarding this subject and followed the links to Microsoft’s sites about Jet, I just can’t get it to work. Could someone please give me an example on a filter that do this…

Seems it’s still like this…

[charlieAJ47 (Charlie)]

@aksh1yadav @andrzej.kniola thanks for the posts.

Do you know how to filter outlook mail messages by category - for instance, I am trying to get only mail messages that are not categorised already (e.g. “Business” or “Personal” etc.) then assign these uncategorised messages to a category, (e.g. Business)

Thanks

[SaranyaKishore (Saranya R)]

Hi @charlieAJ47,

Did you get any solution for this issue? I am also having the same issue and searching for the solution.
Please help me if some one have idea on this.

Thanks,
Saranya K R

[grant.grisham]

for exact matching use =>

"[Subject]="+variable

for starts with use =>

"@SQL=""urn:schemas:httpmail:subject"" like '"+variable+"%'"

for matching any use =>

"@SQL=""urn:schemas:httpmail:subject"" like '%"+variable+"%'"

The % is a SQL wildcard. This seems to only work for subject and body (textdescription in SQL). You cannot use AND/OR logical operators in your SQL filter since strict filtering is enabled in UiPath and I have no knowledge on how to disable this. You can use logical operators in exact matching using timeframes and I assume others, but I haven’t tested this.

[grant.grisham]

Upon doing my own research I have found this to be false. I am able to implement logical disjunction in the SQL schema. Furthermore, I am able to use the sql queries on a much more content than the three listed above. I am unable to list them due to time constraints but look up something like “Outlook mail message filter SQL” and I’m sure you’ll find a list.