How to verify MS Form submitted outside of the organisation? (Flow + Forms)

[Anonymous]

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.

[Elton]

Thanks for sharing...

como ganhar na lotofacil

[yoshihirok]

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

[Anonymous]

Thank you @yoshihirok.

Indeed, you have a good point about security.

Brilliant idea, voted!

[Kav]

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.

[Anonymous]

Thank you @Kav for sharing your scenario.

This is a really great idea for making better the onboarding process. 

[paulosantos01]

Thank you for sharing this valuable information ...  

Curso de tatuagem