Exporting forms data to Excel

Copper Contributor

When I export the responses to Excel they all come out correctly except the email.  In Excel this field always says "Anonymous" instead of the persons email address as per their response. 


Do anyone know why please?

1 Reply

@Ashburton2020 what have you set the form settings to? If you have set them to only people in my organisation can respond then it will capture their email address. If you have set the form to "Anyone with the link can respond" then it won't, it will always be anonymous.


Los Gallardos
Microsoft Power Automate Community Super User