I am trying to send contents of form to different managers based on their department. Their departments are part of a question and I want the email to be triggered by specific answers.
For example:
Question: What department are you in?
1. Department A
>If chosen, then the contents of this form would be emailed to the manager of Department A
Thank you for any help if this is possible!
Yes a separate SharePoint list that stores Department names and Emails
Would I have to build a separate list in Sharepoint?
You can use a Microsoft form for your Question and then trigger a flow when a response is submitted.
Then use a switch case based on the question response.
Hi there,
You can use a switch in your flow.
This is how I would go about it, but of course in the Switch top (where I have just "Department") you'd have the outcome from your choice field.
Edit: I like @SudeepGhatakNZ 's idea better. List lookup. So basically "Query List" and "Filter By" Department eq (your-choice).
So many options!
Are you referring to Microsoft Forms or SharePoint form?
If it is SharePoint, you could have a Lookup column to a list that stores Department names and the emails
stampcoin
51
Michael E. Gernaey
39
Super User 2025 Season 1
CU30040420-0
23