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

Read the blog post about this flow!
Pivot Explorer icon
For data analysis and visualization in SharePoint, we recommend the kalmstrom.com SharePoint add-in Pivot Explorer.

Learn more


Always the latest news in the kalmstrom.com blog

Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!

back icon next icon