How To Save Input From MS Forms Form Into SharePoint List

This article will discuss how we can save responses from MS Forms to SharePoint using power automated flow. Storing MS Form data in SharePoint lists provides a centralized location for data storage.

All the data collected through MS Forms are stored in a single location, making it easier to manage, analyze and access the data.

Integration with other Microsoft products: SharePoint lists can be easily integrated with other Microsoft products such as Excel, Power BI, and Teams. This integration allows for more advanced data analysis and visualization.

So, let's discuss step by step,

Create a Microsoft form on https://forms.office.com/

Here I have created a customer details form.

How to save input from MS Forms form into SharePoint list

Similarly, you need to create a SharePoint list to store the responses from the customer.

How to save input from MS Forms form into SharePoint list
How to save input from MS Forms form into SharePoint list

Power Automate Flow for collecting and Storing Responses

When a new response is submitted

Create a flow with a trigger when a new response is submitted, and select the form you want to store data in the list. When a new response is submitted" is a trigger in Microsoft Power Automate that starts a flow when a new response is submitted to a Microsoft Forms form. This trigger allows you to automate actions based on form submissions.

How to save input from MS Forms form into SharePoint list

Get Response details

With this action, you can use the response data to send mail or perform other actions using the ID.

How to save input from MS Forms form into SharePoint list

You need a Response Id to get the response,

How to save input from MS Forms form into SharePoint list

Create Item

Create a new item for the responses in the list you created and update the list according to the field.

How to save input from MS Forms form into SharePoint list

Save the flow and test it by submitting a new response. If your flow runs successfully, you can see the response stored in the list as an example below.

How to save input from MS Forms form into SharePoint list

Conclusion

So in this article, we learned how to store the data in a SharePoint list using the power automate flow.


Similar Articles