Skip to content

Kusi's Knowledgebase

PnP

Kusi's Knowledge Base¶

M365 PnP¶

Install PnP PowerShell¶

Install-Module -Name PnP.PowerShell -Force

Connect to Site Collection¶

Connect-PnPOnline -Url https://<url> -Interactive

Register-PnPAzureADApp -ApplicationName "PnPPowerShell" -Store CurrentUser -Tenant <Tenant>.onmicrosoft.com -Interactive
Connect-PnPOnline -Url https://<url> -ClientId <ClientId> -Thumbprint <Thumbprint> -Tenant <Tenant>.onmicrosoft.com

Query more than 5000 elements¶

Connect-PnPOnline ...
$ctx = Get-PnPContext
$ctx.Load($listTitle)
$ctx.ExecuteQuery()

$query = New-Object Microsoft.SharePoint.Client.CamlQuery
$query.ViewXml = "<View Scope='RecursiveAll'><Query><Where></Where></Query><RowLimit Paged='TRUE'>500</RowLimit></View>"
$query.AllowIncrementalResults = $true

Do
{
    $listItems = $list.GetItems($query)
    $ctx.Load($listItems)
    $ctx.ExecuteQuery()
    if ($listItems.count -gt 0) {
        $listItems |% {
            Write-Host $_.FieldValues.FileRef 
        }
    }
    $query.ListItemCollectionPosition = $listItems.ListItemCollectionPosition           
}
While($query.ListItemCollectionPosition -ne $null)