Forum Discussion
Solved
Using Get-PnPListItem without the dreaded ViewTheshold Errors
I am having to deal with a large number of Recycle Bin Items. Title Id ItemType LeafName DirName
----- ...
With a bit of lateral thinking .....I rewrote the code the finds the file . No recursive query = no view threshold errors! Rock and Roll.
$fileFolderItem = Get-PnPFolderItem -FolderSiteRelativeUrl $DirectoryRelativePath -ItemName $Filename $fileFolderItem.Context.Load($fileFolderItem.ListItemAllFields) $fileFolderItem.Context.ExecuteQuery() # now i can do what intended to do.. ($fileFolderItem.ListItemAllFields).SetComplianceTag(......
With a bit of lateral thinking .....I rewrote the code the finds the file . No recursive query = no view threshold errors! Rock and Roll.
$fileFolderItem = Get-PnPFolderItem -FolderSiteRelativeUrl $DirectoryRelativePath -ItemName $Filename
$fileFolderItem.Context.Load($fileFolderItem.ListItemAllFields)
$fileFolderItem.Context.ExecuteQuery()
# now i can do what intended to do..
($fileFolderItem.ListItemAllFields).SetComplianceTag(......
For those reading this later on, query and pagesize together will not work.
$fileItem = Get-PnPListItem -List $Library -Query $query -PageSize 4000
will still prompt for the result limit of 5000
Do this in stead:
$fileItem = Get-PnPListItem -List $Library -PageSize 4000
without the query, and filter the results later.
$fileItem = Get-PnPListItem -List $Library -Query $query -PageSize 4000
will still prompt for the result limit of 5000
Do this in stead:
$fileItem = Get-PnPListItem -List $Library -PageSize 4000
without the query, and filter the results later.