Forum Discussion
Attach Microsoft Forms response in email
Hi Joel2275
There's currently no direct way to get the result in this way.
However, you could try instead to use Microsoft Flow and when a new form is submitted, to have the results emailed to you (see my template below as an example).
Step 1 - Use this to retrieve the submitted forms info.
Step 2 - Using Outlook - Send an email (V2), you can specify yourself as the recipient and then populate the Body with the headers and (green) form attributes.
Would save you having to actually hunt for the result in Forms as it's sent directly to your inbox.
Hope that makes sense?
Cheers
Damien
Hi Joel2275
There's currently no direct way to get the result in this way.
However, you could try instead to use Microsoft Flow and when a new form is submitted, to have the results emailed to you (see my template below as an example).
Step 1 - Use this to retrieve the submitted forms info.
Step 2 - Using Outlook - Send an email (V2), you can specify yourself as the recipient and then populate the Body with the headers and (green) form attributes.
Would save you having to actually hunt for the result in Forms as it's sent directly to your inbox.
Hope that makes sense?
Cheers
Damien
Damien_Rosario RobElliott Joel2275
Appreciate all the responses thus far. I'm not as familiar with FLOW, FORMS and most OFFICE Apps as I could be, but am learning...
Hoping to get some further advice/instructions on how to accomplish a similar FORM-FLOW setup.
I have a Form created, and set up a FLOW to email it to our HelpDesk system (Solarwinds). So far, I've been able to set it up so that the email sent to our HelpDesk generates a new ticket, however, there is no info in the body of the email. What I WANT is the email to HelpDesk to include the link to the FORM response. I don't need it to send the specific responses to the body of the HelpDesk ticket. A link back to the responses is fine. I just don't know how to set that up.
I hope I'm explaining it well enough...Any help or clarifying questions, please lmk.
Best,
MK
michellekafel if I understand the process correctly, from a previous flow I put together. all your form answers are collected in an online spreadsheet. You should be able to share the link to the responses in the body of the OUTGOING email telling your team there is a new response. Always the same link embedded in said email.
You should be able to access it from the admin page of the form itself.
This link will be to all responses generated by that form, but will be sent as soon as a new entry is added. That's as easy as it gets.
- I understand that, but I don't think I set up the FLOW correctly, then. So far, I only get a new ticket created (the email to HelpDesk) w/no info or links to further data. The body of the ticket/email is blank.
michellekafel this is the simple flow I put together for my form. Since im using some of the fields of my form on the email I added the GET RESPONSE step. However if your message doesn't use that info, you can skip and go straight to the SEND AN EMAIL step. Once you click on it you can then edit the body of the email to your linking.
Once you click on it you can then edit the body of the email to your linking.
I didn't use links on my message body since all the relevant users already had a shortcut available, also the needed data was on the body.
I hope you are well.
I'm not aware of any easy way to extract the actual form response link itself and have it emailed to SolarWinds via Power Automate.
I would suggest just populating the email with the relevant fields so that the response is captured in the body (I know it's not what you wanted but it's one of the viable options you can do [recommended])
OR
you can dump the output of the form response into a file to then attach to the email and send (this will require more work).
Looking at your Flow, you'll need to have Get responses to allow you to grab the form responses to add into your email (using Dynamic content) before sending the email.
Hope something in there helps.
Cheers & best wishes
Damien
Another quick question -
Must I have the Microsoft Pro license to use Power Automate to create this template with GET RESPONSES?
I may outsource this if I cannot do it myself, but I want to at least give it the 'ol college try!
Thanks again for the feedback.
Best,
Michelle
