Power Automate: Automatically Upload Microsoft Form Responses to SharePoint List

Summary

This article provides step-by-step instructions for capturing responses from a Microsoft Form and saving them to a SharePoint Online list using Power Automate. This is ideal for scenarios like registrations, feedback forms, and internal requests where form submissions need to be retained in a structured SharePoint list.

See also:

MS Power Platform: USNH Usage Guidelines and Governance

USNH SharePoint Usage Guidelines and Governance


How-To

Task: Create a custom Power Automate flow to post Form responses into a SharePoint list.

Before You Begin

Make sure that

  • You have Edit access to the SharePoint site and list.
  • Your SharePoint list already exists, and has columns that match the fields in your Form.
  • You’re signed into Power Automate  ​

Important Notes

  • Anonymous Forms: SharePoint lists can only accept data from authenticated Microsoft Forms users unless special configuration (like Graph API) is implemented.
  • Permissions: Ensure the flow creator has appropriate access to both the form and the SharePoint list.

 

Instructions

Part 1 – Create a New Flow

Step 1 - Go to Power Automate  

Step 2 - Select Create > Automated cloud flow.

Step 3 - Name your flow appropriately—use a format of Campus-Department-Project-Process (e.g., “Upload UNH FinAid Request Form Responses to SharePoint”).

Step 4 - For the trigger, search and select: “When a new response is submitted” (Microsoft Forms).

Step 5 - Click Create.

 

Part 2 – Set Up Microsoft Forms Trigger

Step 6 - In the Form ID dropdown, select your form.

  • If it doesn’t appear, paste the full Form URL into a new browser tab and refresh Power Automate.

 

Part 3 – Get Response Details

Step 7 - Click + New Step.

Step 8 - Search for “Get response details” and select the Microsoft Forms action.

Step 9 - Choose the same Form ID as above.

Step 10 - In Response ID, select Response ID from the dynamic content list.

 

Part 4 – Create an Item in SharePoint

Step 11 - Click + New Step.

Step 12 - Search for “Create item” (SharePoint).

Step 13 - Set:

  • Site Address: Select your SharePoint site.
  • List Name: Select the list where the data should be stored.

Step 14 - For each SharePoint list column, click in the field and map it to the corresponding question response using dynamic content (e.g., “Your Name”, “Email”, etc.).

 

Part 5 – Save and Test

Step 15 - Click Save in the top right corner.

Step 16 - Test your form by submitting a new response and checking that the SharePoint list is updated.

 

Outcome

Each new form submission will be recorded as a new item in your selected SharePoint list, making it easier to manage and report on responses.

 

Further Readings

MS Power Platform: USNH Usage Guidelines and Governance

USNH SharePoint Usage Guidelines and Governance

 

Need additional help?

For assistance concerning site creation, content sharing, file synchronization, or other common SharePoint, OneDrive, Teams, or Office app activities, we recommend our Microsoft 365 Learning sites:

Learn more about the great tools our Microsoft 365 Learning sites offer!

Visit the Technology Help Desk Support page to locate your local campus contact information or to submit an online technology support request.  For password issues you must call or visit the Help Desk in person.  

Print Article