Get outlook mail message - Add variable in subject filter condition

Help
1

Hello everyone,

I an having below filter in get outlook message however I am getting error saying “message”: “Get outlook mail messages: Cannot parse condition. Error at "@SQL=((urn:schemas:httpmail:subject LIKE…".”, . Can anyone please help me with it. Basically I want to have a variable in subject filtering condition.

“@SQL=urn:schemas:httpmail:subject LIKE '%” + subjVar + “%’”

Thanks

2

strVarible is my variable of type string

“@SQL=(”“urn:schemas:mailheader:subject”“LIKE '%”+strVariable+“%') OR (”“urn:schemas:mailheader:subject”"LIKE ‘%Tickets front door%’) "

–
Mukesh

3

Thanks Mukesh however getting below error while executing flow.

19.10.1+Branch.master.Sha.0e00272ff1e0363c6709284cfa5bbf8631511d70

Source: Get outlook mail messages

Message: Cannot parse condition. Error at “@SQL=(((“urn:schemas:mailheader:subject”…”.

Exception Type: System.Runtime.InteropServices.COMException

RemoteException wrapping System.Runtime.InteropServices.COMException: Cannot parse condition. Error at “@SQL=(((“urn:schemas:mailheader:subject”…”.
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)

4

@Kapil ,

After a Copy paste from here .

Manually replace Double Quotes with Double Quaotes and Single Quaotes with single Quote because copy paste gives the below
image

and uipath expects
image

It should look Like
image
image757×147 6.34 KB

Mukesh

1 Like
5

Thanks Mukesh! Its working.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.