ServiceNow to Microsoft SharePoint Online Integration – Automated Site Creation

[Priti_S]

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

• Install and configure the Microsoft SharePoint Online Spoke
• Set up the connection record with the SharePoint tenant
• Refer to:
• Microsoft SharePoint Online Spoke Documentation
• Configure Microsoft SharePoint Online Connection

 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!

[abhisheknirwani]

Have you implemented with using Sites.FullControl.All role as security team is not allowing us to use the role.

[Priti_S]

Hi @abhisheknirwani 
Yes, I implemented this using the Sites.FullControl.All application permission, as it is required for the SharePoint Online Spoke actions I used.

[abhisheknirwani]

Hi @Priti_S 
Thank you, Can you help me if there is any workaround using other role to create sites. 
Any alternative way to do it.

Thanks in advance

[basava11]

@Priti_S, I'm having errors while adding 2nd owner to sharePoint modern site creation workflow. It says, "The user does not exist or is not unique." even though user exists in IdP and also in users table in ServiceNow.

[Shashank Saxen2]

@basava11  I'm facing the same issue as well, except I'm receiving the following error:

"Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"

What's more confusing is that the "Add User to Group" action works consistently when executed independently using the same input parameters. However, when the exact same parameters are passed through the flow, it fails with the above error.

I've also raised a case with ServiceNow Support, but they have not been able to identify the root cause yet.

@Shreya Shah , could you please help look into this? I'm using the same set of actions that @Priti_S  described in the article above.