How to Capture Form Responses in an email with Flow

In this video we’re going to capture a response to a Form in email. We'll use a Flow in Power Automate to capture the Form responses and turn them into an email. Then we'll email the responder, and a second group, and send the email 'on behalf of' a group.

In the video I mention a link to tell your administrator how to allow you to 'Send on Behalf of'. This is the link you can send to your Exchange Administrator so they know what to do.

🎓 Want more Microsoft 365 classes? Take a look at our school:

🤝 CONNECT WITH US:

[charlietapper]

This is a fantastic video - thank you so much. I would never have worked this out on my own.

[andydonachie]

This video has just saved me and my team literally hours of work every week! Thank you so much!

[stuartharris]

The golden bullet solution I've spent all day looking for! Brilliant video!

[hisivanava]

Hi Matt, well done video with Training Objectives and neatly explained. Thank you.

[Olumide.Oyalola]

Awesome. You just gained a new subscriber to your channel. Very useful tutorial!

[Aresinbabasi]

Very useful video. Thanks.

Is it possible to see the ID number in the content (subject or body) of the e-mail I sent?

[TheWRYYYYYYY]

How would you go about capturing specific responses (like "no" for a yes/no question) while also including the questions themselves? So that the email would display only the questions that were answered "no" along with the answers? I realize it's easy to get the responses using the Condition action, but how can I include the questions too, since they're not dynamic content?

[jcstest]

Hi Matt, great video; that was really useful. I'm helping to create a similarly simply flow (get responses from a form and email to various recipients).
One thing which bugs me is that the date field on the form (which shows in UK format, e.g. DD/MM/YYYY) appears in American format in the email, e.g. YYYY/MM/DD. How can we fix that?
Thanks in advance. Jan

[sunutimes]

Thanks for this video. How would I edit it, if I want the form response to be saved into SharePoint lists and provide a link to it in the email ?

[chairillubis]

Hi Thanks for the video,

But what if we only want to share the score results would it be possible?

[raulcevallos]

Nice video, thanks! What is the software you were using at the beginning of the video to explain the process?

[ralphchiucchi]

Wow this is so cool. Thanks. Is there any way to have the form or the the process add an automated ticket #?

[sashamirabal]

Is there a way to only send an email notification to a specific contact with only the responses to certain questions?

[pero]

I have question. Can you use that for reports/handovers from one shift to another and will that be stored somewhere so I could check the past dates please help !

[samtimmins]

I'm looking to do this, however my form is created through Forms for Excel directly in SharePoint. I can't work out how to find that connection. Any help greatly appreciated, thanks.

[michaelzumpano]

Can attachments from automated emails be made visible to others cc'ed on the email response?

[sherrytrotter]

I"m trying to include a form on Outlook that will send to an automatic email

[NP-zghq]

I Couldn't find the form's name which I created in flow during selection

[dianakeith]

Can you add the questions when creating the flow for the responder's details? So that when the email is sent back to the creator of the form with questions and answers in the email?

[kagr]

Hi there,
I'm trying to create an MS Form that will send an email after it's been filled out. I have an issue because I don't know how to set it up so that the email is sent from the logged-in user's email address. I don't want to set it to send on behalf of the form owner due to security concerns. I would prefer the form to detect that I'm logged in as a specific user, and the email should be sent from that user's account. I'm not sure if I explained that correctly. Is there any conector / azure plugin to make it work?