Automating the Provisioning of Selective Teams with Guest Access: Part 2 — Request Storage in SharePoint

When we last left our heroes, we had just finished the creation of an Azure AD App Registration that allows us to utilize the Microsoft Graph to create a Microsoft Team, as well as set its properties. So now we want to create a request intake and storage mechanism, and that’s where SharePoint Online comes in.

SharePoint to the Rescue!

In our current process, we’re going to use a SharePoint custom list to hold our requests. It’s a relatively simple list with a few columns of information. You could just create list columns on-the-fly, or go down the site column → content type path, but either will work.

This list will become your central repository of all requests that have been entered. You could design this list to hold as much or as little data as you need to fulfill your request. For the purposes of this scenario we’ll hold pretty much the bare minimum, like:

  • Title of Team
  • Description
  • Template: Create a Team based on a specific template
  • Visibility: Public or Private
  • Classification: Public, Internal or Confidential
  • Allow Guests: Yes or No
  • Team Owners
  • Team Members

Located here is a spreadsheet that lists out a set of columns that are a good place to start. It can be enhanced afterwards based on what your specific requirements are. For the purposes of our specific scenario today we’re going to use these.

So, create a site, create a custom list, create the relevant columns, and when done, we’ll roll into the next step: creating the Flow to approve and provision a Team with Guest Access on/off.

About the Author:

Michael Mukalian is the Modern Workplace Technical Architect at the Microsoft Technology Center in Philadelphia (Malvern), PA. covering Office 365. He is co-owner of the Tri-State Office 365 User Group (, was a contributing author on the SharePoint 2010 Administrator’s Pocket Consultant, speaks at a number of SharePoint Saturdays and Code Camps around the country and was awarded Microsoft’s MVP award in CY2010 for SharePoint Services. With over 25 years of IT experience and certifications in SharePoint and Office 365, Michael has architected and developed solutions for enterprises of all sizes.


Mukalian, M. (2019). Automating the Provisioning of Selective Teams with Guest Access: Part 2 — Request Storage in SharePoint. Available at: [Accessed: 18th February 2020].

Check out more great Microsoft Teams content here or join our mailing list to stay up to date.

Share this on...

Rate this Post: