Unanswered

IF statement in CC field (Send an Email)

(0) Share

Report

Posted on by Community Power Pla...

Hi Everyone,

I have a flow that sends a mail when an item is created on the SharePoint list. But my issue is that I want to make an IF statement inside the CC field which is based on "Branch" (see picture below). Branch is a column I have in my SharePoint list. So example if Branch inside the SharePoint list is Branch A and Branch B then send mail to "hello@hotmail.com" and if Branch is Branch C and Branch D then send mail to "nice@hotmail.com"

Hope someone can help 🙂

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,678 Most Valuable Professional on at

Like (1)

Report

Re: IF statement in CC field (Send an Email)

I believe the best way to accomplish what you want is to create a variable to hold the CC value and then use either switch or control actions to build out the value of the variable. Then use the variable in the CC value.

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

Like (0)

Report

Re: IF statement in CC field (Send an Email)

Hi @Pstork1 ,

Can you please elaborate on this?

I already have a switch function in my flow that has three cases/mails. Should I make a new one?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: IF statement in CC field (Send an Email)

All I'm saying is that it would be easier to construct the CC addresses as a string variable rather than trying to embed a really long complex If statement inside that one blank. Either way will work, but adding a series of If statements or a switch earlier in your Flow would be easier to troubleshoot.

Was this reply helpful? Yes No