Answered

syntax of Mail filter subject query

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

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

Mark solved if this answers your question. Thank you.

Was this reply helpful? Yes No
shantanu97 19 on at

Like (0)

Report
Copy link

Link copied!

@Merco How to filter emails with subject start with "BE" and ignore any other email. Because the email subject always start with BE

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

@eric-cheng

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

Was this reply helpful? Yes No