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 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!!