How to verify MS Form submitted outside of the organisation? (Flow + Forms)
The case
Company recruiting many short-term contractors.
Each new employee needs to provide some information in addition to their service agreement, like conflicts of interest questionnaire, privacy authorization etc.
We can easily create a Form to get all the required data including Name and email.
See simplified example below.
Short-term contractors do not have organisational accounts.
To be able users outside of the organisation submit a response, Form should allow anyone with the link submits a response.
It means that anyone can submit a response on behalf of another anonymously.
Which is definitely not right.
The solution
- Create a Form with the required fields, including Name and Email;
- Create a Flow triggered by a newly submitted response with the following logic:
- Send a verification email to the Email address filled in the response
- Handle received back response accordingly: do nothing if not verified or process further if verified
Thanks to @MGLovesFlow for sharing how Forms can be powered with Flow and SharePoint.
So I will not examine how to create Form and connect Flow to it.
In addition, let us focus on how to verify the response.
1. Send a verification email
This is a very simplified email.
All details provided in the email body.
In the real world business cases, you can attach a generated PDF to the email with all the provided details.
2. Handle response
If an email was confirmed you can build required business logic in ‘If yes’ branch.
Comments
-
How to verify MS Form submitted outside of the organisation? (Flow + Forms)
-
How to verify MS Form submitted outside of the organisation? (Flow + Forms)
This is great, going to use it to automate user creation workflow for clients. Fill out new staff members details in forms, generate text file using flow and gateway, scheduled powershell script that consumes text files, parses data and creates users.
-
How to verify MS Form submitted outside of the organisation? (Flow + Forms)
-
How to verify MS Form submitted outside of the organisation? (Flow + Forms)
Nice article. 😁
How to prevent by robot to the Microsoft Form?
- when attacker submit to the Microsoft Form, Send a lot of mail to anyone by input target email to the form.
and How to you think about my idea? - I'm not a robot" Button for reCAPTCHA -
How to verify MS Form submitted outside of the organisation? (Flow + Forms)
Thanks for sharing...
*This post is locked for comments