Power Platform Community Forum Thread Details

Hey all I work for a construction and power washing company and created a form to capture the site conditions and customer needs at a site. I need to come up with a way to make each form results to look better when they are presented (there are about 40 questions total and when you print the responses page it spreads across 10 pages vs i can condense all of the information into 2 with excell)...

With the form results ending up being 10 pages printed I decided i needed to create a flow to condense the form response in a much prettier and more easy to read way VS just one giant row with 40 columns....

Pictured below.. so for instance it would go and pull the customer name and plug it in, address, space count ect. ect.

Event 201 posted November 4 2019.jpg site visit report.jpg

I thought it would be simple to pull the data from the responses and plug specific answers into specific cells within my form

However my new template, the easy to read report that I would like to send vs a row of 40 things... isnt a table so when i select the upgrade row, i dont have a table to reference?

Any help in this is REALLY appreciated...

I may also not be doing this in the right way either.. but it seems like you should easily be able to get responses from form and plug into specific cells within a document...

Thanks!

Categories:

Using connectors

Hi @Anonymous,

If it is an Excel document, there is no way could append data extract form MS Form. But according to your describe, I think Populate a word template action will suit it, you could create a template word document in just like the Excel document, then extract these data into the word template, I hope it can help you:

https://www.bythedevs.com/post/how-to-populate-word-template-with-rich-text-image-repeating-content-control-using-ms-flow

https://powerusers.microsoft.com/t5/Building-Flows/Word-Online-Business-Connector-Populate-a-Microsoft-Word/td-p/206836

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.