Forum Discussion

Gary Walker's avatar
Gary Walker
Copper Contributor
Apr 27, 2020

How to reveal anonymous submissions in Microsoft Forms

Hi all,    I'm relatively new to using Microsoft Forms, and I did not know that the default setting for MS Forms submissions was to show user feedback as "anonymous." My form is a simple yes or no ...
microsoft forms
Survey
Karol Grodzicki's avatar
Karol Grodzicki
Copper Contributor
Nov 27, 2020

Actually, it can be possible if the admin have enabled the audit log. If they query the logs for CreateResponse events they can find something like below.

It shows when the user voted (with second precision in UTC) and the ResponseId. When you check the result excel file, you can find the IDs in first column and the answer time in secod and third column. By cross-corelating them you can find which vote was whose

 

RunspaceId : eed91bd7-f7b9-466f-8294-16ad2b347806

RecordType : MicrosoftForms

CreationDate : 2020-11-24 13:54:42

UserIds : ***

Operations : CreateResponse

AuditData : {"CreationTime":"2020-11-14T13:54:42","Id":"***","Operation":"CreateResponse","OrganizationId":"***","RecordType":66,"ResultStatus":"Succeeded","UserKey":"","UserType":0,"Version":1,"Workload":"MicrosoftForms","ClientIP":"","UserId":"<email@email>","ActivityParameters":"\"ResponseId\":4}","FormId":"Ho024XU55kyJPfw1H9RNzXN-mpx4yKxGhcITCP5K3UJURThFQVNOVUEyOUxSRVVXSFUyQTU4NExMMC4u","FormName":"Pytanie","FormsUserType":1,"SourceApp":"ms-teamsbot"}

 

Note that I replaced some parts with asterisks in original response you can find the real e-mail there

 

 

 

GavinMeerwald's avatar
GavinMeerwald
Copper Contributor
Jul 30, 2025

This still doesn't tell you the identity of the person. All you get is the ResponseId to match against the ResponseId from the exported Excel results. No identity is disclosed.

Resources