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.
Create the flow from blank use the trigger 'Microsoft
Forms - when a new response is submitted'.
Select the survey form.
Add the action 'Forms - get response details' and
select the survey form again.
Add the dynamic content ‘Response Id’.
Add the action ‘SharePoint – create item’ and select
the “Leads” list and site.
In the title field, add some general text and the
dynamic content ‘Name’.
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.
Add a condition: if the dynamic content ‘Do you
want to receive a newsletter?’ equals ‘Yes’.
If the condition is true, add the action ‘SharePoint
– create item’ for the Newsletter list.
Add the dynamic content ‘Name’ at ‘Title’ and the
dynamic content ‘Email” at ‘Email address’.
blog post about this flow!
For data analysis and visualization in SharePoint, we recommend
the kalmstrom.com SharePoint add-in