Mar 16 2021
- last edited on
Aug 03 2023
We have been using an MS Form in MS Teams to track when people come and go into the office. One of the requirements is to email each person's supervisor when they fill out the form.
I have set up a 'flow' using MS Power Automate to send a formatted email, but it goes to me only.
One of the questions I have in the form is a drop down selection for the supervisor.
I'd like to have the system automatically email the supervisor, rather than me. So far, there are two ways that I can see to do this;
I am thinking that there should be a way to select one item on a drop down list, that automatically selects another item on another list -- maybe a hidden list... so it automatically selects the correct email address based on the supervisor selected?
Otherwise, I'm going to have to try to figure out a better way to generate the email address in Power Automate?
Thanks in advance.
Mar 17 2021 06:55 AM
You have already set up Power Automate to pull responses from the Form and send a formatted email. Before the "Send an email" connector, add "Get Manager" connector- the input of this connector would be the Form responder's email address. In the next "Send an email" connector, the To/Cc field can be populated from the dynamic output (Mail) from the previous "Get Manager" connector.
Mar 22 2021 04:17 AM
Mar 22 2021 04:34 AM