$SiteURL= "https://testlz.sharepoint.com/sites/Intern1" Connect-PnPOnline -Url $SiteURL -UseWebLogin $List = Get-PnPList -Identity /doc $Query = " " $ListItems = Get-PnPListItem -List $List -Query $Query #Collect Documents Data $Docs=@() ForEach($Item in $ListItems) { $DocsObject = New-Object -TypeName PSObject $DocsObject | Add-Member -Name 'Library name' -MemberType Noteproperty -Value $List.Title $DocsObject | Add-Member -Name 'FileID' -MemberType Noteproperty -Value $Item.FieldValues['GUID'] $DocsObject | Add-Member -Name 'FileName' -MemberType Noteproperty -Value $Item.FieldValues['FileLeafRef'] $DocsObject | Add-Member -Name 'FileDate' -MemberType Noteproperty -Value $Item.FieldValues['Created'] $DocsObject | Add-Member -Name 'FileURL' -MemberType Noteproperty -Value $Item.FieldValues['FileRef'] $Docs += $DocsObject } $Docs #$Docs | export-csv "D:\report111.csv"