Send an email to a specific person depending on a field they select on the form

[kbrackman]

Hello! I'm very very new to Power Automate. I have a creative brief form that, depending on the department they choose, should be sent to that department's team lead. I saw some posts about using Get Response, Apply to each (I have no idea what this even means) and then using a control But when I use "equals to" on the control, the field that it equals to doesn't pull the option I want. Help!

[Rhiassuring]

Hi there, 

I'd recommend first creating a SharePoint List where you can store the name of each department in one column, and then the name (using a People / Group field) of the Department Manager using the other. 

A few questions so we can give you the right advice...

- Can the user only select a single department? Or multiple departments?
- Will you send an Email or an Approval Task to the Department Manager?
- How many different departments are there?

Cheers,

Rhia

[kbrackman]

Thanks so much for the reply!

They should be able to select multiple departments. We'd like to send just an email to the department manager. 

There are 3 departments.

My hiccup was that when I'd try to the condition, the Department contains (the different departments won't show up. The questions will show up but not the options for the questions, if that makes sense). I've attached screenshots. I tried it multiple ways such as including an "Apply to each" which I don't really understand what that means. Maybe my logic is off? 

[kbrackman]

Hi Rhia. I still need help.

[Shujaath_Khan]

Hi @kbrackman 

As the departments are limited to three can you try switch instead of condition and send mail to respective department manager? This way you can customize mail content and set manager as needed. Good starter way though.

Thanks

If this post helps, please consider Accepting it as the solution. Thumbs up if it helped you other way.

[kbrackman]

Oooh, I will try that, thank you!

[Shujaath_Khan]

sure and let us know

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.