Unanswered

Form details put into an existing excel document

(0) Share

Report

Posted on by AB21

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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-litu-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Naz 58 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AB21 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Naz 58 on at

Like (0)

Report

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.

Was this reply helpful? Yes No