Filter email messages two conditions

I try to filter and count received email in Outlook in a folder using Get Outlook Messages. The filter has two conditions (specific subject and body). I tried through “[Subject] LIKE ‘%Billing%’ AND [Body] LIKE ‘%Billing%’”
but returns an answer that the condition is not true. I also tried through “@SQL=urn:schemas:httpmail:subject LIKE ‘%Billing%’ AND @SQL=urn:schemas:httpmail:textdescription LIKE ‘%Billing%’”
but returns an answer
Get Outlook Mail Messages: Cannot parse condition. Error at “@SQL=urn:schemas:httpmail:textdescriptio…”.

Help please.

@plamenov.plamen

Please try like this

"@SQL=""urn:schemas:httpmail:subject"" like '%Billing%' and ""urn:schemas:httpmail:textdescription"" like '%Billing%'"

Cheers

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

@plamenov.plamen

I believe you copied exactly…I gave one inverted comma wrong…which is the last one…i just corrected…either correct in the code or copy the condition again from above

Cheers

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