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

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

Step 1 – Create a New Flow

1. Go to Power Automate
2. Select Create > Automated cloud flow.
3. Name your flow appropriately—use a format of Campus-Department-Project-Process (e.g., “Upload UNH FinAid Request Form Responses to SharePoint”).
4. For the trigger, search and select: “When a new response is submitted” (Microsoft Forms).
5. Click Create.

Step 2 – Set Up Microsoft Forms Trigger

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.

Step 3 – Get Response Details

7. Click + New Step.
8. Search for “Get response details” and select the Microsoft Forms action.
9. Choose the same Form ID as above.
10. In Response ID, select Response ID from the dynamic content list.

Step 4 – Create an Item in SharePoint

11. Click + New Step.
12. Search for “Create item” (SharePoint).
13. Set:

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

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

Step 5 – Save and Test

15. Click Save in the top right corner.
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.

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:

• USNH M365 Learning Pathways: On-Demand Online Walk-throughs, Tutorials, & Guides for M365 Products
  https://universitysystemnh.sharepoint.com/sites/M365LP/
• SharePoint Success Site: Learn How to Plan, Build, Launch, Share, & Manage Your Sites
  https://universitysystemnh.sharepoint.com/sites/SharePointSuccessSite/

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.