Create Dynamic Word Document with Power Automate & Microsoft Forms

Learn how to create dynamic Word documents using Power Automate and Microsoft Forms. In this video, I will demonstrate a solution that utilizes Microsoft Form branching and variable data. I will make it easy for you to repurpose Form data into an array that can be filtered upon. With this solution you can create documents with optional sections, either as a plain text control or using repeating controls in Word. Even if you're not interested in this specific solution, make sure to watch the video to understand how to better utilise Microsoft Form data in future projects.

00:00 Intro
01:34 Microsoft Form Overview
02:25 SharePoint List Overview
03:32 Flow Overview
03:55 Word Document Plain Text Controls
05:55 Building the flow
06:50 How to repurpose Microsoft Form Data
17:07 Filtering for required sections
24:40 Repurposing array data for Word
36:29 Repeating control Array
40:00 Populate and test the Flow
43:02 Outtro

[stevenhampson]

Appreciate all the detail in the video, and highlighting out the exact content. Also great that you showed where a potential issue was with the first solution and then demonstrated a more robust solution. Thanks Damian. I could watch you go into selects and filters all day and still be learning!

[ricardobunge]

Excellent! Thorough explanation, great techniques, and very streamlined. Another brilliant contribution - thanks Damien!

[davidadams]

"The exciting Word part...", you do make me laugh! Another outstanding video. I do get the sense that we're all benefitting from a lot of troubleshooting you had to do behind the scenes! Your mastery of data manipulation is inspiring. Very well done.

[vigotov]

Amazing thank you for your hard work it's very professional

[gitaiganor]

Wow this was a great great Video, thank you. Very deep and clear explanation.

[CINsyg]

Really great video, love your use of select instead of apply to all

[NatalieBarker-sx]

Thanks for this video! It's great and super helpful!

I'm a bit lost on how I create the 'list' document with sections and the pipes in it. I don't understand how to create this list, what is the obvious thing that I'm missing?

[matthieufff]

This is brillant !!!! Working like a charm :)
My question is: Can you add section with specific format? For example I would like section titles to be in bigger police and in blue

[LewisButlera]

Great video, one issue I'm having is I can't seem to get it to work with pictures, if someone uploads a picture to a form do you know if there's some way to transfer it to the word doc as well? There is a photo option but it's having issues carrying it across from the form.

[heatherchambers]

Great tutorial - thanks! What would you recommend instead of a Form for capturing user input for more than 200 items?

[richardhedley]

Watching some of your videos and very interesting ways presented and very detailed, basically great.

Question please, is this scenario doable?

Storing an MS Word doc (template) as .xml, then PA time. Format JSON(XML()) then parse, get w:document and then manipulate !values! and even more add items in the array (more letters as in merging idea as well), with new items a number sequence for more items. Once manipulated, add the new w:document content within the right section of the collected xml. Then, create a new document with the new content.

[lwdotue]

how do i create a sharepoint list following format of what has been done here, i have found this tutorial super helpful but am stuck on where i need my list to input to power automate and am not sure how i set this up

[Esmithy]

Great video very helpful
Can you make one that shows have to have the yes or no check boxes responses generated on a word template?

[joanconnelly]

Brilliant! Thank you so much, this is very helpful. I am wondering if you can help me think of a way to add dynamic images w/o having the control show a box on the printout? We have several departments entering form data (each dept has a separate form) and sometimes they need to upload an image. We create a list for all of the input from the form, including any attachments they may have uploaded. Do you know of a way we can eliminate the control if there is no image?

[joanconnelly]

Thank you so much Damien, I was able to use this technique to create a word template with over 180 questions and answers from different sources (forms to list) and the .docx is created in less than 30 seconds. My only issue is that I now exceed the 500-limit license for actions. Do you have any advice on where I can compromise performance for functionality? Again, thank you so much for sharing your knowledge. You are greatly appreciated!

[smoola]

Excellent Would appreciate a Power app vesion

[gqdezsc]

Damian - I've learned some valuable information from you! Thanks. How would I end the power automate and send the file created to the "Responsible Person" email address I have in my dynamic tags? With that I have a great solution thanks to you.😎

My flow called "Notify me if Damien mention "repurpose" more than 10 times in his new YT 📺video to like and comment it" has been triggered. 👍

[chriscambra]

Can you substitute a checkmark or "X" in place of a choice from a Microsoft Form. For example, I'm trying to autofill a form like using your example but if a user selects a choice it comes out as an "X" or checkmark on the form I pre-created/

[freshrain]

Hi there, excellent video. I learned a lot. A quick question for you. I created an online form to gather responses and uploads(images). I then took that to SharePoint where I had a word document used as atemplate that is creating files. How do I take the images from forms and add them directly to the new word document?