ServiceNow to Microsoft SharePoint Online Integration – Automated Site Creation

Priti_S
Tera Expert

‎06-30-2025 09:28 PM

Hi Everyone!
I recently integrate ServiceNow with Microsoft SharePoint Online using Flow Designer and the Microsoft SharePoint Online Spoke. The goal was to automate site creation based on a catalog request and assign users to the correct SharePoint groups (Owners, Members, Visitors).
Objective

  • Create SharePoint sites automatically from ServiceNow
  • Assign users to SharePoint groups dynamically
  • Fully automate the process via Flow Designer

 Prerequisites

 Flow Designer Steps & Actions Used
1. Create Site
Action: Create Modern Site – SharePoint Online

  • Inputs:
  • Tenant
  • Site Title – From catalog request
  • Site URL – https://<tenant>.sharepoint.com/sites/<SiteTitle>
  • Template – e.g., STS#3 for a Team Site
  • Description – Purpose of the site
  • Owner – Primary site owner (email)

2. Look Up User Information by Email
Action: Look Up User Information By Email – SharePoint Online

  • Inputs:
  • Tenant
  • Email – User’s email address
  • Output:
  • User Login Name – Used in group assignment step

3. Add User to SharePoint Group
Action: Add User to Group – SharePoint Online

  • Inputs:
  • Tenant
  • Site Location – sites/<SiteTitle>
  • User Login Name – From previous step
  • Group ID:
  • 3 for Owners
  • 4 for Visitors
  • 5 for Members

 Outcome
With this integration:

  • Users can request SharePoint sites from a catalog item
  • Sites are created automatically
  • Access is provisioned instantly (Owners, Members, Visitors)

Thank You!

  • 4,409 Views
10 REPLIES 10

basava11
Giga Contributor
In response to Shashank Saxen2

3 weeks ago

Thanks Shashank. Now I have the same error like you. It worked for me once and then I'm trying again with same configuration and credentials, but failing. It is frustrating to see that working flow is failing no much information.
{"odata.error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"}}}

0 Helpfuls