Convert Microsoft Forms with attachments to PDF¶

In this article, we’ll go into how to convert Microsoft Forms responses containing attachments to one PDF document. We’ll use the Plumsail Documents connector for Power Automate to do the main job.

Note

There is a quicker and simpler way to convert Microsoft Forms responses to PDF if your form doesn’t allow sending attachments. See this article for more information.

To the joy of many clients, Microsoft Forms now provides an ability to upload files into form responses. The feature is still restricted as it works only for respondents within one organization.

Let us say you have a Microsoft form with attachments fields to gather order requests submitted by a sales team. An attachment is required to be a DOCX file with customer company details. You need to merge the form responses with the attachment as a single PDF.

Here is how to achieve the goal in Power Automate Flow.

Prepare Microsoft form
Create Flow
Conclusion
Related articles

Prepare Microsoft form ¶

Before creating the Flow, let’s have a look at the form we’ve prepared to demonstrate the case. Here is how it looks:

You can use this particular form for testing purposes. Use this link to duplicate the form in your Microsoft Forms account.

To create Microsoft Forms from scratch, follow the instructions.

Create Flow ¶

Here is the picture of the complete Flow, and under it, you’ll find all the steps in detail.

Power Automate Flow to merge MS forms responses with attachments

When a new response is submitted ¶

Our Flow is automated to start on a Microsoft form submission. Search for Microsoft Forms in Power Automate and select When a response is submitted as a Flow trigger.

If this is your first Flow with Microsoft Forms, on this step, sign in to your Microsoft Forms Account from Power Automate to use your forms inside Flows.

Then, pick the form to track from the dropdown.

Get response details ¶

To use the submitted data further in the Flow, add this action - Get response details - from the Microsoft Forms connector.

For the Form Id, select the same form as in the trigger. For the Response Id, select List of response notifications - Response Id in the Dynamic content menu on the right:

Create HTML from template ¶

We need to create 2 PDFs: One is from the attachment data, the second - from other fields.

We’ll start from the non-attachment fields. First, we’ll create HTML, and in the next action will convert it to PDF. We’ll use actions both from the Plumsail Documents connector.

If this is your first time using the Plumsail Documents connector, Power Automate will request the Connection Name and API Key.

Create connection in Power Automate flow

You can type any name for the connection, for example Plumsail Documents.

Once the connection name is filled out, create an API key in your Plumsail Account, copy and paste it into the Access Key field, and then click Create.

The first is Create HTML from template. In our case, it’s simple.

In Source HTML, we just added text HTML template for our order request - Customer company name and Products of interest. You may see {{curly}} braces - they represent tokens that will be replaced by the response data:

<h1>Order Request</h1>
Customer company name: {{company}}<br>
Products of interest: {{products}}<br>

Note

Please, get acquainted with how Plumsail Documents HTML templates work to compose your customized templates.

In Template data, we used Dynamic content from the previous step to specify values with the submitted form data.

Convert HTML to PDF ¶

This action is from the Plumsail connector as well. It converts HTML we’ve composed on the previous step to PDF.

Put Result HTML - the output of Create HTML from template - into Source HTML:

Now, that we have text questions converted to PDF, it’s time to move to attachments.

Compose ¶

This action is needed to get the sample JSON payload for the next action - Parse JSON. Place the output representing the attachment into Inputs.

You can delete this action from the Flow once you’ve got the sample payload.

To get it, you need to run the Flow. For that, submit the Microsoft Form with attachments.

After it ran successfully, copy Outputs:

Parse JSON ¶

Add the Parse JSON action next. It has two parameters:

Content. Place the attachment output from the Get response details.
Schema. Click Generate from sample and paste there the Outputs that you’ve copied previously.

You should receive the schema like this one:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

Convert email message to PDF in Power Automate

Batch convert Word documents to PDF using Power Automate

Convert Microsoft Forms with attachments to PDF¶

Prepare Microsoft form ¶

Create Flow ¶

When a new response is submitted ¶

Get response details ¶

Create HTML from template ¶

Convert HTML to PDF ¶

Compose ¶

Parse JSON ¶

Get file content ¶

Convert DOCX to PDF ¶

Merge PDF ¶

Create file ¶

Conclusion ¶