cancel
Showing results for 
Search instead for 
Did you mean: 

Authentication on Microsoft Forms

Summary

In short, we want to setup a way to allow certain users to fill out a MS form.
How can we achieve this?
My Flow below will show how to take a list from SharePoint that has users emails, to only allow them to process the Form.

** You can use any means you want to get a list of Users emails **

 

Setup

First you will need to have a Microsoft Form created - Any MS Form will work

Next, we setup our List of 'Authenticated' Emails. Again in this demo I am using SharePoint
I created a simple SharePoint List with a single text field to store email addresses

sharepoint-pic-1

Steps

In your Flow. Use your basic MS forms trigger and Action to get the details like normal.

Next add a Variable, we make the Type an Array
Under the Variable, add Get items action, and choose our Authenticated users list that we created in SharePointMake sure your Variable is Type ArrayMake sure your Variable is Type Array

 

 

 

Next, add an Apply to each loop. Select the value from the Get items action.
Inside the loop, add a Append to array variable, select the variable that we initialized above. Value = the column name that stores the email Address in our SharePoint List

flow-pic2

 

Outside the loop - Add a Condition
Select the Array on the left side - Contains - Responder on the right

If the user who is filling out the form does not belong to the 'Authenticated' list, we Send an Email letting the user know they are unauthorized to fill out this form.
Under the Send an email action, add a Terminate action with Status of Success, this is to ensure the flow stops running, while not throwing an unwanted Failed run

flow-pic3

 

Conclusion

This is a fun and creative way to add some Authentication to your MS forms.

I hope my method helps or inspires someone else!

Thanks for reading

 

Check this post out on my Blog:

FlowAltDelete - MS Forms Authentication

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.