[BUG] Restore-PnPRecycleBinItem: The Attempted operation is prohibited because it exceeds the list view threshhold

[365gitsupport]

Hi

We are currently having a problem regarding recovering deleted files from the recyclebin and second stage recycle bin.

When we run the command: Get-PnPRecycleBinItem -RowLimit 200000 | ? {($.DeletedDate -gt $date2 -and $.DeletedDate -lt $date1)} | Restore-PnPRecycleBinItem -Force -RowLimit 200000

We get the error

We have been in contact with MS Support and they told us to restore them in a batch and that didn't help either, we got the same error code as before.

The amount of files we are restoring are around 160 000 files.

1. Are you using Invoke-PnPSiteTemplate or Get-PnPSiteTemplate? The issue is most likely related to the Provisioning Engine. The Provisioning engine is not located in the PowerShell repo. Please report the issue here: https://github.com/pnp/pnpframework/issues.
2. Is the issue related to the cmdlet itself, its parameters, the syntax, or do you suspect it is the code of the cmdlet that is causing the issue? Then please continue reporting the issue in this repo.
3. If you think that the functionality might be related to the underlying libraries that the cmdlet is calling (We realize that might be difficult to determine), please first double check the code of the cmdlet, which can be found here: https://github.com/pnp/powershell/tree/master/src/Commands. If related to the cmdlet, continue reporting the issue here, otherwise report the issue at https://github.com/pnp/pnpframework/issues

Reporting an Issue or Missing Feature

Please confirm what it is that your reporting

It is an issue

Expected behavior

Please describe what output you expect to see from the PnP PowerShell Cmdlets

To be able to recover deleted files from the recyclebin and second stage recyclebin

Actual behavior

Please describe what you see instead. Please provide samples of output or screenshots.

We get the error The Attempted operation is prohibited because it exceeds the list view threshhold

Steps to reproduce behavior

Please include complete script or code samples in-line or linked from gists

Connect-PnPOnline -Url https://customer.sharepoint.com/ -UseWebLogin
$today = (Get-Date)
$date1 = $today.date.addDays(-77)
$date2 = $today.date.addDays(-81)
Get-PnPRecycleBinItem -RowLimit 200000 | ? {($.DeletedDate -gt $date2 -and $.DeletedDate -lt $date1)} | Restore-PnPRecycleBinItem -Force -RowLimit 200000

What is the version of the Cmdlet module you are running?

(you can retrieve this by executing Get-Module -Name "PnP.PowerShell" -ListAvailable)

Which operating system/environment are you running PnP PowerShell on?

• Windows
• Linux
• MacOS
• Azure Cloud Shell
• Azure Functions
• Other : please specify

[gautamdsheth]

Closed as fixed via #2472

[VonGlitch]

This ain't fixed! I have a site collection with 390k items that need restoring. I can't even restore them individually with Restore-PnPRecycleBinItem. All I get is "The attempted operation is prohibited because it exceeds the list view threshold."

One by one, batches of 200, -RowLimit or not, -Force or not ... same error.

I've tried PnP.PowerShell versions 1.10, 1.11, 1.12 and even the new 2.1.1 --- all of them broken!!

I can use Restore-PnPRecycleBinItem on sites that have fewer than 5,000 items in the recycle bin, but not where I need to use it most!

[tylamb1]

I am also having issues. I have installed the latest version. The code I am using is

$today = (Get-Date)
$restoreDateStart = $today.date.AddDays(-19)
$restoreDateEnd = $restoreDateStart.AddHours(23.99999)
$date_string = Get-Date -UFormat "%Y%m%d.%H%M%S"
$currentSet = Get-PnPRecycleBinItem | ? {($_.DeletedDate -gt $restoreDateStart) -and ($_.DeletedDate -lt $restoreDateEnd) -and ($_.DeletedByEmail -eq 'email@address.com')} | select -last 100
$currentSet | Export-Csv ".\robin.files.restore.$date_string.csv"
$currentSet | Restore-PnpRecycleBinItem -Force

I can export $currentSet and have 100 items in the file but I can not restore them. I get the error in red text.

"Restore-PnPRecycleBinItem: The attempted operation is prohibited because it exceeds the list view threshold."

I've also tried adding the RowLimit on there without luck, same error.
$currentSet | Restore-PnpRecycleBinItem -Force -RowLimit 10

[ReedME]

I too am experiencing this same issue.

[MrRCG5]

This is NOT working for me:
$restore | Restore-PnPRecycleBinItem -Force

I get the following error:
Restore-PnPRecycleBinItem : The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the parameters that take pipeline input.

This worked:

$restore = Get-PnPRecycleBinItem -RowLimit 500000 | Select Title, Id | Where { $_.Title -like "*ABC*" } | Select Title, Id

foreach ($r in $restore) {
$id = $r.Id
Restore-PnPRecycleBinItem -Identity "$id" -Force
}