SOLVED

Permission to access results page

%3CLINGO-SUB%20id%3D%22lingo-sub-3202211%22%20slang%3D%22en-US%22%3EPermission%20to%20access%20results%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20MS%20form%26nbsp%3B%20within%20my%20organisation%20that%20anyone%20can%20respond.%26nbsp%3B%20I%20want%20users%20to%20be%20able%20to%20view%20results%20page%20and%20download%20data%20is%20excel%20but%20users%20are%20getting%20attached%20error%20(%20sorry%2C%20something%20went%20wrong.%20Please%20make%20sure%20you%20have%20permission%20to%20access%20this%20form...%20What%20is%20the%20best%20way%20to%20fix%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22anmol_khanna_0-1645587868539.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350585i14D210CCD6D66581%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22anmol_khanna_0-1645587868539.png%22%20alt%3D%22anmol_khanna_0-1645587868539.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3202211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20results%20page%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3202357%22%20slang%3D%22en-US%22%3ERe%3A%20Permission%20to%20access%20results%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1315229%22%20target%3D%22_blank%22%3E%40anmol_khanna%3C%2FA%3E%26nbsp%3Bonly%20users%20to%20whom%20you've%20given%20the%20%3CEM%3EShare%20to%20Collaborate%3C%2FEM%3E%20link%20can%20see%20the%20results%20and%20download%20the%20spreadsheet%2C%20no-one%20else%20can.%20Be%20careful%20with%20this%20because%20it%20means%20they%20can%20also%20edit%26nbsp%3B%20your%20form.%20To%20give%20ordinary%20users%20access%20to%20the%20results%20you%20would%20need%20to%20export%20the%20spreadsheet%20to%20Power%20BI%2C%20SharePoint%20or%20to%20another%20Excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a MS form  within my organisation that anyone can respond.  I want users to be able to view results page and download data is excel but users are getting attached error ( sorry, something went wrong. Please make sure you have permission to access this form... What is the best way to fix this?

anmol_khanna_0-1645587868539.png

 

1 Reply
best response confirmed by anmol_khanna (Occasional Contributor)
Solution

@anmol_khanna only users to whom you've given the Share to Collaborate link can see the results and download the spreadsheet, no-one else can. Be careful with this because it means they can also edit  your form. To give ordinary users access to the results you would need to export the spreadsheet to Power BI, SharePoint or to another Excel file.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)