MS forms and refreshing data in Excel table

Hello. I have an MS forms set-up, and I can easily export the results to Excel. However, once I've opened the Excel file (and let's say I fill out another form response), is there a way to hit REFRESH in Excel to see the updated results (something that I know I can do when data is stored in sharepoint). Or, do I have to re-export from MS forms every time? Thanks!

EDIT: It does seemthat Excel for the Web automatically refreshes with new responses, but not necessarily the desktop version. Anyway around that?

Categories:

Business Process Flows

Hi CedarTree72,

Thank you for choosing Microsoft Community.

You're right that Excel for the Web automatically refreshes with new responses from Microsoft Forms, but the desktop version doesn't have this feature. However, you can set up a workaround to keep your data updated without manually re-exporting each time.

Using Power Automate to Sync Data

You can use Power Automate to create a flow that automatically updates your Excel file with new responses from Microsoft Forms. Here's how:

Create a New Flow:
- Go to Power Automate and sign in with your Microsoft account.
- Click on "Create" and select "Automated cloud flow."
Set Up the Trigger:
- Choose the trigger "When a new response is submitted" from the Microsoft Forms connector.
- Select the form you want to monitor for new responses.
Add an Action to Get Response Details:
- Add the action "Get response details" from the Microsoft Forms connector.
- Select the form and the response ID.
Add an Action to Update Excel:
- Add the action "Add a row into a table" from the Excel Online (Business) connector.
- Select the Excel file and the table where you want to add the new responses.
Map the Form Responses to Excel Columns:
- Map the fields from the form response to the corresponding columns in your Excel table.
Save and Test the Flow:
- Save your flow and test it by submitting a new response to your form. The flow should automatically add the new response to your Excel file.