<h2>Microsoft SharePoint Online Spoke Personal OAuth Configuration</h2><br/><div style="overflow-x:auto"><style type="text/css"><!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } </style> <div class="ns-kb-css-body-editor-container"> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-family: 'times new roman', times;"><span style="font-size: 26.0pt; line-height: 115%;">Microsoft SharePoint Online Spoke Personal OAuth Configuration</span></span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><span style="font-family: 'times new roman', times; color: rgb(15, 71, 97); font-size: 12pt;"><span style="line-height: 115%;">This document only addresses the areas where changes are needed to use personal OAuth for Microsoft SharePoint Online Spoke. For the remaining settings, please refer <a href="https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/administer/integrationhub-store-spokes/concept/sharepoint-online-spoke.html" target="_blank" rel="noopener noreferrer">Microsoft SharePoint Online Spoke Documentation</a>.</span></span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><span style="font-family: 'times new roman', times;">1. Make sure all the permissions on the Azure side are configured as Delegated (Example):</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /> <img src="/sys_attachment.do?sys_id=bcf58e7f93097a18f2167de86cba10be" width="541" height="190" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;">2. <span style="font-family: 'times new roman', times;">Under Credentials: integration type should be set as personal for both "<strong>MicrosoftSharePointGraph</strong>" and "<strong>MicrosoftSharePointOnline</strong>" Aliases.</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><img src="/sys_attachment.do?sys_id=3cf5ce7f93097a18f2167de86cba1006" width="524" height="115" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><br /><img src="/sys_attachment.do?sys_id=b4f58e7f93097a18f2167de86cba10c5" width="523" height="127" /><br /><br /><span style="font-family: 'times new roman', times;"><strong>Note: Integration Type will only be visible if the application Registry/OAuth Profile “Default Grant Type is set to Authorization Code”.</strong></span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br />3. <span style="font-family: 'times new roman', times;">Application Registry should look like below for both Graph and SharePoint ( for SharePoint, no certificate is needed to configure, as it is only needed if using client credentials type )</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> <span style="font-family: 'times new roman', times;"> 3.1 SharePoint Graph (Example)</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> <img src="/sys_attachment.do?sys_id=38f5ce7f93097a18f2167de86cba100c" width="533" height="250" /><br /><br /><span style="font-family: 'times new roman', times;"> Scope:</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> <br /> <img src="/sys_attachment.do?sys_id=f8f5ce7f93097a18f2167de86cba1009" width="519" height="157" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><span style="font-family: 'times new roman', times;"> 3.2 SharePoint Rest (Example)</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> <br /> <img src="/sys_attachment.do?sys_id=14f50e7f93097a18f2167de86cba10bb" width="524" height="257" /><br /><br /> S<span style="font-family: 'times new roman', times;">cope:</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> <img src="/sys_attachment.do?sys_id=5cf58e7f93097a18f2167de86cba100e" width="521" height="152" /><br /><br /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><span style="font-family: 'times new roman', times;">4. Install the plugin “<strong>Personal Authentication</strong>”.</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /> <img src="/sys_attachment.do?sys_id=b0f58e7f93097a18f2167de86cba10c2" width="524" height="51" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><span style="font-family: 'times new roman', times;">5. Assign the “<strong>sn_personal_auth.personal_auth_user</strong>” role to all users who will access the SharePoint, as this role is required for each user individually.</span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><img src="/sys_attachment.do?sys_id=60f58e7f93097a18f2167de86cba1084" width="523" height="258" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><span style="font-family: 'times new roman', times;">6. <span style="color: black;">For testing purposes, when logged in as a different user and searching for personal integrations, a dashboard will open displaying both Graph and SharePoint options. By selecting Authenticate, the login page will be presented, allowing users to enter their credentials. Each user will then receive a dedicated token, which can subsequently be used to execute actions.</span></span></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><img src="/sys_attachment.do?sys_id=e8f58e7f93097a18f2167de86cba1080" width="523" height="271" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><img src="/sys_attachment.do?sys_id=60f58e7f93097a18f2167de86cba10bc" width="532" height="147" /></p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"> </p> <p style="margin: 0cm 0cm 8pt; line-height: 115%; font-size: 12pt; font-family: Aptos, sans-serif;"><br /><strong><span style="color: black; font-family: 'times new roman', times;">Note: Personal OAuth can only be utilized with flows or subflows executed as the user. Attempting to execute actions directly using Personal OAuth will result in unsuccessful execution.</span></strong></p> <span id="ns-kb-css-end-div-identifier" style="display: none; pointer-events: none;"></span></div></div>