How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow

Introduction

In this article, you will see how to record Microsoft Form responses in SharePoint using Microsoft Flow. Microsoft Forms allows the users to:
  • Easily create surveys, quizzes, and polls;
  • Analyze the responses or results using built-in analytics;
  • Access the form or quiz via browser or in mobile;
  • Export the form data to Excel for additional analysis.

In the previous article, we saw how to create a form in Microsoft Forms. I have created a sample form, as shown in the below screenshot.

How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow 

I have created a custom list in SharePoint.

  • Select Training Topics – Single line of text
  • Select Training Mode – Single line of text
  • Comments – Multiline of text
  • Responder – People or group

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow

Create and test the flow

  1. Navigate to flow site here.
  2. In the top navigation, click My flows.
  3. Click "Create from a template".
  4. Type form in the search box and then click search. Select Record form responses in SharePoint.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. Enter the credentials and connect to Microsoft Forms and SharePoint connectors. Click "Continue".

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. When a new response is submitted, trigger - Select the form Id from the drop-down list.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. In the "Get response details" action, select the form Id from the drop-down list.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. Create item action: Select the site address, list name, and add dynamic contents as shown in the below screenshot.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. Click Save, once the changes are completed.
  2. Click Test to test the workflow.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. Navigate to form and submit the response.
  2. Flow ran successfully as shown in the below screenshot.

    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow
  1. A new item created in SharePoint list as shown in the below screenshot.
     
    How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow

Summary

Thus in this article, you saw how to record form responses in SharePoint using Microsoft Flow.


Similar Articles