Credential Management

PnP PowerShell is the ultimate library to execute cmdlets unattended in scripts, Azure Functions or Azure Automation

However, in order to automate authentication you need to be able to safely store these credentials. You should -never- store them in your scripts.

We currently recommend the Microsoft provided Secret Management and Secret Store modules to set up a vault which PnP PowerShell can use to store and retrieve credentials.

Install the required modules

Install-Module -Name "Microsoft.PowerShell.SecretManagement" -AllowPrerelease
Install-Module -Name "Microsoft.PowerShell.SecretStore" -AllowPrerelease

Configuring the vault

After installing the module you will be have create and register a vault:

Register-SecretVault -Name "SecretStore" -ModuleName "Microsoft.PowerShell.SecretStore" -DefaultVault
Set-SecretStoreConfiguration -Authentication None

The last cmdlet, where you set the authentication to None means that you will allow access to the secret store without requiring you to enter a password to unlock the vault. This is optional obviously. Notice that you will be asked several times to provide a password the moment you create a new vault. If you intend to you use the native out of the box functionality of PnP PowerShell with the Secret Management modules notice that the authentication is required to set to None.

Adding a secret

Secret Management Module

Set-Secret -Name [yourlabel] -Secret (Get-Credential)

PnP PowerShell

Add-PnPStoredCredential -Name [yourlabel] -Username [username]

you will be prompted to provide a password.

Retrieving a secret

Secret Management Module

Connect-PnPOnline -Url https://yourtenant.sharepoint.com -Credentials (Get-Secret -Name [yourlabel])

PnP PowerShell

Connect-PnPOnline -Url https://yourtenant.sharepoint.com -Credentials [yourlabel]

Advanced usage of secrets

You can add a secret with a label that reflects your tenant url, e.g.

Set-Secret -Name "https://yourtenant.sharepoint.com" -Secret (Get-Credential)

Now you can simply do this:

Connect-PnPOnline -Url "https://yourtenant.sharepoint.com"

PnP PowerShell will check the vault if a secret is present with the label matching the URL and it will use those credentials. Notice that a URL alike https://yourtenant.sharepoint.com/sites/demo will also match the secret. You can create multiple secrets too. PnP PowerShell will then try to match the most complete label first, e.g. a secret ending on /sites/demo1 will proceed the one without that ending.

Removing a secret

Secret Management

Remove-Secret -Name [yourlabel] -Vaultname [VaultName]

PnP PowerShell

Remove-PnPStoredCredential -Name [yourlabel]