Easy SharePoint PowerShell connection

Run Quick GridViews, jobs and other automated sapio365 tasks that use the SharePoint PowerShell module without the need to log in.

Whenever you use sapio365 to access certain data from SharePoint Online, such as the list of users who have access to a site, a special PowerShell module is needed. You will be asked for authorization credentials the first time you attempt this during a user session.

If you are running any jobs or scheduled Quick GridViews that need this information, the task will fail unless you are at the keyboard to provide this authorization. There is an easy workaround.

You just need to allow sapio365 to provide this authorization using a certificate. You can provide one of your own, or sapio365 can create one for you.

This applies to registered applications used in:

• Elevated sessions

• Role sessions using RBAC credentials

• App sessions

Required steps

1. Switch from secret-based authentication to certificate-based authentication.

2. Enable the application to use Exchange Online PowerShell.

3. In Entra, add the SharePoint API permission 'Sites.Full.Control' to your sapio365 registered application. Give consent.

How to add SharePoint API permission 'Sites.Full.Control' in Entra admin center

In Entra admin center, select the sapio365 application from the registered apps list:

1. Go to API permissions blade.

2. Click Add a permission → select SharePoint.

3. Select Application permissions.

4. Check Sites.Full.Control.All.

5. Click Grant admin consent.