Unanswered

Send two different emails depending on condition

(0) Share

Report

Posted on by Community Power Pla...

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 on at

Like (0)

Report

Hi @Anonymous ,

I did a test for you.

Best Regards,

Wearsky

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

Like (0)

Report

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 on at

Like (1)

Report

Hi @Anonymous ,

You don't need to fill in anything.

Best Regards,

Wearsky

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

Like (1)

Report

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... on at

Like (0)

Report

Hi Thanks,

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

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

Like (0)

Report

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... on at

Like (1)

Report

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