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...
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.
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.
Just laying out options, what you choose to do ultimately depends on your business case.