Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello All,

I need help with an issue caused by a recent change in Microsoft Forms regarding Excel data syncing. Previously, when a staff member submitted a form, Zapier could detect new rows in the connected Excel spreadsheet to trigger subsequent actions which we use to send an email via Outlook.

However, the new Microsoft Forms update now states:
"Forms data sync is deprecating - Forms has a new and improved sync with Excel. To continue syncing new responses, you must update this workbook soon. When you open the synced workbook, you'll be given the option to upgrade to the new data sync early."

Due to this change, Excel must now be manually opened and synced to pull form responses. This manual step breaks our Zapier automation because new rows in Excel are no longer auto-updating the workbook unless someone manually opens and syncs the forms Excel workbook.

I want to ask for guidance on an alternative method or workaround to continue using Zapier to:

  • Eliminate the need for manual syncing of Excel.
  • Have Zapier auto-sync the workbook.

Are there any direct integrations between Microsoft Forms and Outlook through Zapier, or a recommended workaround that updates the Excel workbook altogether?
 

Hi ​@GDigital 

See if Microsoft Power Automate can be used to automate the workflow between the apps: https://support.microsoft.com/en-us/office/create-an-automated-workflow-for-microsoft-forms-dee28c00-503a-48b3-89df-91a5084e6e43

Hello ​@Troy Tessalone,
Thank you for your response.

I have no luck with creating the automation to “Update/Sync” the Excel document being ,that I am fairly new to Power Automate. The goal is to open Excel when a new response has been submitted to allow it to sync so that we may continue to use zapier. 

​@GDigital 

IF via Power Automate you can do the below, then the Zap should still work.

  1. Trigger: Microsoft Forms - When a new response is submitted
  2. Action: Microsoft Excel - Create Row
    1. TBD if this is possible
    2. Help: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel#insertrow

 

 

Hey there, ​@GDigital, welcome to the Community! 🎉

Have you had a chance to try out Troy’s suggestions yet? And if so, how did it go?

Want to ensure you’re all set here so let us know whether you still need any help at all!

Reply


Terms & Conditions