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:

  1. Easily create surveys, quizzes, and polls;

  2. Analyze the responses or results using built-in analytics;

  3. Access the form or quiz via browser or in mobile;

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





































I have created a custom list in SharePoint.

  1. Select Training Topics – Single line of text

  2. Select Training Mode – Single line of text

  3. Comments – Multiline of text

  4. Responder – People or group





Create and test the flow

  • Navigate to flow site here.

  • In the top navigation, click My flows.

  • Click "Create from a template".Type form in the search box and then click search. Select Record form responses in SharePoint.





















  • Enter the credentials and connect to Microsoft Forms and SharePoint connectors. Click "Continue".

















  • When a new response is submitted, trigger - Select the form Id from the drop-down list.




  • In the "Get response details" action, select the form Id from the drop-down list.








  • Create item action: Select the site address, list name, and add dynamic contents as shown in the below screenshot.













  • Click Save, once the changes are completed.

  • Click Test to test the workflow.













  • Navigate to form and submit the response.Flow ran successfully as shown in the below screenshot.











  • A new item created in SharePoint list as shown in the below screenshot.





Summary

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

Recent Posts

See All