top of page

How To Record Microsoft Form Responses In SharePoint Using Microsoft Flow

Writer's picture: Vijai Anand RamalingamVijai Anand Ramalingam

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.

0 comments

Recent Posts

See All

Comentarios


bottom of page