Unanswered

Choose an email address based on table data.

(0) Share

Report

Posted on by bbreuner

Hello all,

I'm building a flow that sends an email based an address being pulled in from a table. For example the email will be delivered to "EmployeeEmail" and CC'd to "LeaderEmail". However, there is not always an email address in the "LeaderEmail". Where this is the case, I have a "DirectorEmail" column in the same table that I want to CC to.

I need a function to do the following: CC to "LeaderEmail" if "LeaderEmail" is null; CC to "DirectorEmail"

Hope that makes sense!
Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Choose an email address based on table data.

HI @bbreuner,

Do you want to CC to DirectorEmail when LeaderEmail is null?

Could you please tell me that how you configure the CC in your send email action?

If you just pull the email field from the dynamic content, I think you could write a similar expression as below:

if(equals(item()?['DirectorEmail'],null),item()?['DirectorEmail'],item()?['DirectorEmail'])

Was this reply helpful? Yes No
bbreuner 2 on at

Like (0)

Report

Re: Choose an email address based on table data.

@v-qiaqi-msft,

Yes, CC the "directoremail" when the "LeaderEmail" is null.

And yes, I'm pulling in the email via dynamic content.

Was this reply helpful? Yes No