Answered

Send two different emails depending on condition

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

i am making a flow with action to send two different emails depending on the condition it meets

but the condition that i build is not correct and i dont know how to fix it. The Condition that i want to set is that if the Excel column "Quarterly" contains any value (text). Email 1 if yes, email 2 if no. But this below setup is not working. do i need to use expression?

What is the correct expression then? please help

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I did a test for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky

thanks. what should i put in the condition value? Col1 is not equal to ....?
i cannot understand your second snip.
and what do you build in the variant compose if yes or if no?

Regards,
Intan

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

You don't need to fill in anything.

Best Regards,

Wearsky

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (1)

Report
Copy link

Link copied!

Ishtash,

Leaving that side of the conditional empty is like saying “if it does not equal null”. If it’s blank it treats it like you’re providing a blank value.

Otherwise you could use the expression empty(ExcelColumn) in the left side of the conditional and type in false as an expression on the right side.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks,

what should i fill if the column equals to not empty?

Was this reply helpful? Yes No
takolota1 4,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

I’m not sure I understand.

If you use Empty(Column) in the left field of the condition and false in the right side, then the condition will continue down the left yes side if the column is empty and continue down the right no side if the column is not empty.

So you just put your different email there.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi

sorry, i understand now. it took me 5 minutes after i wrote my reply to get the logic.
i tested with your guide leaving the cell empty and its working perfectly.

thank you so much!!

Was this reply helpful? Yes No