web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

IF statement in CC field (Send an Email)

(0) ShareShare
ReportReport
Posted on by

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" 

 

 

Capture.PNG

 

Hope someone can help 🙂

 

I have the same question (0)
  • Pstork1 Profile Picture
    68,273 Most Valuable Professional on at
    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.

  • Community Power Platform Member Profile Picture
    on at
    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?

  • Verified answer
    Pstork1 Profile Picture
    68,273 Most Valuable Professional on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard