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!
Here's how you would start off:
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.
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.
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).
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.
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.
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1