TL;DR
A new data sync solution is coming to Forms created from OneDrive and SharePoint. Forms for Excel to be renamed Forms survey. Due mid-October to mid-November 2024.
Details
Microsoft: “Before this rollout, Forms created from OneDrive and SharePoint Online used the old data sync solution. The Excel file was created automatically when creating the forms, and the Forms data was pushed to Excel file through Graph API.
With this rollout, Forms created from OneDrive and SharePoint Online will use the new data sync solution. The Excel file will not be created automatically. The user can create the Excel file from the Forms result page after responses have been received”.
Here’s the new workflow:
Create a new form from SharePoint or OneDrive: Select New > Forms survey (note that it is no longer called Forms for Excel).
Only once you have responses to the form can you create an Excel file from the Forms result page to sync the data:
The Excel file will be created in OneDrive/SharePoint folder where the form was created:
The new data sync can only be triggered in Excel for the web. If you want to receive new Forms response data in the Excel desktop app:
- Open the file in Excel for the web
- Wait for the desktop app file to sync from the web file.
Availability
Due mid-October to mid-November 2024.
Source, related links, and references
MC901820.
See similar changes for Forms across M365: Forms – Super Simple 365.
Related: Create a form with Microsoft Forms – Microsoft Support
Image(s): Microsoft.
Ask a question
Discuss and share this update on X/Twitter, Threads or LinkedIn.
Suggested action
Please share this page with your Forms-using colleagues so they can prepare for this update.
Page originally published
12th October 2024 and kept up to date.
See what else is late, new, and coming soon across M365 and Teams this month with the latest roundup.
🎦 Want to find innovative ways to exploit M365 within small teams across your organisation using only M365 apps you are already paying for, led by just one person? Re-watch my webinar with The Inform Team: ‘Efficiency at its finest: Making sure innovation is at the heart of your organisation’. Watch on YouTube (30 mins).
