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?
@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