E-mailing Form results based on specific answers

%3CLINGO-SUB%20id%3D%22lingo-sub-813908%22%20slang%3D%22en-US%22%3EE-mailing%20Form%20results%20based%20on%20specific%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813908%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20have%20the%20results%20of%20a%20Form%20e-mailed%20to%20a%20specific%20person%20on%20our%20team%20based%20on%20the%20a%20respondent's%20reply%20to%20a%20(drop-down)%20question%3F%20(i.e.%20option%201%20chosen...results%20sent%20to%20Mr.%20X%3B%20option%202%20chosen...results%20sent%20to%20Ms.%20Y%3B%20etc.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-813908%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-817338%22%20slang%3D%22en-US%22%3ERe%3A%20E-mailing%20Form%20results%20based%20on%20specific%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-817338%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395509%22%20target%3D%22_blank%22%3E%40Thauck%3C%2FA%3E%26nbsp%3B%20yes%20this%20is%20quite%20possible%20but%20you%20need%20to%20use%20Microsoft%20Flow%20to%20do%20it%2C%20it's%20not%20possible%20within%20Forms%20itself.%20Within%20Flow%20you%20would%20have%20a%20trigger%20for%20%22When%20a%20new%20response%20is%20submitted%22%2C%20the%20first%20action%20is%20then%20to%20%22Get%20response%20details%22%20and%20you'd%20then%20have%20what's%20called%20a%20Switch%20case%20action%20which%20would%20look%20at%20the%20option%201%20response.%20If%20it%20was%20A%2C%20it%20would%20send%20the%20email%20to%20person%20A%2C%20if%20it%20was%20B%20it%20would%20send%20it%20to%20person%20B%20and%20so%20on.%20You%20could%20have%20up%20to%2025%20(I%20think)%20possible%20cases%20here.%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20you%20need%20screenshots%20of%20how%20this%20works.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is there a way to have the results of a Form e-mailed to a specific person on our team based on the a respondent's reply to a (drop-down) question? (i.e. option 1 chosen...results sent to Mr. X; option 2 chosen...results sent to Ms. Y; etc.)

 

Thank you!

1 Reply
Highlighted

Hi @Thauck  yes this is quite possible but you need to use Microsoft Flow to do it, it's not possible within Forms itself. Within Flow you would have a trigger for "When a new response is submitted", the first action is then to "Get response details" and you'd then have what's called a Switch case action which would look at the option 1 response. If it was A, it would send the email to person A, if it was B it would send it to person B and so on. You could have up to 25 (I think) possible cases here.

Let me know if you need screenshots of how this works.

Rob
Los Gallardos

Microsoft Flow Community Super User