Forward an email from a shared mailbox if certain words are matched in the subject line

(0) Share

Report

Posted on by Mike19

Hi all,

Flow newbie here.

I'm trying to build a flow that forwards a copy of an email from a shared mailbox to a specific person, when certain keywords in the subject line of the email are met.

It works fine when I only have one word as criteria, like this:

However, if I add now more of the 'default' subject line, for example, B2B RFQ, Some Company name, then it will not run.

I have also tried this setup:

I'm no good with expression, but I tried those as well, with no success.

Any tips & tricks would be greatly appreciated.

Thank you guys

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @Mike19 ,
place the test inside string() expression. That way you tell the condition that the whole string, including the spaces, is the string to look for.
string('some company name')

Was this reply helpful? Yes No
mjburley 370 on at

Like (0)

Report

I think you need OR rather than AND, so ensure your top group AND is OR.

Was this reply helpful? Yes No
Mike19 13 on at

Like (0)

Report

thank you @tom_riha, I tried it with the original subject line from the email, which looks like this:
string('Some Company Name & Something Comp'), but the result was 'False' and the email was not sent.

Was this reply helpful? Yes No
Mike19 13 on at

Like (0)

Report

Hi @mjburley ,
Thank you for your suggestion, same result, Expression result is 'false' and no email was sent...

Was this reply helpful? Yes No
mjburley 370 on at

Like (0)

Report

Can you add screenshots of the flow run to help diagnose?

Was this reply helpful? Yes No
Mike19 13 on at

Like (0)

Report

Hi @mjburley

Certainly, my apologies,

Here is what I have under the conditions:

and then the if 'Yes' is met:

Problem is now, that everything that has B2B in the subject line, is being forwarded ....

Was this reply helpful? Yes No
Verified answer

Mike19 13 on at

Like (0)

Report

Hi everyone,
I think I may have the solution:

Was this reply helpful? Yes No
rcoveyduc 2 on at

Like (0)

Report

Hi Mike,

Can you show what you did higher up in the flow? These steps to set up the controls are logical, but the forwarding piece isn't happening for me when I run it. As far as Power Automate is concerned, the flow ran successfully and there are no flow errors. I suspect my issue is higher up. I've attached a picture of the trigger, one of my controls, and the if statement. email addresses have been removed for confidentiality. I have seven controls, all set up like this. When run, the flow gives the check mark on all. I feel like it's an issue with the subject filter field in the trigger. I'm trying to figure out what action to put between it and the controls because I can't put anything dynamic in that field. Thanks.

Was this reply helpful? Yes No