Home >Tips >SharePoint Flows >From Forms to SharePoint kalmstrom.com site map icon Site map  

Get Survey Responses from Forms to SharePoint

A SharePoint Flows tutorial by Peter Kalmström

Flow iconIt is often efficient to work with data from other platforms in SharePoint, to be able to share it within a team and to work with it in various ways. In this article we show a flow that fetches responses from a Microsoft Forms survey and adds it to two different SharePoint lists.

The same process can be used for many other purposes, where you need to get data from another online platform into SharePoint.

In the demos below Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, first shows how to create a Forms survey. One of the questions is "Do you want to receive a newsletter?"

In the second demo he describes how to create the actual flow that adds the responses to SharePoint.

Peter has created two SharePoint apps for the responses: a Leads list and a Newsletter list. All responses except the one about newsletter are sent to the Leads list. The answers to the question about receiving a newsletter are sent to the Newsletter list to be handled separately. This list only contains the name and e-mail address of each responder that has answered Yes to the question.

Flow that gets responses from Forms

For this flow to work as described below, you should log in with the same account when you create the flow as when you created the survey.
  1. Create the flow from blank use the trigger 'Microsoft Forms - when a new response is submitted'.
  2. Select the survey form.
  3. Add the action 'Forms - get response details' and select the survey form again.
  4. Add the dynamic content Response Id.
  5. Add the action SharePoint, create item and select the Leads list and site.
  6. In the title field, add some general text and the dynamic content Name.
  7. In the description field, add dynamic content for responses to all survey questions except Do you want to receive a newsletter. Also add suitable text before the dynamic content, so that you recognize which question each response belongs to.
  8. Add a condition: if the dynamic content Do you want to receive a newsletter equals Yes.
  9. If the condition is true, add the action SharePoint, create item for the Newsletter list.
  10. Add the dynamic content Name at Title and the dynamic content Email at Email address.

Pivot Explorer iconFor data analysis and visualization in SharePoint, we recommend the kalmstrom.com SharePoint add-in Pivot Explorer.

Follow kalmstrom.com on LinkedInFacebook or Twitter!

back icon next icon

Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved