How to save Microsoft Form’s(Group Form) response in a SharePoint List

Featured image

When we create surveys, polls, and quizzes out of Microsoft Forms, we understand the responses being generated can be exported in the form of an excel. But, it is refrained to its own format.

Have you ever wondered if we could feed a Form’s response into a SharePoint List. Yes, we can do it with the help of the Power Automate Flows.

You need to perform the steps below to get this automated.

Let’s see in detail how to achieve it.

Form listed under the Group ‘Leadership’

The Group Form used in this use case

Step 1 : Create a SharePoint list

Create a SharePoint list to store the response details. In the below screenshot, we see the list ‘EmployeeFeedbackResponses’, created in the SharePoint site ‘Human Resources’.

Step 2 : Create a Power Automate flow

Create an automated Power Automate flow which would be triggered ‘When a new response is submitted’.

Step 3 : Choose the form

Choose the form whose response has to be stored in a template.

If your form is not listed, pick the Form ID as highlighted below. Choose ‘Enter custom value’ and enter the Form ID.

Step 4 : Add a step ‘Get response details’

Add an action ‘Get response details’, to pull the response ID of the response submitted. Add Form ID as mentioned in the previous step.

Step 5 : Add a step ‘SharePoint-Create item’

Add a step with SharePoint Action ‘Create item’, to add an entry into the SharePoint List, when a response is submitted.

Select the SharePoint Site and List to which the response has to be stored.

Link the list item and response fields as shown below.

Step 7b(Optional) : Add the Responder’s Email / Submission time

Link the Responder’s Email / Submission time if needed as shown below.

Step 8 : Submit a response and check the SharePoint List

Note : In order to get the Responder’s Email from the response - In the Collect Response options, enable the attribute ‘Record name’ as depicted below.

Related link :