Forms/Power Automate - Specific Response from a Likert within Forms

[wilsonball]

Hi All

Not sure whether this is possible ...!  I have a form which has a likert within it relevant to a number of different areas/people.  I would like to use Power Automate to email a specific person (who is named within the likert) when their name is chosen with the results of the form.  I understand that their name wont be within dynamic content because it's in the likert but wondered if there's any other way I can get round this?  I can't, unfortunately, redesign the form as it's too big!!

Wondering if someone can help?!

Thanks

Emma

[abm]

Hi @wilsonball 

Could you post a sample screenshot of likert? Also how you going to get the persons email?

Thanks

[wilsonball]

Apologies, it's not a likert, it's a choice.  I have a number of premises within the form to choose and dependent on which premises is chosen depends on the email address.  I would then like to compose an email to the relevant individual detailing the responses given within the form.

Screenshot below:

Any idea?

Thanks

[SPOLHE-C]

I'm assuming this is a Microsoft Form--there are templates available in Power Automate that might work. Trigger: When a form response is submitted; action: create item on SharePoint List; action: send e-mail. Depending on how many different e-mail recipients and the contents of the e-mail, you might want to add a switch, or you might be able just to set the e-mail with dynamic content settings for the recipients.  

[abm]

Hi @wilsonball 

Thanks for the screenshot. I have asked earlier that where you getting the email from? Believe you already have an email for each premises. Here is an example of the form response capture. Below see the compose action step. So in your case capture the result from the choice option and add an IF condition to check what response it is and send email. You need to extend the flow to add multiple IF conditions. You could use Switch case action step instead of an IF condition.

[wilsonball]

SPOLHE-C - Thanks, I don't believe this would be possible due to the fact that the scenario is arising from a "choice" within forms and the relevant fields wouldn't be available through dynamic content.

Thanks

[wilsonball]

Hi @abm 

Thanks for this, you're right, I already have email addresses relevant to specific premises.  I am relatively new to Power Automate and was hoping there would be a template!!  I will give this a go.  

Thank you.

Emma

[SPOLHE-C]

That's true if you're trying to build the flow directly from the form to the email, but if you use one of the form processing to list item templates, you have the choices available on the list item. I have a form with a choice named "Requested Action" and a switch based on that choice, so after When a Response is Submitted & Get Response Details, it goes to Create a List Item.  Some different things have to happen based on the action requested, so: