Save Microsoft Forms Responses to Excel Online using Power Automate

Recently, I got a requirement to save Microsoft Forms responses to Excel Online automatically. In this tutorial, I will explain how to save Microsoft Forms responses to Excel Online using Power Automate.

Table of Contents

Save Microsoft Forms Responses to Excel Online using Power Automate

Here, you can see in the screenshot below that I have a Microsoft Forms like this. It has fields like:

Full Name
Date of Birth
Email Address
Date of Joining, etc.

Power Automate Microsoft Forms to Excel Online

Now, we will create a flow so that whenever a user submits a response, it will be saved in an Excel file.

Next, you can create an Excel workbook and then format it as a table from OneDrive for Business.

Follow the points below to create an Excel workbook.

Click on the app launcher icon (the squared dots) at the top left. Select OneDrive. Then, from inside OneDrive, click on “+Add new” at the top left side.
From the list of options, select Excel Workbook.

How to Export Microsoft Forms Responses to Excel

Then, an Excel Workbook opens in the browser. Click Saved -> Select a preferred name in the File Name Field and the desired location.

Power Automate Add form responses to an Excel worksheet

After that, map the column names that are taken in the Microsoft Form to the Excel columns, as shown in the screenshot below:

How to Export Microsoft Forms Responses to Excel in Power Automate

Then, select the created columns, click the Insert tab, and click the Table icon.

Power Automate save Microsoft Forms Data into an Excel spreadsheet

In the Create Table dialog box, check the “My table has headers” box and click OK.

Power Automate exporting Microsoft Forms responses automatically to Excel Online

Then, the Excel table is created as looks like in the image below:

Microsoft Power Automate How to get Forms responses to Excel table

Note:
You can also directly create a table in the Excel workbook and save it to SharePoint Documents or OneDrivelocation, so that we can use it in our flow.

This is how to create a table in an Excel Workbook using OneDrive for Business.

Now, the time to create our flow.

I will now show you how to automatically export Microsoft Forms responses to an Excel document using Power Automate.

Let’s create a Power Automate flow that will trigger automatically when a new response is added to the Microsoft Form.

1. Open the Power Automate home page in your browser, click + Create -> Select the Automated cloud flow -> Provide the flow name, and choose the trigger’s flow (When a new response is submitted) -> Click the Create button.

Inside the trigger, add the Form ID.

Form ID: Select a specific Microsoft Forms ID from the drop-down.

Power Automate Insert MS forms Responses to Excel table

2. Next, choose the Get response details flow action to retrieve the responses submitted in the Form. Provide the required parameters:

Form ID: From the dropdown, select the Form ID.
Response Id: Choose the Response Id from dynamic content.

Power Automate How to store Microsoft Forms Responses to an Excel Document

3. After that, to add the response details into the Excel worksheet, take the Add a row into a table action. Provide the required parameters:

Location – Select the SharePoint site where the Excel file exists.
Document library – choose the document library where you have stored the Excel spreadsheet.
File – Select the Excel file from the show picker.
Table – choose the table name you created in the Excel sheet.

We can see the column header once the table name has been selected. Then, from the dynamic content, pass the values for each field as highlighted below.