MicrosoftIs there any clarification on whether this new "feature" of having to open the responses in Excel to update the responses in Excel will go back to the superior method of the responses automatically flowing down to the Excel sheet in the SharePoint site (and also have the Excel sheets from Forms in their own folder instead of the root of the doc library as they now are)? Is this recognized as an issue and as such, have an ETA for a fix date?
I'm gonna be honest with you. Microsoft just like to ***** with the customers. If you see the dates on the comments you'll see that the bug (lets call it by what it is) was implemented (yes, Microsoft implemented a bug) since last year. I have multiple Forms running in the old (and superior) way and when I create new forms they run in the old way, but I have just a single form (which was running the old way) that updated into this mockery of feature. I will repeat that. I have MS Forms runing AS INTENDED (responses automatically flowing down to the Excel sheet) and in the "bugged state" (responses NOT automatically flowing down to the Excel sheet). 🤡
Rant's over. Just configure a Power Automate flow that creates a new row in another table (can be in another sheet in your original file of the form for simplicity) with the data of every new answer. For 99% of my forms I did not added that flow because they work as intended.
When a new response is submitted > Get response details > Add a row into a table
Be advised, the flow method also changes the format of the pictures if your form also includes them, so you should do extra steps (in PBI for example) in order to display them.
It's intentional.
The previous method didn't count towards your Power Automate actions. Where everyone switching to PA as a solution means it uses more actions. So some will likely have to upgrade their subscription.
I find the output of Forms now isn't great and the Worksheet and Table often have different names. Some of the Likert questions have different column names too.
Some have the top level question title followed by a '.' and then the row title, and some don't.
So for anyone including the spreadsheets in Power Bi will need to review the Worksheet, Table and column names.
Absolutely terrible change and implementation. No comms leading up to the change to warn about the risks or issues either.
However, what I don't understand is why you can have both types running and the same time and both types being able to be created in reads the current date again August 2025? This change was from last year, but all the forms I created before and after the one that presented the "feature" are created in the old way. 🤷♂️
