This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We used to have an excel system running off the final line of the excel sheet generated by forms.
I have a new tenant and forms is using the new GUI
I send some responses inside forms, but the results are not synced/updated inside my sharepoint/onedrive excel sheet automatically.
It will only work if i click on open result in excel inside the webpage, which will then only update my excel in sharepoint/onedrive.
Please advise how i can get it working again.
Thanks
A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
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.
Noted on your reply, we will try out the power automate feature then.
Just like hundreds in the comment section and probably thousands out there I am frustrated too with this change. This definitely looks like step backwards. What used to an automated thing now requires us to manual open the excel. For someone like me this also means I will no longer be able to seamlessly connect the form responses (saved in excel) to be used in other flows within power automate. This is such a bad move
Read more about the update here https://techcommunity.microsoft.com/blog/microsoftformsblog/update-to-the-new-solution-for-syncing-forms-responses-to-excel/4229844
I could not agree more about this change. This is a huge step backwards in terms of seemless data management. I have several 30+ excel spreadsheets that I have to manually update for my PowerBi and Power Automate systems to work. These funnel into Business dashboards that are updated regularly. Please, Microsoft, fix this issue. It's a major problem!
Why, why, WHY did Microsoft change this?!?
I have created a form to report incidents in our plant and warehouse. They scan the QR code and fill out the form. Once they submit the form, it was automatically syncing to the Excel spreadsheet. Then I created a Power Automate to immediately email a set of employees designated to handle incidents. Now, it doesn't do it. Now, I am supposed to guess when there's an incident and go in and open the spreadsheet in the online version to get the report to the contact people? So, am I expected to spend my day .. AND NIGHT .. checking the form 24/7 to notify the incident team that something is wrong?
This is absolutely ridiculous. It worked perfectly, but now Microsoft has decided to "upgrade it" and make it stop working? For what reason? Please explain it to me like I am 5 because now my beautiful incident report mechanism doesn't work AT ALL. And this is a HUGE problem.
I could not agree more! I have the same problem with ALL of our forms that we've created and attached to dashboards in PowerBI. Thankfully, I think our internal team has identified another solution but it requires us to create another PowerAutomate in its place. Truly the WORST Microsoft update ever!