Others

How to Connect a Microsoft Forms Group Form to Excel Using Power Automate

Algirdas Jasaitis Oct 10, 2026 869 views

Question details

The user needs to connect a Microsoft Forms group form to Excel via Power Automate, but the form does not appear in the flow trigger list and returns an invalid ID error when entered manually.

How to Connect a Microsoft Forms Group Form to Excel Using Power Automate

Product: Microsoft Forms, Power Automate, Excel
Device & OS: not provided
Scenario: Automating the collection of form responses from a Microsoft 365 Group Form into an Excel spreadsheet.
Observed behavior: Group forms fail to populate in the Power Automate Forms trigger dropdown. Manual Form ID entry is required, and an invalid ID error occurs if permissions or URL parameters are incorrect. The destination Excel file also requires a strictly formatted table.

Before you start

Verify that your Power Automate connection account has the correct permissions to access the Microsoft 365 Group where the form is located, and ensure you have a blank Excel workbook ready in SharePoint or OneDrive.

Solution 1Recommended

Manually Configure the Form ID and Excel Table

Use this method to bypass the trigger dropdown limitation by manually locating the Form ID and properly structuring the target Excel file to accept automated data.

Because Microsoft 365 Group forms are stored differently than personal forms, they frequently do not appear in Power Automate's dynamic dropdown menus. You must extract the unique Form ID directly from the web browser URL.

Additionally, Power Automate cannot write data to a blank spreadsheet sheet; the destination cells must be explicitly defined as a Table.

Extract the Form ID

Open your group form in a web browser. Look at the address bar and copy the long string of characters immediately following the 'id=' parameter in the URL. Ensure you do not copy any other parameters like '&'.

Enter the Form ID in Power Automate

In your Power Automate flow, click on the 'When a new response is submitted' trigger. Select 'Enter custom value' from the dropdown and paste the copied Form ID. Repeat this step for the 'Get response details' action.

Prepare the Excel Table

Open your destination Excel workbook. Type headers in the first row that correspond to your form questions. Highlight these headers, navigate to Insert > Table (or press Ctrl+T), check 'My table has headers', and click OK.

Configure the Excel Action

Add the 'Add a row into a table' Excel Online action to your flow. Select your file and the newly created table from the dropdowns. Map the dynamic form response outputs to the corresponding columns in your Excel table.

Manually Configure the Form ID and Excel Table

Verify Account Permissions: If you receive an 'invalid form ID' or dynamic output error upon saving the flow, double-check that the account you used to sign into the Power Automate connector has explicit member access to the Microsoft 365 Group owning the form.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

While Power Automate and Microsoft Forms require specific Office 365 enterprise or business subscriptions, WPS Office offers a free, lightweight alternative for your daily spreadsheet and document management tasks. Enjoy full Microsoft format compatibility without the heavy subscription costs.

1. Download and Install: Visit the official WPS website to download and install WPS Office for your operating system.
2. Open Your Workbooks: Launch WPS Spreadsheets and easily open any existing .xlsx or .csv files exported from your form data.
3. Manage Data Easily: Use powerful built-in tools like PivotTables, formatting, and formulas to analyze your collected form data.

Free and lightweight complete Office suiteFully compatible with Microsoft Excel (.xlsx) formatsFamiliar user interface for seamless migrationBuilt-in WPS Form features for easy data collection

Frequently Asked Questions

Why does Power Automate say my form ID is invalid?

This error usually occurs for two reasons: either extra characters (like an '&') were accidentally copied from the URL along with the ID, or the account linking Power Automate to Microsoft Forms does not have permission to view the specific Microsoft 365 Group form.

Must I create a table in the Excel spreadsheet?

Yes. The 'Add a row into a table' action in Power Automate requires a specifically formatted Excel Table. It cannot write data directly to generic cells on a blank worksheet.

How extensive does the Excel table need to be?

The table must have at least one designated column header for every form field you intend to capture. The columns do not need to be in the exact same order as the form, but having clear, matching headers makes mapping the data in Power Automate much easier.

Office Quick Solutions