Forum Discussion
Attach Microsoft Forms response in email
Hi,
When a respondant competes a form that I have sent them, I get an email notifying me that they have completed it and to click on the link to view the results. I then follow this link and open the response in an excel spreadsheet.
I was wondering if there was a way for the excel spreadsheet that I can see when viewing the link to be attached directly to the email I receive notifying me of the response instead of just a notification. I have had a look at creating a flow for this but cannot seems to find or create a flow that allows me to do the above. Is there a way to do this?
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
I tried to follow what you did above, but am getting this error message: Fix invalid expression(s) for the input parameter(s) of operation 'Get_response_details'.
I just clicked on the options under the 'Get Response Details'- nothing was hand-typed. What am I doing wrong?
Atowriss there are 2 things wrong in your get response details action:
1) In the Form ID you need to select the form from the dropdown, not type its name in the field (but you might have already done this). The only exception to this is if it's a group form where you copy the ID of the form into the field.2) In the Response ID field the only thing that must be there is Response ID selected from the dynamic content box. For some reason you've got resourcedata and body there as well.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
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,
MKI 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
Hi Damien:
I noticed your response in this tread about emailing responses in a formatted email. At our office we have a similar need. We have a form our patients fill out. The form was built in MS Forms online through XL. We receive the responses in the XL file online and from there construct the resulting form to "print" in the office to PDF.
I've tried to build the resulting form FIELD BY FIELD in word to absorb the responses, but either due to our version of office365 or other limitations, the WORD CONNECTOR wont fill in the blanks. The form is complex in the sense of having several pages but simple since it does not re-use data or use conditionals or other operators.
I've looked up several videos on the matter but some of the workflows dont seem to FIT.
Was wondering if you had any thoughts on it.
Thanks!
