We are excited to announce that we have a new and improved solution for syncing your form responses to Excel, with better reliability and performance! Previously, some Forms supported an older versio...
Updated Sep 18, 2024
Version 2.0
Blog Post
Best is the enemy of good. The problem is with "new solution" Excel file with responses is not updated till it is opened. In our processes Excel file collects Forms responses in background. Dataflow summarize them, when it goes to sematic model or another Excel file for the reporting. Nobody cares to open the file with responses if only some issues appear. Now I need to add one more step to the process with Power Automate which collects responses in Excel file on "When a new response is submitted" event. Oh, boy...
Thank you for the alerting in advance.
I'm running into a similar issue. I'm running a powerBi report of the excel file, but as this does not open the file, the data is not being updated anymore.
Could you give me a hint on what to add to the Power Automate script to force an update of the file?
Thanks!
and msexcel no thanks.
https://docs.google.com/document/d/1C9H2CatRKTc4SP9i_c3GoiEF_pHpaR8PEGX09sD5rCM/edit?usp=sharing
Most probably some blog exists with detailed explanations exists somewhere. In brief, you create Excel file in SharePoint library with table where columns are answers you'd like to collect. Plus timestamp and user UPN. Flow itself is simple
First is the trigger on form response, next you get all details, email is optional, on last step you add response details to the table row mapping them on table columns. Just fill required boxes on each step, no formulae are required.
