Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Trying to get information from FORMS into an Excel Document

(0) ShareShare
ReportReport
Posted on by

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!

  • Verified answer
    v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Trying to get information from FORMS into an Excel Document

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics