Answered

syntax of Mail filter subject query

Like (0) Share

Report

Posted on 31 Aug 2021 03:55:05 by shantanu97

I am using the When a new email arrives in a shared mailbox action and want to filter out emails with the specific keyword in the subject. I tried Subject filter field but whatever I put there the action will work for any email subject.

I want to filter only those email. Email Subject always starts with BE

BE21080245-20210813A-OSL-Final.

BE21080323-20210818A-Final.

BE21080244-20210812B-OSL-Final.

BE21080240-20210812C-OSL-Au Results

Can anyone help me how to filter those emails.

@eric-cheng @ScottShearer

All responses (4)

Answers (1)

Community Power Pla... on 31 Aug 2021 at 12:53:07

Like (0)

Report

Re: syntax of Mail filter subject query

@eric-cheng

Can @shantanu97 use multiple triggers too? Or does the subject has to match all Conditions? And vs Or.
Verified answer

eric-cheng 5,171 on 31 Aug 2021 at 06:29:34

Like (1)

Report

Re: syntax of Mail filter subject query

Hi @shantanu97 ,

I just tried using the subject filter and it triggered only when the subject contained BE. The only issue is that it will trigger with any subject with the letters BE e.g. THERE IS A BEE

You can also specify a trigger condition. The below formula should only allow emails starting with BE to trigger.

@equals(substring(triggerBody()?['subject'],0,2),'BE')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
shantanu97 19 on 31 Aug 2021 at 04:09:00

Like (0)

Report

Re: syntax of Mail filter subject query

@Merco How to filter emails with subject start with "BE" and ignore any other email. Because the email subject always start with BE
Community Power Pla... on 31 Aug 2021 at 04:05:02

Like (1)

Report

Re: syntax of Mail filter subject query

Isn't it an idea to use the Switch control instead?

Mark solved if this answers your question. Thank you.