{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":21609,"path":"integrate-applications/integration-hub/sharepoint-online-spoke.md","title":"Microsoft SharePoint Online Spoke","bundle":null,"doc_type":null,"release":"australia","body":"\n# Microsoft SharePoint Online Spoke\n\nThe Microsoft SharePoint Online spoke integrates your ServiceNow® instance with Microsoft SharePoint Online so that you can automate various predefined actions as part of a Workflow. For example, you can rename a folder on Microsoft SharePoint Online when a record in the database is updated.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Integration Hub subscription\n\nThis spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf).\n\n## Spoke version\n\nMicrosoft SharePoint Online spoke v2.11.5 is the latest version. For version history of the spoke, see [Microsoft SharePoint Online spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-sharepoint.html).\n\n**Note:** The Microsoft SharePoint online spokes does not support the On-premise SharePoint.\n\n## Spoke dependencies\n\nIf you’re having trouble installing the app, ensure that these dependent plugins are installed:\n\n-   ServiceNow Integration Hub Runtime \\(com.glide.hub.integration.runtime\\)\n-   ServiceNow Integration Hub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n-   Complex Object \\(com.glide.cobject\\)\n-   ServiceNow Workflow Studio - Dynamic Inputs \\(com.glide.hub.dynamic\\_inputs\\)\n-   ServiceNow Integration Hub Action Step - REST \\(com.glide.hub.action\\_step.rest\\)\n-   ServiceNow Integration Hub Action Template - Data Stream \\(com.glide.hub.action\\_type.datastream\\)\n\n**Note:** Some of these plugins are licensable features and require an appropriate license if used outside the spoke implementation. For information on licenses, contact your account manager.\n\n## Supported versions\n\nMicrosoft SharePoint Application Programming Interface \\(API\\) version v1.\n\n## Spoke flows\n\nThe Microsoft SharePoint Online spoke provides sample flows in the draft state to demonstrate automating the Microsoft SharePoint Online tasks. To customize a sample flow, copy it to a new application scope. The following table shows the available sample flows.\n\n|Flow|Description|\n|----|-----------|\n|New Attachment on Record creates folder, and copies attachment|When an attachment is created in a database table, a folder is created for a knowledge record on the Microsoft SharePoint Online spoke. Then, the attachment is copied to the folder.|\n|Create Site For Knowledge Base|When a knowledge base is created in the database table, the flow creates a site for it on the Microsoft SharePoint Online|\n\n**Note:**\n\n-   If the single sign-on \\(SSO\\) is set up, you can use the action Look Up User Information By Login Name and verify that you're approved to perform the spoke actions.\n-   Flow designers and action designers must ensure that the user authorization checks are performed before the flow or action is executed.\n\n## Spoke subflows\n\nThe Microsoft SharePoint Online spoke provides a sample subflow in the draft state to demonstrate automating Microsoft SharePoint Online tasks. To customize the subflow, copy it to a new application scope.\n\n<table id=\"table_h1n_zft_kfb\"><thead><tr><th>\n\nSubflow\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td>\n\nRemove Then Add A User To A Group\n\n</td><td>\n\nRemoves a user from a Microsoft SharePoint Online group and adds a new user.\n\n</td></tr><tr><td>\n\nDelete Modern Site \\(without O365 Group\\)\n\n</td><td>\n\nDeletes the modern site associated with Non O365 Group \\(communication site\\).\n\n</td></tr><tr><td>\n\nSubmit Modern Site \\(with O365 Group\\) for Deletion\n\n</td><td>\n\nSubmits a modern Site \\(with O365 Group\\) for Deletion.\n\n**Note:** It may take up to 30 minutes for site to move under deleted sites section of SharePoint Admin portal.\n\n</td></tr></tbody>\n</table>**Note:** Flow designers and action designers must ensure that user authorization checks are performed before the flow or action is executed.\n\n## Spoke actions\n\nThe Microsoft SharePoint Online spokeprovides actions to automate various Microsoft SharePoint Online tasks that are based on the triggers in the ServiceNow instance.\n\nYou can perform some actions by using the SharePoint Online connection and the remaining actions by using the SharePoint Graph connection.\n\nThe actions in the following table use the SharePoint Online connection and the credential alias record.\n\n<table id=\"table_gsq_2gt_kfb\"><thead><tr><th colspan=\"3\">\n\nActions using the **Sharepoint Online** connection and credential alias record\n\n</th></tr><tr><th>\n\nCategory\n\n</th><th>\n\nAction\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td rowspan=\"10\">\n\nSite Management\n\n</td><td>\n\nCreate Modern Site\n\n</td><td>\n\nCreates a modern site of types Communication sites and Non-group associated Team Sites.\n\n</td></tr><tr><td>\n\nCreate Subsite\n\n</td><td>\n\nCreates a subsite on Sharepoint Online. The Tenant determines the root location.\n\n</td></tr><tr><td>\n\nDelete Modern Site\n\n</td><td>\n\nDeletes the modern site associated with non-O365 Group \\(communication site\\).\n\n</td></tr><tr><td>\n\nDelete Subsite\n\n</td><td>\n\nRemoves a subsite from Sharepoint Online. The Connection URL used determines what is the Root location.\n\n</td></tr><tr><td>\n\nLook up Modern Site Information\n\n</td><td>\n\nRetrieves details of a modern site.\n\n</td></tr><tr><td>\n\nLook up Changes For Site\n\n</td><td>\n\nRetrieves the changes for a site that is based on the query conditions.\n\n</td></tr><tr><td>\n\nLook up Role Assignments\n\n</td><td>\n\nRetrieves all the role assignments that are defined on the site.\n\n</td></tr><tr><td>\n\nLook Up Site Collection ID\n\n</td><td>\n\nLooks up a specific site ID.\n\n</td></tr><tr><td>\n\nLook Up Subsite Details\n\n</td><td>\n\nLooks up information about a subsite.\n\n</td></tr><tr><td>\n\nUpdate Site Information\n\n</td><td>\n\nUpdates a Microsoft SharePoint Online site.\n\n</td></tr><tr><td rowspan=\"10\">\n\nFolder Management\n\n</td><td>\n\nCreate Folder\n\n</td><td>\n\nCreates a folder in a document library on a Microsoft SharePoint Online site.\n\n</td></tr><tr><td>\n\nDelete Folder\n\n</td><td>\n\nDeletes a folder in Microsoft SharePoint Online.**Note:** You receive no warning or notification before the folder is removed.\n\n</td></tr><tr><td>\n\nList Files In A Folder\n\n</td><td>\n\nGets a list of files in a folder.\n\n</td></tr><tr><td>\n\nList Folders In A Folder\n\n</td><td>\n\nGets a list of the folders in a folder.\n\n</td></tr><tr><td>\n\nLook Up Folder\n\n</td><td>\n\nLooks up a folder in Microsoft SharePoint Online and returns its properties. For example, the output can contain the property \"Relative URL\".\n\n</td></tr><tr><td>\n\nRename A Folder\n\n</td><td>\n\nRenames a folder in Microsoft SharePoint Online.\n\n</td></tr><tr><td>\n\nShare Folder With Group\n\n</td><td>\n\nShares a folder with a group in Microsoft SharePoint Online. The group must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nShare Folder With User\n\n</td><td>\n\nShares a folder with a user inMicrosoft SharePoint Online. The user must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nUnshare Folder With Group\n\n</td><td>\n\nRemoves the access to a folder from a group. The group must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nUnshare Folder With User\n\n</td><td>\n\nRemoves the access to a folder from a user. The user must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td rowspan=\"13\">\n\nFile Management\n\n</td><td>\n\nAttach Sharepoint File To A Record\n\n</td><td>\n\nAttaches a Microsoft SharePoint Online file to a ServiceNow record.\n\n</td></tr><tr><td>\n\nCheck-in File\n\n</td><td>\n\nSets a file in the Microsoft SharePoint Online in the checked in state. To find the version number of the file after its state is set to checked in, use the Look Up File Details action,**Note:** The file is already uploaded and the action just updates the status of the file to be checked in.\n\n</td></tr><tr><td>\n\nCheck-out File\n\n</td><td>\n\nSets a file in the Microsoft SharePoint Online in the checked out state. To find the version number of the file after its state is set to checked out, use the Look Up File Details action,**Note:** The file is already downloaded and the action just updates the status of the file to checked out.\n\n</td></tr><tr><td>\n\nCopy Attachment To Folder\n\n</td><td>\n\nCopies a ServiceNow attachment to a Microsoft SharePoint Online folder.\n\n</td></tr><tr><td>\n\nCopy File\n\n</td><td>\n\nCopies a file with a new name.\n\n</td></tr><tr><td>\n\nCreate A Text File\n\n</td><td>\n\nCreates a text file with the information that you provide.\n\n</td></tr><tr><td>\n\nDelete File\n\n</td><td>\n\nDeletes a file in Microsoft SharePoint Online.\n\n</td></tr><tr><td>\n\nLook Up File Details\n\n</td><td>\n\nLooks up the file details in Microsoft SharePoint Online.\n\n</td></tr><tr><td>\n\nMove File\n\n</td><td>\n\nMoves a file to another location in Microsoft SharePoint Online.\n\n</td></tr><tr><td>\n\nShare File With Group\n\n</td><td>\n\nShares a file with a group inMicrosoft SharePoint Online. The group must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nShare File With User\n\n</td><td>\n\nShares a file with a Microsoft SharePoint Online user. The user must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nUnshare File With Group\n\n</td><td>\n\nRemoves the access to a file from a Microsoft SharePoint Online group. The group must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td>\n\nUnshare File With User\n\n</td><td>\n\nRemoves the access to a file from a Microsoft SharePoint Online user. The user must belong to the Microsoft SharePoint Online tenant account.\n\n</td></tr><tr><td rowspan=\"3\">\n\nUser Management\n\n</td><td>\n\nLook Up User Information By Login Name\n\n</td><td>\n\nSearches a Microsoft SharePoint Online site for information on a user and returns the information.\n\n</td></tr><tr><td>\n\nLook Up User Information By Email\n\n</td><td>\n\nSearches the specified Microsoft SharePoint Online site for a given user and return SharePoint information about that account.\n\n</td></tr><tr><td>\n\nLook Up User's Sharepoint Groups\n\n</td><td>\n\nSearches the Microsoft SharePoint Online site for information on all groups that a user is a member of and returns the information.\n\n</td></tr><tr><td>\n\nSearch Management\n\n</td><td>\n\nLook up Search Query Results Stream\n\n</td><td>\n\nSearches the SharePoint Root site and retrieves the result based on the provided search query.\n\n</td></tr><tr><td rowspan=\"9\">\n\nGroup Management\n\n</td><td>\n\nAdd Role To Site\n\n</td><td>\n\nAdds a role to a Microsoft SharePoint Online user or group.\n\n</td></tr><tr><td>\n\nAdd User To Group\n\n</td><td>\n\nAdds a user to a Microsoft SharePoint Online site group.\n\n</td></tr><tr><td>\n\nCreate Group\n\n</td><td>\n\nCreates a group in a Microsoft SharePoint Online site.\n\n</td></tr><tr><td>\n\nDelete Group\n\n</td><td>\n\nDeletes a group on a Microsoft SharePoint Online site.\n\n</td></tr><tr><td>\n\nLook Up Group By Name\n\n</td><td>\n\nLooks up a group by its name in a site location in the Microsoft SharePoint Online. If no site location is specified, the action searches the root site of the tenant.\n\n</td></tr><tr><td>\n\nRemove Role From Site\n\n</td><td>\n\nRemoves permissions from a group or a user.\n\n</td></tr><tr><td>\n\nRemove User From Group\n\n</td><td>\n\nRemoves a user from a Microsoft SharePoint Online site group.\n\n</td></tr><tr><td>\n\nUpdate Group Owner \\(User\\)\n\n</td><td>\n\nUpdates a user as the group owner.\n\n</td></tr><tr><td>\n\nLook up M365 Members by Site Group\n\n</td><td>\n\nRetrieves a list of the users and M365 groups associated with a Microsoft SharePoint Online Site Group.\n\n</td></tr><tr><td rowspan=\"6\">\n\nList Management\n\n</td><td>\n\nCreate List\n\n</td><td>\n\nCreates a list in a Microsoft SharePoint Online site with its title and description.\n\n</td></tr><tr><td>\n\nCreate List Subscription\n\n</td><td>\n\nCreates a webhook subscription for a list.\n\n</td></tr><tr><td>\n\nDelete List By ID\n\n</td><td>\n\nDeletes a list in a Microsoft SharePoint Online site by its ID.\n\n</td></tr><tr><td>\n\nLook Up List Details By ID\n\n</td><td>\n\nLooks up a list in a Microsoft SharePoint Online site by its ID.\n\n</td></tr><tr><td>\n\nLook Up List ID By Title\n\n</td><td>\n\nLooks up a list in a Microsoft SharePoint Online by its title.\n\n</td></tr><tr><td>\n\nUpdate list in a site by ID\n\n</td><td>\n\nUpdates a list in a Microsoft SharePoint Online site by its ID.\n\n</td></tr><tr><td rowspan=\"5\">\n\nList Item Management\n\n</td><td>\n\nCreate List Item\n\n</td><td>\n\nCreates a list item inside a list.\n\n</td></tr><tr><td>\n\nDelete List Item By ID\n\n</td><td>\n\nDeletes a list item by both the list ID and the list item ID.\n\n</td></tr><tr><td>\n\nLook Up List Item By ID\n\n</td><td>\n\nLooks up a list item by both the list ID and the list item ID.\n\n</td></tr><tr><td>\n\nLook Up List Items In A List\n\n</td><td>\n\nGets a list of items from a list in different formats.\n\n</td></tr><tr><td>\n\nUpdate List Item By ID\n\n</td><td>\n\nUpdates a list item title by its ID.\n\n</td></tr></tbody>\n</table>**Note:** Flow designers and action designers must ensure that user authorization checks are performed before the flow or action is executed.\n\nThese actions use the SharePoint Graph connection and credential alias record:\n\n<table id=\"table_idq_ysc_xpb\"><thead><tr><th colspan=\"3\">\n\nActions using the **SharePoint Graph** connection and credential alias record\n\n</th></tr><tr><th>\n\nCategory\n\n</th><th>\n\nAction\n\n</th><th>\n\nDescription\n\n</th></tr></thead><tbody><tr><td rowspan=\"3\">\n\nChange Management\n\n</td><td>\n\nGet Change Query Properties\n\n</td><td>\n\nRetrieves the change query properties that are used to define a query that is performed against the change log.\n\n</td></tr><tr><td>\n\nGet Delta Link Token For Drive\n\n</td><td>\n\nRetrieves the latest delta link token for a drive.\n\n</td></tr><tr><td>\n\nGet Next Token\n\n</td><td>\n\nRetrieves the next link token from the SharePoint Resource Next Link Token table.\n\n</td></tr><tr><td rowspan=\"3\">\n\nFile Management\n\n</td><td>\n\nGet File Download Link\n\n</td><td>\n\nRetrieves the download URL of the file.\n\n</td></tr><tr><td>\n\nLook up File Permissions\n\n</td><td>\n\nGets the permissions for a file.\n\n</td></tr><tr><td>\n\nLook up Files\n\n</td><td>\n\nRetrieves all the files in a drive.\n\n</td></tr><tr><td rowspan=\"5\">\n\nList Management\n\n</td><td>\n\nCreate List Subscription\n\n</td><td>\n\nCreates a webhook subscription for a list.\n\n</td></tr><tr><td>\n\nRenew List Subscription\n\n</td><td>\n\nRenews a webhook subscription for a list.\n\n</td></tr><tr><td>\n\nDelete List Subscription\n\n</td><td>\n\nDeletes the webhook subscription for a list.\n\n</td></tr><tr><td>\n\nGet List\n\n</td><td>\n\nRetrieves the details of a list from the SharePoint tenant.\n\n</td></tr><tr><td>\n\nLook up Drives\n\n</td><td>\n\nRetrieves all the drives for a site.\n\n</td></tr><tr><td rowspan=\"7\">\n\nSite Management\n\n</td><td>\n\nDelete Modern Site with O365 Group\n\n</td><td>\n\nSubmit the modern site associated with the O365 Group \\(team site\\) for deletion. It deletes the associated 0365 group that deletes the site. **Note:** After execution, it can take up to 30 minutes for a site to be deleted.\n\n</td></tr><tr><td>\n\nLook up Modern Site Group Information\n\n</td><td>\n\nRetrieves the associated O365 group details of a modern site \\(team site\\).\n\n</td></tr><tr><td>\n\nLook up Site Collections\n\n</td><td>\n\nRetrieves all the site collections.\n\n</td></tr><tr><td>\n\nLook up Subsites\n\n</td><td>\n\nRetrieves details of all the subsites in a site.\n\n</td></tr><tr><td>\n\nCreate Root Site Subscription\n\n</td><td>\n\nCreates a webhook subscription for a root site.\n\n</td></tr><tr><td>\n\nLook up Site Permissions\n\n</td><td>\n\nRetrieves all permissions for a site.\n\n</td></tr><tr><td>\n\nGet Site\n\n</td><td>\n\nGets the site details.\n\n</td></tr></tbody>\n</table>## Available AI agents\n\nInstall Now Assist for Integration Hub and start using the available AI agents. For more information, see [ServiceNow Otto for Integration Hub](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/now-assist-spokes.md).\n\nThis spoke provides standalone AI agents that mimic human-like intelligence to perform tasks in your ServiceNow instance.\n\n-   In the ServiceNow agentic system, you can create an agentic workflow that comprises of a set of large language model \\(LLM\\) instructions along with one or more standalone AI agents to execute an objective. See [Create an agentic workflow](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/configure-use-case-ai-agents.md) for information about adding AI agents to create agentic workflows as per your requirement and provide the required trigger.\n\n    You can also search for other available AI agents and add them to your agentic workflow. See [Find AI agents](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/find-ai-agents.md) for more information.\n\n-   You can create a clone of the required spoke AI agent and customize it as per your requirement. See [Duplicate an AI agent](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/clone-ai-agent.md) for more information about creating a clone.\n-   See [AI Agent Studio \\(legacy\\)](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/na-ai-agents.md) for information about AI agents.\n\nAvailable AI agents include:\n\n|AI agent|Description|\n|--------|-----------|\n|Microsoft SharePoint Online file management AI agent|Automates file-related tasks such as, sharing files with users or groups, copying files, moving files, creating text files, retrieving file details, and managing file permissions.|\n|Microsoft SharePoint Online list management AI agent|Automates SharePoint operations such as, managing lists, creating and renewing subscriptions, retrieving list details, and automating workflows.|\n|Microsoft SharePoint Online site management AI agent|Automates SharePoint operations such as, creating and deleting sites, managing site collections, retrieving site information, and automating SharePoint workflows.|\n|Microsoft SharePoint Online group management AI agent|Automates group management processes such as, adding or removing users from groups, creating or deleting groups, updating group ownership, and managing roles within SharePoint sites.|\n|Microsoft SharePoint Online list item management AI agent|Automates SharePoint operations such as, creating, updating, deleting, and retrieving list items.|\n|Microsoft SharePoint Online user management AI agent|Automates user management tasks such as, a retrieving user's SharePoint groups, user information by login name, and user details by email.|\n|Microsoft SharePoint Online folder management AI agent|Automates folder management tasks such as, renaming folders, creating folders, sharing and unsharing folders with users or groups, listing files and folders, and deleting folders.|\n|Microsoft SharePoint Online change management AI agent|Perform the Get Next Token and Get Delta Link Token For Drive actions.|\n|Microsoft SharePoint Online search management AI agent|Retrieves the required search query results and enables users to streamline processes.|\n\nThere might be AI agents installed on your instance that are not used in agentic workflows. To learn how to see all agents that are available to you, see [Find AI agents](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/intelligent-experiences/find-ai-agents.md).\n\n**Note:** Ensure that the user running an AI agent has the required roles and permissions to access data or perform operations on data in the table that is associated with the AI agent.\n\n## SharePoint Online account requirements\n\nThe Microsoft SharePoint Online spoke requires that you create a custom app on your SharePoint Online account to generate OAuth 2.0 tokens. See [Configure OAuth application in Microsoft Azure](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/configure-oauth-application-in-microsoft-azure.md).\n\n## Connection and credential alias requirements\n\nIntegration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection.\n\n-   **Single tenant**\n\n    This spoke includes the MicrosoftSharepointOnline alias record to authorize actions on Microsoft SharePoint Online. Select this alias in the Tenant record to authorize changes in Microsoft SharePoint Online for a single tenant.\n\n-   **Multiple tenants**\n\n    This spoke includes the MicrosoftSharepointOnline alias record to authorize actions on Microsoft SharePoint Online. Create a connection and credential alias record for each additional tenant site that you want to support. Select the correct alias in the Tenant record to authorize changes in Microsoft SharePoint Online. Create a connection and credential alias record for each additional tenant site that you want to support. Select the correct alias in the Tenant record to authorize changes in Microsoft SharePoint Online. See [Create aliases for multiple tenants](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/integration-hub/create-aliases-sharepoint.md).\n\n\n**Note:**\n\nThree alias records are available by default with the spoke; Sharepoint Online, SharePoint Graph, and SharePoint Graph Root Site Subscription. Each alias record requires a tenant to be associated with it. If you intend to use all SharePoint Online, Graph, and Root Subscription actions in the spoke, you must ensure that you have created three tenant records in the Tenants tables of the Microsoft SharePoint Online spoke so that each tenant record is associated with its respective alias record.\n\n-   If configuring an integration for a single tenant, use the existing **MicrosoftSharepointOnline** alias record.\n-   You can use multiple tenants with the **Microsoft SharePoint Graph** connection alias only.\n\n"}}