cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Trying to get information from FORMS into an Excel Document

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.jpgsite 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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Trying to get information from FORMS into an Excel Document

Hi @lrwebber,

 

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-...

 

https://powerusers.microsoft.com/t5/Building-Flows/Word-Online-Business-Connector-Populate-a-Microso...

 

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.

 

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Trying to get information from FORMS into an Excel Document

Hi @lrwebber,

 

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-...

 

https://powerusers.microsoft.com/t5/Building-Flows/Word-Online-Business-Connector-Populate-a-Microso...

 

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.

 

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (10,836)