Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Q2gPpKYTvoaHkvZvz9K+3K
Power Automate - Building Flows
Unanswered

Form details put into an existing excel document

Like (0) ShareShare
ReportReport
Posted on 7 Nov 2019 11:09:01 by

Is it possible to have the feedback from a form be sent into specific cells in an existing excel spreadsheet

 

So for example a user completes an Assessment gets 13/20 and then inputs the score into the form.

 

We have an excel mark book where we store all their assessment data. At the moment I have to cut and paste from one excel document to another - Is it possible to automate this process. If there are key fields or an identifier like their email address which could be used to cross reference between the inputs in different forms cells and transpose that into my excel document.

 

Help! 

  • Naz Profile Picture
    58 on 11 Nov 2019 at 00:32:14
    Re: Form details put into an existing excel document

    Here's how you would start off:image.png

     

    You would then use Add Row to populate your table.

     

    You could filter the table by the user name and add the details, but that would be slightly more complicated.

  • AB21 Profile Picture
    on 08 Nov 2019 at 08:48:42
    Re: Form details put into an existing excel document

    Hi, 

     

    Sorry I'm a novice at using Flow so this is kind of hard to understand, any chance you can show me what you mean by this!

     

    Thanks in advance.

  • AB21 Profile Picture
    on 08 Nov 2019 at 08:39:58
    Re: Form details put into an existing excel document

    Can you show me an example on flow please? 

     

    Also the form will contain there name which if possible link some how to there name on the existing excel document - like a function (if there is one) that says if the name is ie Joe Bloggs (on form) put score (which is also inputted on form)  next to Joe Bloggs (on existing spreadsheet). 

     

     

  • Naz Profile Picture
    58 on 08 Nov 2019 at 05:04:27
    Re: Form details put into an existing excel document

    That should be easy assuming your destination Excel sheet has the data stored in a table.

     

    Here's one way you can do it:

    Use "When a new response is submitted" connector for Flow.

    Then an "Apply to each"

    A "Get Response Details" Flow connector within the "Apply to each".

    Followed by the Excel "Add Row" connector. And then just fill in the form responses next to the fields in the Connector.

     

    Hope that helps.

     

  • v-litu-msft Profile Picture
    on 08 Nov 2019 at 02:19:27
    Re: Form details put into an existing excel document

    Hi @AB21,

     

    If you can convert the score into string format, you can input it into excel file.

     

    It is possible to cut and paste from one excel document to another, you can use the Copy file action to achieve it.

    If you want to store these responses of the form into an individual excel file, you can after store them into the excel file, copy it to another folder with a new name, after copy, empty the previous excel file for the next user to store and copy. BUT, this method could not multiple user input their response at the same time, the data will be confused if multiple user input. 

     

    I hope something could help.

     

    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard