Anonymous Answers in Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2065121%22%20slang%3D%22en-US%22%3EAnonymous%20Answers%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065121%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20for%20a%20State%20Agency%20and%20we%20are%20required%20by%20the%20Feds%20to%20submit%20a%20list%20of%20people%20who%20complete%20a%20Form.%20I%20tested%20the%20form%2Fsurvey%20and%20my%20name%20appeared%20on%20the%20spreadsheet.%20However%2C%20now%20that%20150%2B%20people%20have%20completed%20the%20Survey%2C%20every%20other%20name%20shows%20%22anonymous%22.%20Is%20there%20anyway%20someone%20can%20find%20this%20data%20so%20it%20doesn't%20show%20anonymous%20so%20we%20can%20submit%20it%20to%20the%20Feds%20so%20we%20don't%20get%20an%20audit%20finding%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2065121%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%20Responses%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067347%22%20slang%3D%22en-US%22%3ERe%3A%20Anonymous%20Answers%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930832%22%20target%3D%22_blank%22%3E%40tmurlin%3C%2FA%3E%26nbsp%3Bif%20you%20have%20set%20your%20form%20so%20that%20only%20people%20in%20your%20organisation%20can%20respond%20then%20Forms%20knows%20who%20they%20are%20and%20will%20record%20their%20email%20address.%20However%2C%20if%20you%20have%20set%20your%20form%20so%20that%20anyone%20with%20a%20link%20can%20respond%20then%20the%20only%20way%20you%20can%20identify%20who%20has%20submitted%20a%20response%20is%20by%20asking%20them%20their%20name%20and%20email%20address%20as%20questions%20in%20the%20form.%20I%20assume%20you%20haven't%20done%20that%20and%20that%20external%20people%20have%20submitted%20a%20response%20which%20is%20therefore%20shown%20as%20anonymous.%20There%20is%20no%20way%20to%20find%20out%20who%20they%20are.%20If%20you%20could%20and%20the%20responder%20thought%20it%20was%20anonymous%20it%20would%20be%20a%20compliance%20and%20regulatory%20nightmare%2C%20at%20least%20here%20in%20the%20EU.%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%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I work for a State Agency and we are required by the Feds to submit a list of people who complete a Form. I tested the form/survey and my name appeared on the spreadsheet. However, now that 150+ people have completed the Survey, every other name shows "anonymous". Is there anyway someone can find this data so it doesn't show anonymous so we can submit it to the Feds so we don't get an audit finding? 

 

Thank you. 

4 Replies

@tmurlin if you have set your form so that only people in your organisation can respond then Forms knows who they are and will record their email address. However, if you have set your form so that anyone with a link can respond then the only way you can identify who has submitted a response is by asking them their name and email address as questions in the form. I assume you haven't done that and that external people have submitted a response which is therefore shown as anonymous. There is no way to find out who they are. If you could and the responder thought it was anonymous it would be a compliance and regulatory nightmare, at least here in the EU.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thanks for your above response but, in my case, I HAVE included a name and email question. All of the responses include that but the scroll through list still has every response as anonymous.  The name and address columns on the excel spreadsheet are empty.  I asked the question in French (votre NOM, votre adresse mail, etc).  

Thanks

@Tom_Hawkins If you've set the settings to "any with a link can respond" then Forms will always record it as anonymous, but the spreadsheet should still be showing their names in the votre nom and votre adresse columns if the user has entered them - make sure they are mandatory questions.

 

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

So long as I allow anyone to answer it will always be listed as anonymous. Oh well. The name and address responses ARE in the spreadsheet and that's what matters the most. I was just hoping that the scroll list under "responses" would eventually be able to list the names but apparently that's not the case. Thanks everyone.