MicrosoftJust echoing what others have stated. The fact that the form creator has to manually open the excel and watch it update almost renders this functionality useless - especially if you have numerous forms that are shared with various teams (see screenshot).
The really puzzling thing is that I have numerous EXISTING forms that work just fine. The file properties show that the sharepoint app auto-updates the excel every time a form submission is received. Now that this "new functionality" has been added, when I create any NEW forms, the excel has to be manually updated by a creator to reflect new form submissions.
In summary: this has been a very damaging, massive step backwards. I'm not expressing this just to complain. I'm also wondering if anyone has found a solution or workaround.
I had the same issue, and sometimes it would not update even with the Forms creator having the file open, there would be a significant delay of hours sometimes, and there is no wat to trigger the update, except for with PowerAutomate. PowerAutomate is the only best workaround that works real-time without forms creator attendance. Read through this post for more details
Another way is to do it with PowerAutomate, which is a bit more complicated, but it processes the new form submission immediately as soon as there is a problem, you can google and search for a video that explains the process, its a trial an error thing. Also, you can make a test with one that previously worked.
Here is an example that helped me: Track Microsoft Forms response in Excel and notify through Teams and email | Power Automate
I did create a task in PowerAutomate to solve this problem and it works seamlessly now. I should have updated the posted once I did it. PowerAutomate has a really easy to follow interface to create the task as well. It really only took watching a YouTube instructional video and about 20 minutes to set up.
Thanks for the help!
Hi, can You please share the video which helped with auto syncing the form excels? Since the update I have to manually open all form excels so they are up to date. Thanks!
