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
    2025-01-08T19:19:59+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.

    Can you please tell me more about the download option? I used Power automate.

    My flow: is get a row from excel

    Hi,

    Okay!! I will change that to add a row and see if it works. But still logically thinking that we still have to open the Excel in the shared drive to get it synced right? Just we don't have to open Power Automate if we change the feature to add a row instead of get a row??

    Sorry for asking so many questions as I am so confused and frustrated. I am only data manager for a small non profit organization. I am trying to understand what to do.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-01-08T19:13:54+00:00

    Interesting! It's not working for us! It's already in the shared drive. Did you change the flow from get a row to add a row in Power Automate?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-01-08T19:10:51+00:00

    Our flow uses "add a row". My team then let me know that that was the best way to do it to lessen the complexity of the PowerAutomate

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-01-08T18:59:02+00:00

    Yes, I created the Excel file in Sharepoint and it works for me. The Excel file is updated every time that a response is submitted.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-01-08T18:52:36+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.

    Can you please tell me more about the download option? I used Power automate.

    My flow: is get a row from excel

    Sorry I meant to say will I change the flow from get a row to add a row in a table? I saw this comment so I asking.

    Was this answer helpful?

    0 comments