Contains Function Match to Specific Keywords/Phrases

[Katie]

Hello!

I am trying to have a flow using PA where when an email is received with specific conditions in the subject, that a post is made to a Teams channel. I am trying to have this flow setup for each channel, as each represents a state or region, where the subject contains specific keywords/phrases to match to. 

For example, an email comes in with a subject line similar to "ALERT 20NM NE "WB" (SCWS001)". The "WB" is a code for where this is, lets say Florida. I want PA to post that email to the "Florida" Teams channel I have setup. I have gotten it to post the email to the Teams channels, but it isn't posting to the correct one each time. 

Below is the flow as I have it setup right now:

I think this is an issue with the way I have to tell PA to match the keywords/phrases and I just don't know how to specify that I need it to match exactly to that one very specific portion of the subject. 

[tom_riha]

Hello @Katie ,

if there's a different channel for each of the subject codes then you can't have them all in a single condition. You'll need a separate condition for each of the codes:

• if subject contains WA
  • post message to florida
• if subject contains PA
  • post message to xxxx
• ....

[Katie]

Thank you for your response!

To clarify, I have many codes I need to match where any of those would go to one channel.... For example, I have code X, XY, XZ, AA, etc. and all of those need to post to the "Florida" channel. So I would have to set each of these as a separate condition?

Also, would you happen to know if there is a way for me to tell PA that I want it to match the code to only one very specific portion of the subject? (i.e. it says something like ALERT ### "CODE" (ABC123) and I need the condition to match ONLY the "CODE" piece.

[v-bofeng-msft]

Hi @Katie :

Please try:

Best Regards,

Bof

[Katie]

This is definitely helpful, but I think I must be missing something because it isn't working... Could you check and see if this is missing anything?

[v-bofeng-msft]

Hi @Katie :

Best Regards,
Bof

[Katie]

Hi there,

When I put this formula 

split(triggerOutputs()?['body/subject'],"")[1]  into the expression bar, I get the below error message

I get the same error message if I remove the [1]

[v-bofeng-msft]

Hi @Katie ：

Please copy and paste this formula directly:

split(triggerOutputs()?['body/subject'],‘”’)[1]

Best Regards,

Bof

[Katie]

Hello!

I have tried this and I still get the same error message ☹️

[Katie]

Hello!

I have tried this and I still get the same error message 

[tom_riha · Accepted solution]

Hello @Katie ,

the editor changed the quote characters in the response from @v-bofeng-msft. It has different quote character than the expression expects, try it as:

split(triggerOutputs()?['body/subject'],'"')[1]