How can I save a Microsoft Form response with questions?

%3CLINGO-SUB%20id%3D%22lingo-sub-145463%22%20slang%3D%22en-US%22%3EHow%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145463%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BHi%2C%3C%2FP%3E%0A%3CP%3EI%20would%20like%20to%20save%20all%20responses%20to%20a%20form%20I%20have%20created%20as%20individual%20files%20but%20also%20include%20the%20questions.%20I%20have%20had%20a%20play%20with%20flow%20but%20cannot%20get%20the%20flow%20to%20save%20the%20questions%20along%20with%20the%20response%2C%20is%20there%20a%20way%20to%20do%20this%3F%3C%2FP%3E%0A%3CP%3EMany%20thanks%20for%20any%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-145463%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271664%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271664%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20this%20same%20problem.%3C%2FP%3E%3CP%3EMy%20current%20solution%20is%20creating%20a%20flow%20to%20export%20responses%20and%20send%20an%20email%20when%20the%20response%20is%20submitted.%20The%20email%20includes%20questions%20and%20answers.%20You%20wouldn't%20need%20the%20part%20where%20it%20creates%20an%20item%20on%20sharepoint.%20It%20could%20be%20just%20get%20response%20details%2C%20send%20an%20email.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%20how%20I%20could%20get%20the%20response%20details%20and%20then%20send%20an%20email%20with%20the%20answers%20as%20an%20attachment%20-%20but%20this%20way%20works%20for%20the%20time%20being.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56474iAA64004FE9433560%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Flow02.JPG%22%20title%3D%22Flow02.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269491%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269491%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20less%20surprised%20at%20the%20lack%20of%20individual%20response%20links%2C%20given%20that%20Forms%20is%20Excel-backed%3B%20all%20the%20Forms%20Response%20sheet%20does%20is%20read%20through%20rows.%20An%20item%20is%20fundamentally%20different%2C%20as%20it's%20a%20unique%20web%20object%20and%20it's%20part%20of%20a%20true%20database%20where%20Excel%20is%20not%20a%20database.%20If%20Forms%20were%20backed%20by%20a%20List%2C%20we'd%20be%20having%20a%20different%20conversation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-269452%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-269452%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20searching%20the%20internet%20trying%20to%20find%20a%20way%20to%20link-to%20or%20output%20a%20form%20response%2C%20in%20its%20totality%2C%20with%20questions%20and%20answers%20both...%20and%20was%20very%20disappointed%20to%20find%20that%20this%20is%20not%20possible.%20I%20agree%20that%20this%20is%20a%20basic%20function%20that%20seems%20like%20it%20should%20be%20a%20default%20option.%20In%20Sharepoint%2C%20every%20single%20item%20seems%20to%20be%20able%20to%20be%20individually%20linked%20to...%20the%20fact%20that%20I%20cannot%20link%20to%20an%20individual%20form%20response%20makes%20it%20so%20that%20running%20an%20approval%20flow%20on%20a%20form%20requires%20mocking%20up%20the%20entirety%20of%20the%20form%20in%20the%20email...%20it%20is%20inelegant%20to%20say%20the%20least%20and%20it%20should%20be%20built%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145967%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145967%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20should%20definitely%20do%20this--how%20Forms%20was%20intended%20to%20serve%20Educational%20tiers%20first%20is%20beyond%20me%20without%20something%20like%20that--but%20in%20the%20meantime%20(unless%20I%20missed%20something)%2C%20I%20think%20using%20exported%20responses%20in%20Excel%20and%20using%20Mail%20Merge%26nbsp%3Bto%20get%20a%20document%20mimicking%20the%20individual%20q%2Fa%20sheet%20is%20the%20best%20option%20you%20have.%20It's%20not%20automated%20per%20se%2C%20but%20it's%20way%20better%20than%20creating%20individual%20PDFs.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E*Edit%2C%20unless%20I'm%20mistaken%2C%20Mail%20Merge%20will%20let%20you%20save%20directly%20to%20PDFs.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145863%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145863%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Matt%2C%3C%2FP%3E%0A%3CP%3EMany%20thanks%20for%20your%20help.%20In%20our%20particular%20usage%2C%20a%20Form%20is%20completed%20and%20the%20completed%20form%20%2B%20questions%20is%20stored%20on%20file%20for%20each%20user.%20Yes%20can%20print%20to%20pdf%2C%20save%20and%20then%20delete%20the%20response%20in%20the%20Form%20however%2C%20would%20like%20to%20'automate'%20the%20process%20and%20wondered%20if%20Flow%20could%20save%20a%20copy%20of%20a%20completed%20form%20with%20questions%20and%20responses.%20Like%20you%2C%20I%20could%20not%20find%20anything%20obvious%20when%20'playing'%20with%20Flow.%3C%2FP%3E%0A%3CP%3EHas%20anyone%20do%20something%20similar%20to%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMany%20thanks%2C%3C%2FP%3E%0A%3CP%3EJames%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145565%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145565%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20print%20a%20Form%20submission%2C%20questions%20and%20answers%20both%2C%20as%20a%20PDF%20through%20the%20Form%20application's%20%22View%20Results%22%20interface.%20I%20didn't%26nbsp%3Bsee%20any%20obvious%20print%20to%20PDF%20solutions%20available%20through%20Flow%20for%20Forms%2C%20but%20I%20didn't%20look%20for%20very%20long.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20856px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F26916iE659661B4458E59F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302664%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20save%20a%20Microsoft%20Form%20response%20with%20questions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F226083%22%20target%3D%22_blank%22%3E%40Justin%20Jones%3C%2FA%3E%26nbsp%3Bwondering%20if%20you%20were%20ever%20able%20to%20resolve%20this.%26nbsp%3B%20I%20have%20a%20possible%20solution%20and%20was%20able%20to%20inspect%20the%20API%20request%20during%20design%20time%20that%20gets%20the%20questions%20text%20and%20ID's.%26nbsp%3B%20I%20just%20cant%20figure%20out%20how%20to%20get%20the%20access%20token%20as%20it%20won't%20accept%20the%20regular%20forms%20token.%26nbsp%3B%20The%20API%20call%20looks%20like%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Funitedstates-002.azure-apim.net%2Fapim%2Fmicrosoftforms%2Fshared-microsoftform-2a320dd7-95e4-49fa-9b04-xxxxxxxxxxxx%2Fformapi%2Fapi%2Fforms('C2Ne8s9q10S99jGRDpOSIvRDUOlUkrJPoRkySrUTZ7lUMUNGM1NVVU1IWEJNUkUyWjgzxxxxxxxxxx')%2Fquestions%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Funitedstates-002.azure-apim.net%2Fapim%2Fmicrosoftforms%2Fshared-microsoftform-2a320dd7-95e4-49fa-9b04-xxxxxxxxxxxx%2Fformapi%2Fapi%2Fforms('C2Ne8s9q10S99jGRDpOSIvRDUOlUkrJPoRkySrUTZ7lUMUNGM1NVVU1IWEJNUkUyWjgzxxxxxxxxxx')%2Fquestions%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

 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

7 Replies
Highlighted

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.

 

Capture.PNG

Highlighted

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

 

 

Highlighted

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.

Highlighted

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.

Highlighted

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.

Highlighted

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.

 

Flow02.JPG

 

Highlighted

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