Forum Discussion

dawny1911's avatar
dawny1911
Copper Contributor
Jul 21, 2021

Microsoft forms

Hi guys- I’m using Microsoft forms for work. Currently we have an active form that sends an email after every submission using a flow.

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

  • daniel245's avatar
    daniel245
    Copper Contributor
    I would like this email to be sent to a specific email address not the responder- populated with some answers from the form.
  • RobElliott's avatar
    RobElliott
    Silver 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

    • dawny1911's avatar
      dawny1911
      Copper Contributor
      Hi 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.
      • RobElliott's avatar
        RobElliott
        Silver 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

Resources