How to Connect Microsoft 365 Form Responses to a SharePoint List

Quick summary

This tutorial shows how to use Power Automate to automatically record Microsoft 365 form responses in a SharePoint list using a prebuilt template. Once configured, every new form submission triggers the flow and creates a corresponding list item in SharePoint instantly.

Steps

1. On the Power Automate main dashboard, go to the left-side panel and click Templates.
2. Browse the available options and select Record Form Responses in SharePoint.
3. Log into your Microsoft Forms and SharePoint account, then click Continue.
4. Tap When a New Response is Submitted to configure the trigger step.
5. Click the Form ID menu and choose the Microsoft 365 form you want to use.
6. Tap Get Response Details to set up the required parameters.
7. Open the Form ID menu again and select your preferred Microsoft 365 form.
8. Click Create Item to add the SharePoint action step.
9. Specify the SharePoint Site Address and List by selecting from their respective drop-down menus.
10. Click Save in the top menu bar to activate the connection between your Microsoft 365 form and SharePoint list.