Forum Discussion
Microsoft forms
I have added into the email body some specific answers.
However I wondered if there was a way to populate that same email with the completed form as an attachment?
Thanks
Dawn
17 Replies
- daniel245Copper ContributorI would like this email to be sent to a specific email address not the responder- populated with some answers from the form.
- RobElliottSilver Contributor
dawny1911 you would have to do this with a flow in Power Automate. For the IT ticketing system at my company we send an email, back to the responder with the info they submited in the form, a reference number and other inforation. We just put this in the email but in the flow you could create a PDF and send that as an attachment.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- dawny1911Copper ContributorHi are you able to screen shot these steps?
I would like this email to be sent to a specific email address not the responder- populated with some answers from the form.- RobElliottSilver Contributor
dawny1911 an example of a flow to send an email with a PDF attachment of the answers from a form is as follows:
In Power Automate create a new instant cloud flow then click skip on the next screen - I always like to start from a completely bland flow.
The trigger is a Forms when a new response is submitted and, as always, is followed immediately by the first action which is get response details. You might not need the following 2 actions to convert the date into UK format.
The next action is a OneDrive for Business create file. In this example I've selected for the filename one of the answers in the form which is a car license plate. You need to follow the filename with .html
For the content of the file add text and the questions from the get response details section of the dynamic content box. YOu can add html tags to add line breaks and other formatting.
Next add a a OneDrive convert file using path and select Path from the dynamic content box on the right. Your target type should be PDF.
Assuming you want to keep a copy of the PDF you next add another OneDrive create file action, selecting Filename and File Content from the convert file using path section of the dynamic content.
Finally add a send an email (v2), enter the email address it should go to in the To field. Add some text into the subject and body. Open the advanced options and for the attachment Name and Content fields select File name and File content from the convert file using path section of the dynamic content box.
..and the content of the PDF looks like this:
Rob
Los Gallardos
Microsoft Power Automate Community Super User