Forum Discussion
Anonymous settings in MS Forms
simonpeuter the settings are either "anyone can respond" or only people in your organisation can respond". So if anyone can respond and you need their email address you must ask for that in a text question. Forms has no way of knowing their address otherwise.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott Ok, I have the 365 personal account. Created a form, that collected data into an excel book that the form created, but how can I add the Name and Email fields to the form not to have the anonymous fill in Name and and empty cell in Email. Thanks!
Marcelo_BCN if you have set the form to "anyone can respond" then it will ALWAYS add the response into the spreadsheet as Anonymous. If you need to collect those details from people outside your organisation then you in your form you will need to have mandatory questions for their name and email address.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott thanks very much. Is there any problem if I delete those columns? The form will never be used for my organisation. Also, I noticed I can't move columns to the left-right, no matter I thought it could obviously be done!! Any solution?
Thanks!
Marcelo_BCN I wouldn't delete those columns and you can't move them because it will affect the form. I never use the spreadsheet behind the form for anything other than a backup; in my business we always use a flow in Power Automate to save each response into a SharePoint list. You could equally have a simple flow to save the response to a different Excel spreadsheet without the name and email columns.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Many thanks, I will use it to combine mail in a Word document. Hope this is safe enough!!