Answered

Challenges with @contains not working

(0) Share

Report

Posted on by GrahamBristol

We have some wide ranging troubles with @contains not working when interrogating email sender and subject lines. Am interested (and would be very grateful) if anyone can spot the problems with these codes!

Example in the case of email sender:

@contains(triggerBody()?['From'], 'my.name@my.company.com')

This does not =true when the sender's email address contains my.name. The only way we have found to get a condition to fire correctly is using @equals which limits things obviously.

Also... when trying to trap some different types of event using a nested if statement in a switch case 'On' box the following also does not work...

@if(contains(triggerBody()?['Subject'],'Alarm'),'AlarmCase',
if(contains(triggerBody()?['Subject'],'Warning'),'WarningCase',
if(contains(triggerBody()?['Subject'],'Test'),'TestCase','DefaultCase')
))

If the email subject contains the words 'Test' or 'Warning' or 'Alarm' this collection of @contains do not fire. We always default to the Default case.

In short, it seems as if @contains simply doesn't work - which is unlikely, or the syntax is subtly wrong, or I'm missing a huge thing here.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @GrahamBristol,

For your first question:

I have made a test on my side and don't have the issue that you mnetioned.

The expresion :

@contains(triggerBody()?['From'], 'Test2@XXXX.onmicrosoft.com')

Works fine on my side and a email is sent from the address "Test2@XXXX.onmicrosoft.com" ,

Please check if the email is sent from the address my.name@my.company.com, the flow distinguish between uppercase and lowercase letters,please make sure the email is sent from the address my.name@my.company.com.

For your second question:

You should create a flow with expression as below:

The expression on the flow should as below:

if(contains(triggerBody()?['Subject'],'Alarm'),'AlarmCase',if(contains(triggerBody()?['Subject'],'Warning'),'WarningCase',if(contains(triggerBody()?['Subject'],'Test'),'TestCase','DefaultCase')))

Please make sure don't enter the expression in the On field directly.

When the subject of the email is equal to Alarm,the flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
GrahamBristol 5 on at

Like (0)

Report
Copy link

Link copied!
Dear Alice,

Thanks very much for your help! On point two, the requirement to add the 'if' in an expression window and not the 'On' box was not clear to me. I've done as you suggest and this works now - thank you.

I'm still having problems with the sender contains conditional flow but I will do some more investigating.

I believe that the behaviour of:
@contains(triggerBody()?['From'], msflow.test')
is different if the sender is msflow.test vs. msflow.test@mycompany.com. In my tests the flow does not fire when the sender is msflow.test however it does fire if the sender is msflow.test@mycompany.com. It seems as if the @contains(triggerBody()?['From'] part requires an abc@def.ghi format. Is that true?

Was this reply helpful? Yes No