Microsoft forms responses are not syncing automatically to onedrive/sharepoint

Anonymous
2024-10-15T02:03:32+00:00

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

Microsoft 365 and Office | Microsoft Forms | For business

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.

0 comments

41 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-12-19T23:05:59+00:00

    If you have a work around, please share. I have several power automates based on this system - Forms, Excel, Power Automate, email. I'm looking for a way to keep this without having to open Excel files endlessly, and in the case of incidents, if I can't find a work around, we'll have to scrap the whole thing.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-12-19T22:48:08+00:00

    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!

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2024-12-19T21:54:37+00:00

    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.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  4. Anonymous
    2024-12-09T16:18:47+00:00

    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!

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  5. Anonymous
    2024-11-30T18:52:31+00:00

    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

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments