@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.
Hi!
As this might be a problem people still run into (changing a forms so that older data is deleted)
I have at least found one way to access them and since it was not in any answer of this query i thought i might add it.
The responses that appears "deleted" when you open them in excel is still availible. Instead of open the responses in excel, click on "view result"
In the drop down list, you can choose each respondent and you will be able to see all the responses.
This is not the most convenient or effective way to access the data but at least it gets the job done 🙂
Hope this is helpful to someone!