Location of Excel sheet holding Forms responses

%3CLINGO-SUB%20id%3D%22lingo-sub-2261469%22%20slang%3D%22en-US%22%3ELocation%20of%20Excel%20sheet%20holding%20Forms%20responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261469%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20a%20user%20creates%20a%20form%20and%20shares%20it%2C%20responses%20go%20to%20an%20Excel%20sheet%20that%20the%20user%20can%20access%20through%20Forms.%26nbsp%3B%20Where%20SPECIFICALLY%20is%20the%20Excel%20file%20located%2C%20not%20from%20a%20country%20perspective%20but%20from%20a%20file%20system%20perspective%3F%26nbsp%3B%20I%20want%20to%20be%20able%20to%20share%20that%20spreadsheet%20with%20others%2C%20without%20transferring%20ownership%20of%20the%20form%20to%20a%20group%2C%20which%20creates%20all%20manner%20of%20issues%20with%20using%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20well%20aware%20that%20I%20can%20transfer%20ownership%20of%20the%20form%20to%20a%20Team%20to%20give%20all%20members%20easy%20access%20to%20the%20form%2C%20but%20doing%20so%20creates%20a%20lot%20of%20issues%20creating%20flows%20for%20form%20submission%20with%20Power%20Automate%20and%20I%20would%20prefer%20not%20to%20go%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

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

2 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.