# Save Microsoft Forms answers to a SharePoint list

> For the full documentation index, see https://250highstreet.com/llms.txt

> How to send every Microsoft Forms response into a SharePoint list with Power Automate: build the form, add columns, build a flow, map fields and test it.

Short answer: yes. Use a Power Automate flow with three steps: the trigger "When a new response is submitted", then "Get response details", then SharePoint "Create item". Map each form answer to a list column. Microsoft says the Forms connector only works with organizational accounts. The work has four parts: a form, a list whose columns mirror the questions, the flow, and one test submission. Exact names may differ on your screen.

## At a glance

| Item | Number | What it means for you |
|----|----|----|
| SharePoint calls per connection | 600 every 60 seconds | The Create item step counts toward this. Each response uses a call. A form would need hundreds of answers a minute to hit it. |
| Items in one list | 30 million | Every response becomes a row. A list holds far more than most forms collect. |
| List view threshold | 5,000 items | Once the list grows, views must be filtered to stay under this limit. |
| Lookup and person columns in one view | 12 | Mapping answers to person columns adds to this count in views. |

## What you are building

People fill in a short Microsoft Form. Each time someone submits, a new row appears in a SharePoint list. Your team works from the list, not from the Forms results page. In the list you can sort, filter, assign an owner and add a status column.

Here is the end result:

- One Microsoft Form with a few questions.
- One SharePoint list with a matching column for each question.
- One Power Automate flow that copies each response into the list.

This guide covers the Forms-to-list flow only. If you want people to use the list's own new-item form instead of Microsoft Forms, see "[How to set up a project intake form in SharePoint](/guides/setup-project-intake-form-sharepoint/)". If you are moving off a spreadsheet, see "[Replace a spreadsheet tracker with a SharePoint list](/guides/replace-spreadsheet-with-sharepoint-list/)".

## Before you start

The list is the part you will live with, so settle it first. Columns come before the flow, because the flow can only fill columns that already exist.

Write one column for each thing you want to sort or filter on later. The Title column is already there. Plan to put the most useful short answer in it, such as the request name, so every row has a readable label. Then add one column per remaining answer, and choose each column type once, because changing a type later can damage data already in it.

Keep two columns for your own team, outside the form: a Status choice and an Owner person. People fill those in after the row arrives.

## Step 1. Build the form

Microsoft's support page on creating a form gives these steps.

1.  Go to [https://forms.office.com](https://forms.office.com) and sign in with your work or school account.
2.  Select "New Form".
3.  Enter a title. Microsoft says form titles can have up to 90 characters. You can add a description if you want.
4.  Select "Add new" and choose a question type, such as Choice, Text, Rating or Date.
5.  Repeat for each question.
6.  Select "Preview", answer the questions and select "Submit" to test the form.

Your form saves as you work. One warning from Microsoft: deleting a question permanently deletes any response data collected for it. So finish the question list before you share the form.

Keep the question wording short and clear. The flow will use your question text as labels later, so "Your name" is easier to work with than a long sentence.

## Step 2. Create the list

Open your SharePoint site and create a blank list. Name it something that matches the form, such as "Requests". The exact menu names may differ. One path is "+ New", then "List", then "Blank list".

Add one column for each question. Match the column type to the kind of answer:

- Single line of text: a short text answer, such as a name.
- Multiple lines of text: a long text answer, such as a description.
- Choice: a question with a fixed set of answers.
- Date and time: a date question.
- Number: a rating or a count.

Add the Status (Choice: New, In progress, Done) and Owner (Person or Group) columns from Before you start.

Title: rename it to match the question whose answer works best as a short label, and map that answer to it in Step 6.

## Step 3. Start the flow

Go to Power Automate at [https://make.powerautomate.com](https://make.powerautomate.com) and sign in. Microsoft's page on creating a cloud flow describes the path: select "My flows", then "Create from blank", then "Add a trigger". Give the flow a name that you will recognize later, such as "Forms to Requests list".

Search for "Forms" or "Microsoft Forms" in the trigger search box. Choose the trigger named "When a new response is submitted". Microsoft's connector page says this trigger starts a flow when a new response comes in. It asks for one setting: the Form Id. In the list, pick your form.

Microsoft lists group forms as a known limit: they do not show up in that drop-down list. For a group form, you add the Form Id by hand. The connector page says to copy the Form Id from the address bar when you edit the form, and to paste only the part after "FormId=". If your form is a regular personal form, you can skip this.

You may also see an older version of the trigger marked "DEPRECATED". Pick the one without that label.

## Step 4. Add "Get response details"

At this point the flow knows a submission happened, but it holds only a Response Id, not what the person typed. The Forms connector reference pairs that Response Id with the "Get response details" action, which pulls the real content.

1.  Click the plus sign under the trigger and choose to add an action.
2.  Type "Get response details" and pick the Microsoft Forms result.
3.  Set Form Id to the form the trigger already uses.
4.  Drop the trigger's Response Id into the Response Id box from the dynamic content panel.

Because the connector reference calls this action's outputs dynamic, what appears afterward is shaped by your own form: every question turns into a token you can drop into the next action. Missing tokens? Click "See more" in the dynamic content panel.

## Step 5. Add SharePoint "Create item"

1.  Select the plus sign after "Get response details".
2.  Search for "Create item" under SharePoint and select it.
3.  For Site Address, pick your SharePoint site. Microsoft shows the format as a web address like [https://contoso.sharepoint.com/sites/sitename](https://contoso.sharepoint.com/sites/sitename). Picking from the list is easier than typing.
4.  For List Name, pick the list you made in Step 2.

After you choose the list, the action shows a field for each column. Skip the Status and Owner columns, or set a default such as "New" for Status.

## Step 6. Map the fields

Mapping means telling the flow which answer goes in which column. For each column in the "Create item" action:

1.  Select the empty field.
2.  Open the dynamic content list.
3.  Under "Get response details", select the answer that matches the column.

Match them one to one. The answer to "Your name" goes in the name column. The answer to "What do you need?" goes in the description column. Use the Title column for the answer that works best as a short name.

Three mapping mistakes to check:

- A Choice column gets text that does not match one of its options. Make the form choices and the list choices the same words.
- A Date column gets an answer that is not a date. Use a Date question in the form for a Date column.
- A Person column does not accept a plain name. Collect an email address in the form and put it in the Person field (it accepts an email), or use a plain text column to start.

Save the flow when you are done. Power Automate checks the flow and shows any errors.

## Step 7. Test it

1.  Open your form and submit one real-looking answer.
2.  Wait a minute or two, then open the SharePoint list. The new row should be there.
3.  If not, go to Power Automate, select "My flows", select your flow, and select "Details". Microsoft says the run history appears there, under "28 day run history". Select a run to see the inputs and outputs of each step.

If a run failed, the run view shows which step stopped and why. Check the mapping first, such as a Choice mismatch or an empty required column. Fix the step, save, and submit another test answer. Each test answer adds a row, so delete the test rows from the list when you are done.

## Make the list useful

A copied row is only the start. A few small changes make the list work for your team:

- Add a view called "New" that shows rows where Status is New.
- Add a column for who owns the row, and agree on who checks the list each day.
- Show only the columns your team needs in the main view.

## If it is not working

Check these in order.

1.  Account type. Microsoft says the connector only works with organizational accounts, so a personal Microsoft account cannot be used.
2.  Group form. Microsoft says group forms will not show up in the drop-down list, so the Form Id must be added manually (see Step 3).
3.  Old trigger. Microsoft marks one version of the trigger "DEPRECATED". Use the version without that label.
4.  Flow status. Open the flow and check that it is on. See "[Why Power Automate turned your flow off, and how to turn it back on](/guides/power-automate-flow-turned-off-automatically/)".
5.  Concurrency error. Microsoft says that if you see the "CannotDisableTriggerConcurrency" error with a Forms trigger, the workaround is to export the flow and edit the JSON file to remove the "concurrency control" part, so the concurrency option is disabled when you re-import it.
6.  Run history. Open the failed run and read which step stopped.

## Updating a list row from a later response

Create item adds a new row each time. Microsoft's SharePoint connector page lists Update item as an action that updates an item in a SharePoint list. It needs a way to find the right row, such as its ID, so plan a column on the form that identifies the row.

## File upload questions

Microsoft's SharePoint connector page lists an Add attachment action that adds a new attachment to the specified list item, and says the connector supports list item attachment sizes up to 90 MB. The list must have attachments turned on. Microsoft's Forms connector page does not describe how file upload answers reach the flow, so the exact steps for that question type are not covered here.

## Honest limits

Only brand-new submissions create rows. A respondent who changes an answer in Forms later will not change the matching row. To avoid two versions of the truth, make the list your working record once a row lands, and edit there.

Ownership matters too. The flow belongs to whoever built it, and it may stop if that person leaves the company. Ask your admin whether ownership can be handed over or a shared service account used.

The Forms connector page also lists a throttling limit of 300 calls per connection in 60 seconds.

Finally, ask your admin before collecting anything sensitive. Company policy may restrict where such data may be stored.

## When to get help

You can build all of this yourself in Microsoft 365. If you would rather have it built and tested for your team, I do that. A tracker like this is a fixed price: \$5,000 for one, built in 2 weeks. See "[What a SharePoint tracker costs to build](/guides/what-a-sharepoint-tracker-costs/)". Bring one example of the problem to a free call.

I am Al Davies. I run 250 High Street LLC and build SharePoint trackers and Power Automate flows for operations teams. I work remotely. The first call is free, and I will not try to sell you anything.

See trackers I built: [Tools I built](/portfolio/)

## FAQ

Updated 2026-10-27.

### Why is my Microsoft Forms to SharePoint list flow not working?

Check the account type (Microsoft says the connector only works with organizational accounts), whether it is a group form, whether you used the deprecated trigger, whether the flow is on, and the run history.

### How do I save Microsoft Forms file uploads to a SharePoint list as attachments?

SharePoint has an Add attachment action for list items, with attachments up to 90 MB per Microsoft. Microsoft's Forms connector page does not show the file upload steps.

### How do I save a Forms Choice answer into a SharePoint Choice column?

Our advice, not a Microsoft rule: make the form choices and the list choices the same words, then map the answer to the Choice column in Create item.

### How do I update a SharePoint list item from Microsoft Forms with Power Automate?

Use the SharePoint Update item action, which updates an item in a list. It needs a way to find the right row, such as its ID.

### My group form does not show in the form list. What do I do?

Microsoft's connector page says group forms do not appear in the drop-down. Add the Form Id by hand. Copy the part after "FormId=" from the address bar when you edit the form.

## Sources

- [Microsoft Learn, Microsoft Forms connector reference (trigger, "Get response details", known limits)](https://learn.microsoft.com/en-us/connectors/microsoftforms/)
- [Microsoft Learn, SharePoint connector reference ("Create item")](https://learn.microsoft.com/en-us/connectors/sharepointonline/)
- [Microsoft Learn, Create a cloud flow in Power Automate](https://learn.microsoft.com/en-us/power-automate/get-started-logic-flow)
- [Microsoft Support, Create a form with Microsoft Forms](https://support.microsoft.com/en-us/office/create-a-form-with-microsoft-forms-4ffb64cc-7d5d-402f-b82e-b1d49418fd9d)
- [Microsoft Support, List View Threshold for large lists and libraries](https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59)
- [Microsoft Learn, SharePoint limits - Service Descriptions](https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits)

## Related guides

- [Create a Planner task automatically from a Forms response](/guides/power-automate-create-planner-task-from-form/)
- [Microsoft Forms not saving responses: what to check](/guides/microsoft-forms-not-saving-responses/)
- [Microsoft Forms vs Google Forms for a small business](/guides/microsoft-forms-vs-google-forms/)
- [Make a pre-filled Microsoft Forms link](/guides/microsoft-forms-prefilled-link/)
- [Event registration tracker with Microsoft Forms and SharePoint](/guides/event-registration-tracker-sharepoint/)
- [Add an image to a Microsoft Forms question](/guides/microsoft-forms-add-image-to-question/)

Source: https://250highstreet.com/guides/microsoft-forms-to-sharepoint-list/