Unable to read all outlook messages using DASL filter query

[rpafactory (Atul Sharma)]

While reading outlook emails, I am using a DASL filter query to search whole mailbox.

Query: “@sql=” +“”“”+“urn:schemas:httpmail:subject”+“”“”+" LIKE ‘%%’"

The query works well if I check “Only Unread Messages” but when I try to read all the messages I am getting following error:

18.4.5+Branch.support/v2018.4.Sha.2a53a262e2c1098055c3ecbdabe73d45e0a6dc29

Source: Get Outlook Mail Messages

Message: Condition is not valid.

Exception Type: System.Runtime.InteropServices.COMException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.Runtime.InteropServices.COMException: Condition is not valid.
at UiPath.Mail.Activities.GetMailActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

UiPath Studio: 2018.4.5
UiPath.Mail.Activities: 1.5.1

Can anybody please help?

[AshwinS2 (Ashwin S)]

Hi @rpafactory

Check this

Condition not valid COMException Outlook Move Mail

I am trying to filter emails prior to moving them to a folder. As far as I can tell it is failing on the filter in the Get outlook mail messages activity. What should the filter look like. Should it be: “from: ‘Nigel Barrett’” I have tried the same but with double quotes throughout. The exception goes: Source: Get outlook mail messages Message: Condition not valid Exception type: COMException Any ideas?

Thanks
Ashwin S

[rpafactory (Atul Sharma)]

Dear @AshwinS2 ,

Thanks for you response. Do you know how to filter email based on some text in subject? As per solution, I can check Subject for equivalence condition only. Is there any way to filter Subject using LIKE??

[AshwinS2 (Ashwin S)]

Hi @rpafactory
Based on Get OutLook Mail Message

Mail Message property

For each item in MailMessage change the type as System.Net.Mail.Message
item.subject.tostring

U can use contains

Thanks
AshwinS

[rpafactory (Atul Sharma)]

Dear @AshwinS2,

As there will be a large number of mails, getting all of them and iterating on each one of them will not be an efficient way. this will reduce robots performance. That’s the reason I am looking for a filter criteria.

Thanks.
@rpafactory

[rpafactory (Atul Sharma)]

Found solution. I am able to read all email. Root cause still not known

Get Outlook Mail Messages Filter Filter By Subject

I want to use the filter option on the Get Outlook Mail Messages activity. I am trying to get all emails that contain the subject “Billing”. What I currently have is “[Subject]=‘Billing’” but this does not return anything. What am I doing wrong? I do not want to use a for loop to iterate over emails unless I can mark the ones without Billing as unread. Thank you SOLUTION: "@SQL=urn:schemas:httpmail:subject LIKE '%Your Item%'" OR "@SQL=""http://schemas.microsoft.com/mapi/proptag/0x1000001E""…

[MadhraSuresh (Suresh)]

@rpafactory

System.Runtime.InteropServices.COMException: Condition is not valid.
at UiPath.Mail.Activities.GetMailActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at

I have tried using DASL Query, and it work for me and i am able to fetch read or unread message both. If i check ‘OnlyUnReadMessage’ then i get only unread message, If I uncheck ‘OnlyOnReadMessage’, I get Read message as well