Hey everyone,
Our department is new to Power Automate, and I’ve been tasked with building a client intake survey using Microsoft Forms. I need help setting up a flow that triggers an email notification to a specific staff member based on a specific response on a multiple choice question in the form.
For example, one of the questions asks, "What region is your contract in?" Based on the selected region, I want an automated email to be sent to the assigned Client Success person for that region. Since we have different Client Success staff assigned to different regions, the recipient of the email should change depending on the response.
I'm fairly new to Power Automate and can't figure out how to set this up. Could anyone guide me on the best way to configure this?
Thanks in advance for your help!
edit: I've tried using a flow that incorporates a condition on the response data for that question and now I'm stuck trying to figure out how to properly match the condition to the response. The email sending part after this is pretty straightforward.
I attached some screenshots in a response on this thread
✓ Why the Switch action is inefficient and what to use instead
✓ What is a Dynamic Reference Key
✓ Creating a custom look up in Power Automate
✓ Using a Dynamic Reference Key instead of writing an expression with nested if() functions
✓ How to use a Dynamic Reference Key to reduce actions in your flow
✓ How to use a Dynamic Reference Key to route emails to different recipients based on a MS Form Selection
✓ How to reduce redundancies in your flow by using a single Send an Email (V2) action instead of multiple instances
✓ How to use a Dynamic Reference Key to send email notifications 90, 60 and 30 days from today’s date
---
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional