Forum Discussion
How to reveal anonymous submissions in Microsoft Forms
RobElliott This is the result of experiments we recently did in administration team before deciding if it can be used in important secret votings inside of organization. And in enterprise tenant we could find the vote's authors with such cross-corelation.
If you want to reproduce it, 30 minutes after voting open Exchange Online powershell and type something like this:
You'll get their votes from last day. If you also have the result excel, you can find which vote is which.
It looks like there are two remedies:
1. Disable audit logs
2. Require organizer to export excel right after voting, remove ID and date columns, sort the results, delete the forms (+ delete from recycle bin). That prevents even global admins from getting the result excel
Global admins in Microsoft365 are pretty powerful (and even more powerful are on-premise admins). The security & compliance features allow pretty deep insight into mail contents or OneDrive files. That's the way IT works, you need to trust IT 😉
