Others

How to Sync Microsoft Forms Responses with a Teams List

Adam Davis Sep 30, 2026 869 views

Question details

The user wants to transfer or automatically synchronize submitted data from Microsoft Forms into a Microsoft List located within Teams.

How to Sync Microsoft Forms Responses with a Teams List

Product: Microsoft Forms, Microsoft Teams, Power Automate
Device & OS: not provided
Scenario: Collecting data through Microsoft Forms and managing or tracking that data within a Microsoft List in a Teams channel.
Observed behavior: Form responses need to be either manually copied over or set up with an automated workflow to populate the Teams list seamlessly upon submission.

Before you start

Ensure you have owner or edit permissions for the source Microsoft Form and the target Microsoft List in Teams. For automated syncing, verify that your account has an active Power Automate license.

Solution 1Recommended

Automatically Sync New Responses Using Power Automate

Set up a Power Automate flow to automatically create a new list item in your Teams List whenever a user submits a response in Microsoft Forms.

This method is best for ongoing forms where you want new data to appear in your Microsoft List without any manual effort. Since Teams Lists are backed by SharePoint, you will use the SharePoint connector.

Create a new flow

Set the Forms trigger

Search for the Microsoft Forms connector, select the trigger 'When a new response is submitted', and choose your specific form from the dropdown menu.

Get response details

Click 'New step', search for 'Get response details' (Microsoft Forms), select your form again, and click the 'Response Id' field to map it using the dynamic content pop-up.

Add a SharePoint Create Item action

Click 'New step' and search for 'Create item' under SharePoint. Select the SharePoint Site Address associated with your Teams channel, and then select the List Name.

Map form answers to list columns

Once the list is selected, its columns will appear. Click into each field and select the corresponding dynamic content (the form questions) to map the data correctly, then save and test your flow.

Automatically Sync New Responses Using Power Automate

SharePoint Backend: Microsoft Lists created in Teams are stored in a SharePoint site backend. If you cannot find your list, make sure you are selecting the correct SharePoint site URL that matches your Teams team.

Solution 2

Manually Copy Existing Responses Using Grid View

Use this method to quickly transfer past Microsoft Forms responses into your Teams List by downloading the results to Excel and copying them.

Free Microsoft Office alternative

Manage Exported Form Data Easily with WPS Office

While automated syncing requires Microsoft Power Automate, dealing with downloaded Form responses manually requires a reliable spreadsheet editor. WPS Office provides a free, highly compatible suite to manage, clean, and organize your exported form data before pasting it into a Teams List.

1. Download WPS Office: Install the free WPS Office suite on your PC or Mac.
2. Open exported form data: Launch WPS Spreadsheet and open the .xlsx file downloaded from your Microsoft Forms Responses tab.
3. Clean and format: Use built-in tools to remove blank rows or format columns so they perfectly match your Teams List structure before copying.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless form response management.Lightweight architecture ensures large data exports open quickly without lagging.Familiar user interface lets you clean and organize spreadsheet data effortlessly.Free to use with comprehensive formatting and filtering capabilities.

Frequently Asked Questions

Why aren't my Microsoft Forms responses syncing to my Teams List immediately?

If you are using Power Automate, there can sometimes be a slight delay in the workflow execution. Check the 'Run history' of your flow in Power Automate to ensure it hasn't failed due to missing permissions, invalid data types, or incorrectly mapped required columns.

Can I sync form responses if my list is not backed by SharePoint?

Microsoft Lists created natively in Teams are inherently backed by SharePoint. If you are using a third-party list integration or app, you will need to search for that specific application's connector in Power Automate instead of using the SharePoint 'Create item' action.

Do I need a premium license to use Power Automate for syncing forms to lists?

No, the standard Microsoft Forms and SharePoint connectors required for syncing responses to a Teams List are included in most basic Microsoft 365 enterprise, business, or education subscriptions without needing a premium Power Automate license.

Office Quick Solutions