In this guide you’ll learn how to convert Microsoft Forms to a Word document using a Power Automate.
Steps to convert your Microsoft Forms to Word using Power Automate:
- Create a flow in Power Automate
- Define your action (Convert to Word)
- Create File (define were your file will be created)
- Publish your workflow
Microsoft Forms provides a quick and easy way to create surveys and questionnaires to collect responses from different people. Even though this is useful, the completed Forms are not easily portable i.e.you cannot send this from one person to another person keeping the “Look and Feel” of the completed Form intact along with any files that have been uploaded to it.
Using Power Automate (Flow) and The Muhimbi PDF Converter, you can merge all the attachments into a single MS Word document along with the responses and then send that document as an email or write the generated PDF to SharePoint, OneDrive, or anywhere you can send files to using Microsoft Power Automate.
Before we start building the workflow, ensure all prerequisites are in place. You should also have some knowledge of MS Forms and also knowledge of building Workflows using Power Automate.
Make sure you have installed the full or trial subscription for the Muhimbi PDF Converter for Power Automate.
Naturally, in Microsoft O365, permission to use Power Automate needs to be available to the user as well.
You will need to have the appropriate privileges to create Flows.
Let us consider an example of using Power Automate and Muhimbi PDF Converter to convert MS Forms with responses and attachments to MS Word documents and to store them in MS SharePoint or send them to a location supported by Power Automate.
Here is a sample MS Form that will be used to show how to convert Microsoft Forms to Word using Power Automate:
Using Power Automate to Convert Forms with Attachment to MS Word
We can now start building our Flow. From a high-level, our Flow looks as follows:
As a first step, you can add the ‘When a new response is Submitted’ trigger action specifying the ‘Form Id’ of the Microsoft Form. It will trigger the Flow when a new response is submitted.
Next, you can add ‘Get Response Details’ action specifying the ‘Form Id’ and the ‘Response Id’ of the Microsoft Form. It will trigger the Flow when a new response is submitted.
As a next step we will add the ‘Compose’ action. You can copy the HTML code fragment provided below into the ‘Inputs’ area of the Compose Action and then insert the various list fields in the appropriate places, just between each line’s <td\</td\elements. Your completed code should look like what you see in the screenshot.
Next, add the Muhimbi ‘Convert document’ action to the Flow Canvas and for the ‘Source File Name’,include a proper name with ‘.html‘ as an extension. For the ‘Source File Content‘, choose ‘Outputs‘. Choose ‘Output format‘ as ‘DOCX‘ from the drop down menu. Click Save to save the workflow.
Next, add the ‘Create File’ action to the Flow Canvas. For the ‘Site Address‘, choose the correct site address from the drop down menu. Select the correct ‘Folder Path‘ where the converted Word document file should be created. Give a meaningful ‘File Name‘ to the created Word document, but make sure you remember to add the extension ‘.docx‘ after the ‘File Name’ and to make the file name unique, or multiple runs of the flow will overwrite the same file.
. Click Save to save the workflow.