Flow that post message on teams chat if body of email contains specific word

[JayAdamspt]

Hi team, 

I need your support with a flow, I do not know what I'm doing wrong but the flow I created is not working.

The purpose of the flow is to post the body of a specific email on a chat in teams if and only if the body of the email contains one or both of the mentioned keywords.

Below, you can find a screenshot of the flow:

I tried also in this way ( below ) but it is still not returning all cases:

Thanks for any lead 🙂

[GeorgiosG]

Hi @JayAdamspt ,

from the first look you condition looks correct.

Maybe you have the words in lower or upper case to check, so not like you expect it.

You can try to insert the expression toUpper() like 

toUpper(triggerOutputs()?['body/body'])

toUpper('French')

[JayAdamspt]

Hi @GeorgiosG , 

Thanks for the reply.

However, the issue is not with the keyword format. Indeed, the flow works fine whenever in the report ( email ) there is the FRENCH keyword but if there are both keyword or only the Italian one then the flow does not post the message in teams.

[GeorgiosG]

Can you try to just use one expression in your condition and stuff everything inside there ?

or(contains(mailBody, ‘ITALIAN’), contains(mailBody, ‘FRENCH’)) 

is equal to

true 

Please replace the mailBody with you real variable and you can again think about the usage of  toUpper() to make it more bullet proof 😉 

[JayAdamspt]

Like this?

or(contains(triggerOutputs()?['body/body'],'ITALIAN'), contains(triggerOutputs()?['body/body'],'FRENCH'))

[GeorgiosG · Accepted solution]

The other way around, on the left/first box of your condition paste  this or(contains(triggerOutputs()?['body/body'],'ITALIAN'), contains(triggerOutputs()?['body/body'],'FRENCH'))

in the drop down select. „Is equal“

and in the right box type „true“ 

[JayAdamspt]

Thanks 🙂 now it's working perfectly

[JayAdamspt]

Hi @GeorgiosG 

Need your help again 🙂
What expression should I use if I need the flow to sent an email only if the 2 words "french" and "Italian" are in the same row (2 different columns ) of a table ?