Forum Discussion
Location of Excel sheet holding Forms responses
Hello
If a user creates a form and shares it, responses go to an Excel sheet that the user can access through Forms. Where SPECIFICALLY is the Excel file located, not from a country perspective but from a file system perspective? I want to be able to share that spreadsheet with others, without transferring ownership of the form to a group, which creates all manner of issues with using Power Automate.
I am well aware that I can transfer ownership of the form to a Team to give all members easy access to the form, but doing so creates a lot of issues creating flows for form submission with Power Automate and I would prefer not to go there.
Thank you
5 Replies
RossChevalier the spreadsheet is stored somewhere on Microsoft's servers and you cannot access that location. If you want to share it without giving collaborate access just click on the Open in Excel link and then save it to your file system.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- Thank you for your reply. What is not clear is if I save the Excel file to my file system (One Drive or Teams share) if additions from new submissions will show up on the sheet now in the filesystem or if it becomes a static copy. If not, my issue remains open.
RossChevalier Hello, I have the same question 2 years later. Were you ever able to solve the issue?
