Download SharePoint Online List items Attachments using PnP PowerShell

 Let’s download all attachments from a list. Following script creates a folder for every list object and downloads all attachments to the local disk.

$SiteURL = "https://splearning99.sharepoint.com/sites/testDL" $ListName = "testlist" $DownloadPath = "C:\Temp\" #Connect to SharePoint Online site Connect-PnPOnline -Url $SiteURL -Interactive #Get all List Items $Listitems = Get-PnPListItem -List $ListName -PageSize 500 #Loop through List Items ForEach($Item in $Listitems) { #Get Attachments from Item $Attachments = Get-PnPProperty -ClientObject $Item -Property "AttachmentFiles" #Download All Attachments from List item Write-host "ID '$($Item.ID)', Attachments : $($Attachments.Count)" #Create directory for each list item $DownloadLocation = $DownloadPath+$Item.ID If (!(Test-Path -path $DownloadLocation)) { New-Item $DownloadLocation -type Directory | Out-Null } $Attachments | ForEach-Object { Get-PnPFile -Url $_.ServerRelativeUrl -FileName $_.FileName -Path $DownloadLocation -AsFile -Force } }