Get mail filter with subject via using variable (office 365 activity)

I want to filter my mail via subject using variable.
Currently I am using “contains(subject, ‘Test’)” but I want to replace TEST with a variable.
I tried
“[Subject]=’”+variable+“’”
“@SQL=urn:schemas:httpmail:subject like ‘%variable%’”
but they wont work. I am getting below error
image

Any help will be appreciated

try this instead (paste into filter)
"@SQL=urn:schemas:httpmail:subject like '%" + variable+ "%'"

Didn’t worked. Also I am using office 365 activity

try this instead
"subject eq '"+variable+"'"

for office 365 need to use graph api query syntax

1 Like

@jack.chan it worked. You are a legend.
Thanks heaps for your help

1 Like

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