It
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.
Flow that gets responses from Forms
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.
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.
NOTE: Microsoft has made some changes to Power Automate
since this demo was recorded, so now we recommend that you
don't start with a blank flow, as Peter does in the demo.
Instead, start with a tempalte and select the Forms template
“Record form responses in SharePoint”.
Apart from that, the idea in Peter's demo is the same.
For
data analysis and visualization in SharePoint, we recommend
the kalmstrom.com SharePoint add-in
Pivot Explorer.
It
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. 
