cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous

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.

 1_form_example.png

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.

 2_form_settings.png

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

3_email.png

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

4_handle_response.png

If an email was confirmed you can build required business logic in ‘If yes’ branch.

Comments

Thanks for sharing...

como ganhar na lotofacil

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!

Helper I

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. 

 

Thank you for sharing this valuable information ...  

Curso de tatuagem

Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Cambridge UK Power Platform User Group Leader, Technical evangelist and speaker. Always says yes to coffee! #LetsGetCoffee
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor
  • I am building business processes and applications that are easy for users' to stick to, so they can follow and understand them. In overall I transform processes to be more reliable and effortless. I am a proud co-organizer of SharePoint Saturday Warsaw and active community member, blogger and international speaker.