Using Get-PnPListItem without the dreaded ViewTheshold Errors

Question

&nbsp;I am having to deal with a large number of Recycle Bin Items.&nbsp;&nbsp;&nbsp;Title                                Id                                   ItemType LeafName       DirName
-----                                --                                   -------- --------       -------
DeleteMe1.docx                       887caa93-7178-4f41-8a28-cbe6e3c36067 File     DeleteMe1.docx personal/daniel_westerdale_myclient_co_uk/Documents/GDPR/test&nbsp;&nbsp;&nbsp;&nbsp;This is all well and good but try located the file once this has been restored from the Recycle Bin in order to set the compliance tag properties.&nbsp;This doesn't give me anything I can use to locate the file item directly using&nbsp; Get-PnpListItem&nbsp;&nbsp;&nbsp;$fileItem = Get-PnPFolderItem -FolderSiteRelativeUrl "Documents/GDPR/test" -ItemName  DeleteMe1.docx&nbsp;&nbsp;&nbsp;Indeed, thought I could use the&nbsp; uniqueID as shown in the documentation ...&nbsp;&nbsp;Get-PnpListItem -List Documents -UniqueId $fileItem.UniqueId&nbsp;&nbsp;The result is null !&nbsp;&nbsp;&nbsp;Using another approach,&nbsp; I can use this approach but I am hitting those aforementioned ViewThreshold errors . As my friend&nbsp;@garytrinder pointed out this is because FileLeafRef is not indexed.&nbsp;&nbsp;&nbsp;$file$query = "&lt;View Scope='RecursiveAll'&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='FileLeafRef'/&gt;&lt;Value Type='File'&gt;$filename&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;RowLimit Paged='TRUE'&gt;4000&lt;/RowLimit&gt;&lt;/View&gt;"
$fileItem = Get-PnPListItem -List $Library -Query $query -PageSize 4000
            &nbsp;&nbsp;&nbsp;&nbsp;I wonder if there is a clever way to locate the integer&nbsp; Id&nbsp; , so I can go directly to the fileItem, now wouldn't that be so much easier....&nbsp;&nbsp;

daniel westerdale · Accepted Answer

With a bit of lateral thinking .....I rewrote the code the finds the file . No recursive query = no view threshold errors! Rock and Roll.&nbsp;&nbsp; $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(......&nbsp;&nbsp;

Forum Discussion

Using Get-PnPListItem without the dreaded ViewTheshold Errors

Share

Resources