Forum Discussion
How can I save a Microsoft Form response with questions?
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.
I was searching the internet trying to find a way to link-to or output a form response, in its totality, with questions and answers both... and was very disappointed to find that this is not possible. I agree that this is a basic function that seems like it should be a default option. In Sharepoint, every single item seems to be able to be individually linked to... the fact that I cannot link to an individual form response makes it so that running an approval flow on a form requires mocking up the entirety of the form in the email... it is inelegant to say the least and it should be built in.
