Forum Discussion
Generating Emails Based On Form Responses
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 u...
Hi gregnoseworthy,
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.
- Ahh... Okay, so I did set that up, but the "Get Manager" connector returns nothing. I have a feeling that our IT department hasn't set that up. My guess is that because I work at a university and the majority of people using this system is grad students... and 'supervisors' can change alot and often.
I think I'm going to try something like adding the email address to the supervisor name, so that it says something 'Jane Doe <doej@university.ca>' and then try to parse out the email address using some of the text functions... I'll post here if I get it working.
Thanks.- Or.. maintain a separate excel sheet that has user to Manager mapping, and have Power Automate connect to this Excel to pull the corresponding Manager email address.
Just laying out options, what you choose to do ultimately depends on your business case.
