A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Sorry about being thick. Why do you have two flows. Why could the one flow not do both?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The responses from Forms are no longer automatically syncing to Excel.
I received an email stating, "Please update your form before January 13, 2025 to continue seeing the most recent Forms data in Excel with the new and improved sync. If you don't update, your responses won't continue to sync after this date. To start the update, open your Form from forms.office.com or click the button below. Thanks for using Forms."
After updating, I saw the message in Excel: "The sync with Forms has been updated. This workbook will continue to sync with the latest responses from Forms. The updated sync currently works only in Excel for the web and will soon be available on desktop. Once responses are synced, you will be able to view them on both web and desktop. This update cannot be undone."
However, even after the update, it does not sync unless I open Excel in the browser.
I would like it to sync automatically again without having to open it in a browser like before.
Does "it will soon be available on desktop" mean that eventually, it will sync automatically without having to open Excel?
How long should I wait?
By the way, since the Forms were created from a Teams channel, they are likely group forms.
This is the screen when I updated it.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Sorry about being thick. Why do you have two flows. Why could the one flow not do both?
Same here, this has effectively killed numerous workflows for us and going through one-by-one to create a Power Automate Flow just to do something the product used to do on it's own is ridiculous and unrealistic.
Microsoft PLEASE FIX THIS! You have broken your own product in a supposed "upgrade"
Do you "Add a row" to a brand new Excel file or add to the Excel file connected to Form? If same, how are duplicates prevented if/when data does sync?
Have the same question.
I also tried to use the "Update file" action to force the file refresh after a new response is submitted, but i'm getting an error mentioning
"Action 'Update_file' failed: The file is locked for [membership]."
I think the new sync locks the file and it doesn't allow any other operation.
I'm stuck on this and with a major impact on the refresh of my dashboards that rely on the forms inputs
I still don't understand how Microsoft hasn't fixed this. It really feels like the left it this way on purpose, almost as if they're trying to push users into "premium" features. Pretty disappointing , to be honest.