Mail subject filter

[Mrabone99]

I'm creating a flow that when an e mail arrives it posts the details (from, date, subject, body) into a teams channel, i want to exclude mails with certain words in subject like gone fishing, automatic reply and Out of office.

i've tried with this set up but so far not working is there a better way?

[Brad_Groux · Accepted solution]

Without the post a message step expanded we can't offer really much insight, as that is likely where the issues lie. From your screenshot, all we can see is that when an email arrives you have a double-and condition, so if the Subject doesn't contains Holiday and Gone Fishing, you'll post a message.

Are you sure you wouldn't want the condition to be an or condition instead of and? Also, you want to likely rethink your logic. You want your action to be in the Yes step when possible, so if the subject Does not contain Holiday, then Yes, post to teams. 

The following documentation is recommended for figuring out the best way to handle your conditions, their logic and expressions: 

• Use expressions in conditions to check multiple values

• Add a condition to a flow
• Apply to Each

• A Visual Explanation of Flow Logical Expressions

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Mrabone99]

Thanks for the reply

Are you sure you wouldn't want the condition to be an or condition instead of and? 

and there it was - i was using and instead of or tbh i hadn't even spotted the drop down 🙂 thank you so much.