Jan 16 2018 06:23 AM
Jan 16 2018 06:23 AM
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
Jan 16 2018 09:52 AM
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.
Jan 17 2018 03:22 AM
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?
Jan 17 2018 08:08 AM - edited Jan 17 2018 08:14 AM
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.
Oct 10 2018 10:18 AM
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.
Oct 10 2018 11:03 AM
I'm less surprised at the lack of individual response links, given that Forms is Excel-backed; all the Forms Response sheet does is read through rows. An item is fundamentally different, as it's a unique web object and it's part of a true database where Excel is not a database. If Forms were backed by a List, we'd be having a different conversation.
Oct 15 2018 11:40 AM
I am having this same problem.
My current solution is creating a flow to export responses and send an email when the response is submitted. The email includes questions and answers. You wouldn't need the part where it creates an item on sharepoint. It could be just get response details, send an email.
I'm trying to figure out how I could get the response details and then send an email with the answers as an attachment - but this way works for the time being.
Apr 13 2020 07:18 AM
@Justin Jones wondering if you were ever able to resolve this. I have a possible solution and was able to inspect the API request during design time that gets the questions text and ID's. I just cant figure out how to get the access token as it won't accept the regular forms token. The API call looks like this https://unitedstates-002.azure-apim.net/apim/microsoftforms/shared-microsoftform-2a320dd7-95e4-49fa-...
Apr 21 2021 07:31 AM
Apr 23 2021 05:48 PM
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.
Feb 20 2022 02:50 PM
@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.