Microsoft Forms - move location of Excel file that updates with new answers

Question

I have a Microsoft Form on a page on our SharePoint Intranet and it gathers answers and updates an Excel file automatically. I chose the Sync all responses... option in the form and this worked fine; it created a new workbook in my OneDrive and all new answers are updated in the Excel file.

My problem is that this file is only on my local OneDrive and it needs to be in the document library on the Intranet because it will be monitored by somebody else. I moved the file from where it was created on my OneDrive into one of the folders in the Intranet document library but now it no longer updates, so I presume moving it broke the connection to the Form.

I can't see where I can reconnect it to the Form or change the path of the Excel file from the Forms settings, is this possible? Or is there a different way to move the file without breaking the connection?

Thanks,

David

Answer 1

Dear David,

Good day! Thanks for posting in Microsoft Community. We are happy to help you.

For your question, you can't change the path of the Excel file or reconnect the form with another Excel file, but you can sync all responses to a new workbook which is stored in the Document library of the site. As you are the form owner, to meet your requirement, you need to move the current form to a group (the same name as the site) in Forms. After that, a new workbook will be created in the Document library of the site, and it should have all responses.

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator

Answer 2

Dear David,

Thanks for posting back.

As far as I know, there shouldn't be a SharePoint URL like sharepoint.com/teams/{sitename}. Can you provide a screenshot of a related SharePoint URL for us to better understand? Please remember to mask the tenant name and site name in the screenshot.

For your Edit part, it seems you are trying to sync the form responses to a SharePoint list, and it doesn't work well. If so, currently, how you sync the form responses?

We look forward to your response. Thanks for your cooperation.

Sincerely,

George | Microsoft Community Moderator

Answer 3

Sorry for the delay in answering - I changed my approach now so when a Form response is submitted, a Flow will update a SharePoint list. From here the relevant team can monitor the answers and export to an Excel file on their same site so this fits for their purpose.

Thanks for your help!

David

Answer 4

Can you move it within the folders of the Document library? Or will moving the file break the connection for live updates?

Answer 5

I have the same question, I don't want these responses in my top-level documents folder, but could to store them in a subfolder within Documents ...