Exporting forms data to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1288514%22%20slang%3D%22en-US%22%3EExporting%20forms%20data%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288514%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20export%20the%20responses%20to%20Excel%20they%20all%20come%20out%20correctly%20except%20the%20email.%26nbsp%3B%20In%20Excel%20this%20field%20always%20says%20%22Anonymous%22%20instead%20of%20the%20persons%20email%20address%20as%20per%20their%20response.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20anyone%20know%20why%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1288514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1288906%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20forms%20data%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612770%22%20target%3D%22_blank%22%3E%40Ashburton2020%3C%2FA%3E%26nbsp%3Bwhat%20have%20you%20set%20the%20form%20settings%20to%3F%20If%20you%20have%20set%20them%20to%20only%20people%20in%20my%20organisation%20can%20respond%20then%20it%20will%20capture%20their%20email%20address.%20If%20you%20have%20set%20the%20form%20to%20%22Anyone%20with%20the%20link%20can%20respond%22%20then%20it%20won't%2C%20it%20will%20always%20be%20anonymous.%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

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

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User