This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
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.
That's exactly what we have as well. In the Excel file we created, we then have powerautomate fill the rows when a new entry is made to the form. I think it's exactly the same process you have. I'm sorry if my statement before was confusing. We don't download anything.
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
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.
I found a solution that may not be the best: working with a parallel Excel. This means not working with the Excel file generated by Forms, but with a parallel Excel file.
Flow: When a response is submitted > Get response details > Add a row into a table (Excel). Previously, I created a new Excel book.
This new Excel file is updated every time that a response is submitted.
Hi, I used a new Excel file, but I still have to open it to get it synced. Are you creating the Excel on the shared drive?
I totally agree with you