How to Connect Microsoft Forms to SharePoint Lists

Last Updated: October 28, 2026

Table of Contents

• What You Need Before You Connect Microsoft Forms to SharePoint
• Create the SharePoint List That Will Hold Your Form Data
• Build the Power Automate Microsoft Forms to SharePoint List Flow
  • Select the Form Submission Trigger
  • Retrieve Response Details and Map Questions to Columns
  • Add a New List Item and Test the Flow
• A Microsoft Forms to SharePoint List Flow Example You Can Copy
• Handling Microsoft Forms File Upload to SharePoint List Attachments
• How to Troubleshoot Power Automate SharePoint List Flow Failures
  • Check Run History and Error Messages
  • Fix the Most Common Connection and Mapping Errors
  • Prevent Duplicate List Items
  • Retry Safely After a Failure
  • Handle Missing Responses
• Permissions, Ownership, and Keeping the Flow Running Long Term
• Schedule a Walkthrough With Your Team
• Frequently Asked Questions

What You Need Before You Connect Microsoft Forms to SharePoint

Connecting Microsoft Forms to a SharePoint list is the process of routing each form submission into a structured list using a Power Automate cloud flow, so responses live in a sortable, reportable data source instead of a spreadsheet export.

Here is what you need before you start:

• A Microsoft 365 license that includes Forms and Power Automate (most business plans do)
• Edit or Contribute permission on the SharePoint site where the list will live
• A form you own, or permission to edit one
• A clear idea of which question maps to which column

The last item matters most. A common mistake is building the flow first and discovering mid-mapping that a question type does not fit the column you created. Plan the columns before you touch Power Automate.

More on why that matters later.

Create the SharePoint List That Will Hold Your Form Data

A SharePoint list is a structured collection of rows and columns stored on a SharePoint site, similar to a spreadsheet but with stronger data types, permissions, and views. Create the list before the flow, because the flow needs a destination to point at.

Start from the SharePoint site, select New > List, then Blank list. Name it something descriptive like "Equipment Requests" rather than "List 1."

Now add columns that match your form questions. Match the type carefully:

• Single line of text for short answers
• Multiple lines of text for long responses
• Choice for dropdown or radio questions
• Date and time for date pickers
• Number for numeric fields
• Person for questions collecting names or emails

If you are unsure how your lists should be structured across sites, SharePoint consulting services can help you design a list.

Build the Power Automate Microsoft Forms to SharePoint List Flow

A Power Automate Microsoft Forms to SharePoint list flow is an automated cloud flow with three core steps: a Forms trigger, a Get response details action, and a Create item action. That is the whole engine. Everything else is configuration.

Open Power Automate, choose Create > Automated cloud flow, and search for the Forms trigger. We will walk through each step in order.

Select the Form Submission Trigger

The trigger is When a new response is submitted (Common ways to use a form in a flow - Power Automate). Pick your form from the dropdown. If the form does not appear, you are signed in with the wrong account or the form lives in a different environment.

This trigger fires once per submission. It does not fire on edits to an existing response, which trips people up when they expect updates to sync. If you need edits to update the list, you need a second flow.

Retrieve Response Details and Map Questions to Columns

Add the Get response details action and select the same form. The action needs a Response Id, which the trigger passes in automatically through dynamic content. Leave that field alone.

Now add Create item and point it at your SharePoint site and list. The action shows every column you created. For each column, insert the matching dynamic content from the form response.

Watch the field types. A choice question returns text, so a Choice column accepts it. A multi-select question returns an array, which will not drop cleanly into a single text column. Date questions need a Date column, not text, or sorting breaks.

Add a New List Item and Test the Flow

Save the flow, then submit a real test submission through the form. Open the flow's run history. A green check means success. A red X means something failed, and the error message will usually name the exact step.

Check the list. Confirm every column filled correctly and nothing landed in the wrong field. Test with edge cases too: a blank optional field, a long text answer, and a file upload if your form has one.

If you want hands-on help building flows like this across your team, hands-on Power Automate training can help.

A Microsoft Forms to SharePoint List Flow Example You Can Copy

Here is a Microsoft Forms to SharePoint list flow example you can replicate for an equipment request process. The form asks for requester name, item needed, quantity, needed-by date, and a short justification. The list has matching columns.

The flow runs in order:

Schedule Free Consultation →

1. Trigger: When a new response is submitted
2. Get response details: pulls all five answers
3. Create item: writes each answer to its column
4. Send an email: optional confirmation to the requester

Adding a notification is an optional step. If your requests need sign-off, extend the flow into an approval step. Our guide on building a SharePoint document approval workflow walks through that pattern.

Handling Microsoft Forms File Upload to SharePoint List Attachments

A Microsoft Forms file upload to SharePoint list setup has a real limitation: Forms uploads files to the form owner's OneDrive, not to SharePoint, and the response only carries a link to that file. The file never moves into the list attachment on its own.

So you have two options:

• Store the attachment link in a text or hyperlink column and leave the file in OneDrive
• Add a step that copies the file into a SharePoint document library

The first option stores the attachment link in a column. The second copies the file into a SharePoint document library.

How to Troubleshoot Power Automate SharePoint List Flow Failures

When a Power Automate SharePoint list flow fails, open the run history first and read the error message before changing anything.

Check Run History and Error Messages

Go to the flow, select Run history, and click the failed run. Each step shows its input and output. Expand the failed step and read the error text. Common messages include:

• "The specified list does not exist", the list was renamed or deleted, or the flow points at a different site
• "Access denied", the connection account lost permission or the connection itself expired
• "Invalid type", a form answer does not match the column type
• "The request was throttled", SharePoint or Forms rate limits were hit during a burst of submissions

Fix the Most Common Connection and Mapping Errors

The fix is re-authenticating the connection under Data > Connections. If the flow owner's account was disabled, re-authentication is not enough, the flow must be reassigned to a new owner.

Mapping errors need a column type change or a conversion step. If a number question writes to a text column, the value arrives as text and math breaks downstream. If a multi-select answer writes to a single-line text column, add a Join action before Create item.

Prevent Duplicate List Items

To check for duplicates, store the Forms Response Id in a dedicated text column and check for it before creating an item:

1. Add a Get items action filtered with an OData query such as ResponseId eq '@{triggerOutputs()?['body/responseId']}'
2. Add a Condition that checks whether the returned array is empty
3. Only run Create item when the array is empty

Retry Safely After a Failure

Before you resubmit a failed run, check whether Create item already succeeded on a prior attempt. If it did, delete the duplicate rather than re-running the whole flow. For flows that must be idempotent, keep the Response Id check above in place.

Handle Missing Responses

If a submission never reaches the list, confirm three things in order: the form is still accepting responses, the flow is turned on, and the trigger is pointed at the correct form. A form that was duplicated or moved to a different group can leave the flow watching an old version that no longer receives submissions.

If flows keep failing across multiple processes, expert Power Automate consulting can help.

The run history error message usually points straight at the cause and the fix.

Error message	Cause	Fix
The specified list does not exist	List was renamed or deleted, or flow points at a different site	Point the flow at the correct list
Access denied	Connection account lost permission or connection expired	Re-authenticate the connection under Data > Connections
Invalid type	A form answer does not match the column type	Change the column type or add a conversion step
The request was throttled	SharePoint or Forms rate limits hit during a burst of submissions	Retry after the burst, checking for duplicates first

Permissions, Ownership, and Keeping the Flow Running Long Term

A flow runs under the connection of its owner. If that person leaves the company and their account is disabled, every flow they own stops.

Protect yourself with three habits:

• Assign a shared service account as flow owner, not an individual
• Document each flow's purpose and owner in a simple register
• Review flows quarterly for broken connections

Permissions on the list itself matter too. The flow's connection account needs Contribute access. Grant it deliberately rather than through a broad group.

Schedule a Walkthrough With Your Team

At MTRC Enterprises, we build alongside your team. Every engagement includes hands-on configuration, knowledge transfer, and a fixed price with defined deliverables. Our Microsoft Certified Trainer has over a decade of experience serving Fortune 500 companies and government agencies.

If you want a working session on your own forms and lists, book a free consultation and we will map the first flow together.

Frequently Asked Questions

Can Microsoft Forms automatically create SharePoint list items?

Not on its own. Microsoft Forms stores responses inside the form, and there is no built-in switch that writes them into a SharePoint list. You connect the two with a Power Automate flow that fires on each form submission and creates a list item. Once the flow is on, every new response lands in the list within seconds, and you can add conditions, approvals, or notifications on top of it.

Why are my Microsoft Forms responses not appearing in SharePoint?

The most common causes are a flow that was turned off, a broken connection to Forms or SharePoint, or a required list column that received an empty value. Open the flow's run history and check the failed run's error message. Fix the connection or column, then resubmit a test response. Also confirm the trigger points at the correct form, since a flow built on one form will not fire for another.

Can Microsoft Forms file uploads be saved to a SharePoint list?

Yes, but with a limitation. The file upload question returns a link to the file stored in the form's OneDrive, not the file itself. You can write that link into a hyperlink column in your list, and respondents with permission can open it. To store the actual file in SharePoint, add a step that copies the file into a document library and record the new path in the list item.

How do I map Microsoft Forms questions to SharePoint columns?

In the Create item action, each SharePoint column appears as a field. Click a field and pick the matching form answer from the dynamic content list. Match data types: a choice question maps to a Choice column, a date question to a Date column, and a number question to a Number column. If a column is missing from the action, refresh the action after adding it to the list.

---

Your forms are collecting data. The question is whether that data is working for you or sitting in a spreadsheet nobody opens. Get started with MTRC Enterprises and turn your form submissions into live, governed SharePoint data your team actually uses.