Unanswered

Converting Microsoft Form response to Word Doc

(0) Share

Report

Posted on by mhills91

Hello everyone!

I'm trying to convert the output of a form into a word document. I have followed this process, but I only get html output and need the output to ordered down the document, not just as headers, as this will be signed off by Project Managers.

Step 2.png Step 1.png

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

v-yamao-msft on at

Like (0)

Report

Hi @mhills91,

It seems that you are trying to create a Word document with the response details of Microsoft Forms.

I have made the following flow for your reference.

It is triggered by When a new response is submitted.

Within the Apply to each, get response details from the form, then create HTML table with custom columns.

In the Create file action, select the output of Create HTML table for the File content field.

A screenshot for your reference.

Please feel free reply if you need more help.

Best regards,

Mabel

Was this reply helpful? Yes No
mhills91 28 on at

Like (0)

Report

Hi @v-yamao-msft,
Unfortunatley an HTML output does not help me in this instance. The output I currently have is in the layout I need for the form.
Is it possible to go from the HTML table to a word document that retains the layout I need?

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi @mhills91,

Thanks for updating.

I am afraid that it might be not possible to retain certain layout from the HTML table to a word document.

You may consider submitting a request on Flow Ideas Forum on this issue:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Mabel

Was this reply helpful? Yes No
Verified answer

mhills91 28 on at

Like (0)

Report

My answer was found by adding .doc at the end of create file.

Was this reply helpful? Yes No
anton-khrit 197 on at

Like (0)

Report

Hi!

Please read this article. It describes how to generate DOCX from Microsoft Forms submission and then convert it to PDF.

Was this reply helpful? Yes No
cadone 280 on at

Like (0)

Report

All,
Filling out a Word Form is premium $$. Costs a superior Flow Plan.
Instead, is it possible to fill out a form in .xlsx format using the responses from a MS form?

Now, I know all the responses can be viewed in an excel file. Instead, I am looking for a form template in excel format I have stored in one drive. I want a "Flow" that can fill out that excel template & save it as "responseid.xlsx"

Possible?
Any help with this would be greatly appreciated.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

A very an easy and effective solution is documented at https://kamdaryash.wordpress.com/2020/04/27/power-automate-solution-to-convert-microsoft-forms-to-word/

Was this reply helpful? Yes No
wrightcomply 44 on at

Like (0)

Report

Plumsail only works in Europe. The US is not available yet.

Was this reply helpful? Yes No
acox 95 on at

Like (0)

Report

Hi @cadone,

You can use the Plumsail Documents connector to do that. They have an article on their website on how to set up a flow to fill out an Excel template from Microsoft Forms responses:
How to create Excel and PDF documents from Microsoft Forms in Power Automate and Azure Logic Apps — Plumsail Documents Documentation

Now, I know you'd still have to pay for that, but it's totally worth it IMO. Really simple to set up. You can try it out for free too.

Was this reply helpful? Yes No