Unanswered

Send email to different group of recipients from different answers in Forms

(0) Share

Report

Posted on by lopezsyd

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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

Report

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!

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@lopezsyd

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.

Was this reply helpful? Yes No
lopezsyd 8 on at

Like (0)

Report

Would I have to build a separate list in Sharepoint?

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Yes a separate SharePoint list that stores Department names and Emails

Was this reply helpful? Yes No