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)
The new excel sync function for Microsoft Forms is now making it nearly impossible to have the excel update when a form is placed. Before it would add the line and I could refresh my powerbi using power automate. Now it does not sync to forms until I open it in sharepoint let it sync then have to manually refresh it. If i do not open it it doesn't sync to the Forms answers.
I have an older excel I am afraid to update because of this issue. It still updated when a form is submitted and I do not have to interact.
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
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.
Is there any other way to refresh excel to sync using power automate cloud flow?
Dear JoshLPettit,
Good day! I hope you are doing well.
I believe that the Power Automate community may be able to come up with a better flow as our forum mainly focus on Microsoft 365 built-in features and also our has limited knowledge on using Power Automate. Therefore, I sincerely recommend posting your concern to the specific channel, Microsoft Power Platform Community by clicking on Post a question.
Members and engineers over there are proficient in the knowledge of Power Automate issues. We are sure that our experts from that team can address your query effectively and accurately.
I agree with you that this change in SharePoint is not convenient. We encourage you to share your thoughts and suggestions through our feedback community under SharePoint · Community by clicking on Send feedback
The product development team monitors this site around the clock and your feedback will be considered. This is the best way to let the team know your needs and help improve our products and services. We hope to see this feature in the future version of Microsoft Forms.
Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.
Sincerely,
Ralph Chawatama | Microsoft Community Moderator
So, for every answer I must add a parameter with the corresponding information from the form response to have to create the entire line? So if I have 200 response opportunities, I would have to add a parameter linked to each one of those 200 responses?
How did this make it better?
Dear Sujimon Raman Thankappan - COC,
Good day!
The similar issues may have different root causes, so I suggest you post a new thread so that we can involve more resources with more confirmation on the new thread and provide the corresponding suggestions.
Sincerely,
Ralph Chawatama | Microsoft Community Moderator
Dear JoshLPettit,
Good day! Thank you for posting to Microsoft Community. We are happy to help you.
We sincerely apologize for the difficulties you are experiencing with syncing your Excel file with Microsoft Forms without opening it. We deeply regret any inconvenience this has caused.
Unfortunately, Microsoft Form responses currently do not sync until the workbook is opened in the browser.
First, let me explain.
Previously, there were two ways for forms to sync data to Excel workbooks (sync responses in real time or sync responses only when you open the workbook in Excel for web).
With respect to how Microsoft Forms responses are synchronized with Excel workbooks, Microsoft frequently updates its products, and sometimes these updates can change how features work. I found that the recent update altered the synchronization behavior between Forms and Excel.
For Your Reference: Upgrade to the New Solution to Sync Form Responses to Excel | Microsoft Community Center
Since then, Microsoft has changed the syncing process for all forms. Currently, there is only one way (sync responses only when you open the workbook in Excel for web) for forms to synchronize data with Excel workbooks
Based on the above, I'm afraid that the only workaround to see real-time responses is to create a Power Automate flow that syncs data directly from the form to another workbook. For more detailed steps on configuring such a flow. Here is an example.
Arabic numeral. Open the original workbook and copy the whole table, paste it into the new workbook
one. Go to https://make.powerautomate.com/, log in to your account, click "My Flows" in the left sidebar, New Flow, Automated Cloud Flow, choose the "When a new response is sent" trigger.
b. In the "When a new response is submitted" trigger, click the down arrow and choose your form.
c. Add the "Get Answer Details" action, choose the form under Form ID, and select "Answer ID".
d. Add the "Add a row to a table" action, select the relevant group/location, library, select the new workbook and its table, under Advanced parameters, add the relevant parameters of "Get Answer Details".
Also, you can watch the YouTube videos to create such a flow.
Disclaimer: Microsoft makes no warranties, implied or otherwise, and is not responsible for the information you receive from linked third-party sites or any technology-related technical support.
Again, I'm sorry and apologize for that.
Your understanding and patience will be greatly appreciated. I hope you stay safe and healthy!
Sincerely,
Ralph Chawatama | Microsoft Community Moderator