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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-07-16T19:11:33+00:00

    This does it, I just noticed this after creating a new Excel from my Form 3 times, because of broken sync. No more Microsoft Forms for me … What a mess!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-13T11:45:50+00:00

    Hi Raj,

    I'm going to try not to be rude, but I think you should withdraw your reply.

    Microsoft has changed their sync with Excel, and now Excel does not automatically sync every time a response is submitted from Forms. That's clear.

    In this post, all of us here are looking for a solution through Power Automate to automatically sync in Excel every time a Forms response is submitted.

    Sorry again if you think I'm being rude.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2025-01-08T17:42:11+00:00

    We have done something similar with PowerAutomate and 2 Excel files (the online from Forms and another one that we created to download to). The solution is thankfully working! The Created Excel is what is linked to our PowerBi dashboards.

    We run it through a Teams location because 365 for SharePoint is not enabled at our organization for some reason. We haven't seen an issue with it being maintained in the Teams location thus far.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2024-12-27T16:24:37+00:00

    Thank you! Super helpful! We’ve had to do the same thing. Really a bummer. But at least there’s something we can do! Thanks again!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2024-10-16T10:45:15+00:00

    Dear Deric,

    Thank you for the reply and screenshot.

    I have also tired in the NEW GUI, and you can refer to the screenshot below to sync the form in new workbook:

    Appreciate your understanding and patience.

    Sincerely,

    AJ RAJ| Microsoft Community Moderator

    Was this answer helpful?

    0 comments