Getting 'created by' for a folder in Sharepoint document library

Question

I want to get the author(who created) a folder in a Sharepoint Online using PnP PowerShell. The time last modified I can get it, but the field author I cannot get it. I know that can be two different fields, author and modifier, but I cannot get any from this.

For the folders:

$folder = Get-PnPFolderItem -FolderSiteRelativeUrl $folderPath -ItemName $subfolderName
Write-Host "URL      : " $folder.ServerRelativeUrl
Write-Host "Name     : " $folder.Name
Write-Host "Modified : " $folder.TimeLastModified
# above are ok, but $folder has no author property
# same next line fails, Author it does not exist
$folder= Get-PnPFolder -Url "$folderPath/$subfolderName" -Includes ListItemAllFields.Author

For the files, is easy I use:

Get-PnPFile -ServerRelativeUrl $file.ServerRelativeUrl -Path $destinationfolder -FileName $file.Name -AsFile
$f = Get-PnPFile  -Url "$($folderUrl)/$($file.Name)" -AsListItem
$fileDetails = @{            
    File = "$($destinationFolder)/$($file.Name)"
    Author = $f["Author"].Email
    Created = $f["Created"]
}

M Constantin M Constantin · Accepted Answer · 2019-08-07T06:20:32

I just find the solution, if anyone need:

context = Get-PnPContext
$context.load($context.Web)
$context.ExecuteQuery()
$list = $context.Web.Lists.GetByTitle("Documente")
$context.Load($list)
$context.ExecuteQuery()
$camlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
$camlQuery.ViewXml ="<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='FileRef' /><Value Type='Text'>/server/folder/relativepath</Value></Eq></Where></Query></View>";
$allItems=$list.GetItems($camlQuery)
$context.Load($allItems)
$context.ExecuteQuery()

foreach($item in $allItems){
   Write-Host "##############"
   Write-Host $item["FileRef"]
   $item["Author"].Email
   $item["Modified"]
}

Getting 'created by' for a folder in Sharepoint document library

1 Answers