Forum Discussion
Can i allow user to submit a form, while prevent them from viewing the results
Speaking of flow. If the form is long running etc. and securing the results is a priority you always have the option of creating a flow that copies the replies to a SharePoint list or other secured location. Then this way you only share out the form to be filled out and control access to the responses where you send them to with the flow. Pretty sure I’d you search for forms to sharepoint flow you will find an example out there.
Ok i got your point on sending email
now regarding the Permission and security.. not sure if i got your point correctly, but you mean we can/should not depend on the built-in Microsoft Forms capabilities, if we want to secure the form results and restrict viewing those results to only certain users??, and we have to create a flow? but what will the flow do in general? Will it move the result from being stored inside the MS Form to be stored in a secure place, which will be a sharepoint list ? or the flow will only copy the result to the sharepoint list ,, so still users can view the results from the MS form itself?
- TrevorHopkinsJBCNov 05, 2021Copper Contributor
john john MS forms saves responses in a spreadsheet (god knows why!) I think what is being suggested is that you create a flow that automatically saves responses to the form into a Sharepoint List which offers greater controls. This would not prevent the entries being saved into the Excel spreadsheet. You could expand this basic flow to delete the response recorded in the Excel spreadsheet after it has been written to the list (something I am considering doing). What I am not sure is whether this would prevent other team members from seeing the responses within the Teams app.
For your needs - I would probably say create the form as a Personal form and the use the sharing links to control who has access - I have done this previously and it seems to work ok.