Forum Discussion
Josette Moore
Jan 09, 2018Brass Contributor
Recover responses from deleted Form questions
Hello world,
I'm desperately trying to find a solution for recovering responses to questions that were deleted from a MS form. The form still exists but it recently (Jan.7th) went through a ma...
Martin Curtis
Copper Contributor
Matt Coats do you know if there is a walk through to show how to do this? I am keen to use forms in school but one has been deleted by accident, with quite a few responses, and therefore people are questioning the reliability. I am just a teacher, learning as I go, so flow is something I have never used before. Thanks, Martin
Matt Coats
Apr 17, 2018Steel Contributor
Martin Curtis I don't have or know of a distributed guide, but I can do my best to describe what you'll need to do.
- You'll need to ensure that you have the ability to create a SharePoint List somewhere as well as the rights to access Microsoft Flow (if you can't see the Flow app in your app launcher, ask your IT department for rights).
- Create your Form; once it's finalized, you can move on to the next step.
- Create a SharePoint List and create a field in your List for every question you have in your Form, and make sure the default Title field is no longer required (otherwise none of your submissions will pass, or you could try to find another use for it). Match data types if you're able, but for the most part you'll probably end up with Single Line of Text or Multiple Lines of Text. *I have not tried to match a Likert question in a List before, so if you're using those, you'll have to experiment.
- Create a Flow that has a Forms "When a new response is submitted" trigger, add an "Apply to Each," add a Forms "Get Response Details" step with your Form ID and Response ID, add a SharePoint "Create Item" step that points to your site and list, and at this point you should be able to start mapping over your Forms questions to the appropriate List field you've prepared. My working Flow below demonstrates in full what the complete Flow should look like.
I hope this accomplishes your use case, Martin! Things to keep in mind, you may need to save your Flow and refresh Microsoft Flow a time or two as you're setting this Flow up, sometimes I get scenarios where Flow doesn't recognize my Forms questions but it always resolves itself with a refresh or two.