Forum Discussion
James Gray
Jan 16, 2018Copper Contributor
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 ...
carriecloud
Apr 21, 2021Copper Contributor
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.