Forum Discussion
Dave_Lee
Jun 11, 2019Brass Contributor
Allow only selected users in my organisation to fill out a Form?
New Forms user here. I don't think this possible but wanted to ask before submitting an idea. Is it possible to restrict the filling out of a Form to only certain, selected people within our organ...
- Jun 11, 2019A better option here would be to utilize powerapps to build your form, and or utilize SharePoint list form. You can manage permissions to individuals that way with either option and there is even a hybrid method, but if forms is good enough then a basic SharePoint list, with custom permissions would work. You could take it furthur and turn on list item settings to view only their own items in advanced list setitngs so that only the site/list owner (designer) can see the submissions, but the users will only see their own.
Nick_Ellis
Brass Contributor
Dave_Lee What you could do is have Power Automate delete any non-compliant submissions, and make clear at the top of the form that this will happen.
Ian_Galloway
Jan 20, 2021Copper Contributor
Nick_Ellis Are you able to provide guidance on how to achieve this please. Many thanks
- FriyankJan 20, 2021Copper Contributor
Ian_Galloway
Check this blog How to limit the responses in Microsoft Forms or send email on behalf of DL? – Friyank Parikh Blog (wordpress.com)- RobElliottJan 23, 2021Silver Contributor
Friyank that's only of any use if you are using Forms Pro/Customer Voice. It is not a solution for standard Microsoft Forms.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Nick_EllisApr 20, 2021Brass ContributorHi Ian, sorry it's been so long!
I think the first thing I would do is create a security group of people allowed to complete the form. Then, in Power Automate, create an automated flow that fires on form submission. Use the Office 365 Groups connector to determine if the new row 'Submitter' value is someone in the group. If it is, do nothing. If it's not, use the Forms connector to delete the row.
The 'making it clear at the top' is just text in the Description field in Forms.