Get Outlook Mail Messages: Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled

Help Studio
, ,
1

Hi all , I am getting this error as i am trying to run my process .
I have this filter expression
“[Subject] LIKE ‘%Success %’ AND [ReceivedTime] >=’”+Now.AddDays(-2).Date.ToShortDateString+“’ AND [ReceivedTime] <= ‘”+Now.Date.ToShortDateString+“’”

Or is there other way that i can filter emails base on a specific keyword in subject and by the received today and D-1 .
I tried a lot of expression but it not working , please help thank you

2

HI,

In many case, it’s caused by double quote except 0x22 " character. For now, can you try to replace (retype) all the double quote with " character. (Please copy and paste if necessary)

Regards,

3

I tried change the double quotation , the new expression look like this :
“[Subject] LIKE ‘Success %’ AND [ReceivedTime] >=’”+Now.AddDays(-2).Date.ToShortDateString+“’ AND [ReceivedTime] <= ‘”+Now.Date.ToShortDateString+“’”

But i got this error :Get Outlook Mail Messages: Condition is not valid.

4

Hi,

I don’t think Jet style query supports LIKE operator.
It may be necessary to apply filter regarding date then filter result with subject, for example.

Regards,