Forum Discussion
How can I save a Microsoft Form response with questions?
Hi,
I would like to save all responses to a form I have created as individual files but also include the questions. I have had a play with flow but cannot get the flow to save the questions along with the response, is there a way to do this?
Many thanks for any help
10 Replies
- I agree there should be a simple way within Forms to do this but I've not been able to find one. What I do is export the response to Excel, create a second spreadsheet, and then copy the data in the questions row of the Forms response spreadsheet into a column in the new spreadsheet (using the transpose option of paste special) and copy the data in the responses row into another column in the new spreadsheet via transpose. Then I save the new spreadsheet as a PDF.
You can print a Form submission, questions and answers both, as a PDF through the Form application's "View Results" interface. I didn't see any obvious print to PDF solutions available through Flow for Forms, but I didn't look for very long.
Hi Matt Coats
If I have 100 responses, how can I save all the form response with questions in one shot? Or do I save them one by one? I can't seem to find that option. Thanks in advance.
Mimi_Mohamed There is an excel sheet you can download with all the questions and answers. You could create a mail merge for a word doc if you need individual files.
Hi Matt,
Many thanks for your help. In our particular usage, a Form is completed and the completed form + questions is stored on file for each user. Yes can print to pdf, save and then delete the response in the Form however, would like to 'automate' the process and wondered if Flow could save a copy of a completed form with questions and responses. Like you, I could not find anything obvious when 'playing' with Flow.
Has anyone do something similar to this?
Many thanks,
James
Microsoft should definitely do this--how Forms was intended to serve Educational tiers first is beyond me without something like that--but in the meantime (unless I missed something), I think using exported responses in Excel and using Mail Merge to get a document mimicking the individual q/a sheet is the best option you have. It's not automated per se, but it's way better than creating individual PDFs.
*Edit, unless I'm mistaken, Mail Merge will let you save directly to PDFs.
