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!
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?
I answer questions on the forum for 2-3 hours every Thursday!
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?
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.
If this post helps, please consider Accepting it as the solution. Thumbs up if it helped you other way.
sure and let us know
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!