Forum Discussion

Redbaron99's avatar
Redbaron99
Copper Contributor
Mar 27, 2022
Solved

Restore all files but ones that already exist from the recycle bin using PowerShell

Hello, I have a client that I am working with that had a slight mix-up that lead to many duplicate files being created and then deleted (along with others that they need restored), there are 10,000...
powershell
sharepoint
  • Redbaron99's avatar
    Redbaron99
    Apr 06, 2022

    Thank you for your patience, and help. I was able to figure out the issue. The "(Get-Date)" string applies a time to it, thus, making it fail. I worked around it by using a date range instead. The following cmdlet solved the issue:

     

    Install-Module -Name PnP.PowerShell
    Import-Module PnP.PowerShell
    connect-pnponline -url *sharepoint site URL* -interactive

    $date1 = (Get-Date).date.AddDays(-5)
    $date2 = (Get-Date).date.AddDays(-6)

    Get-PnPRecycleBinItem | ForEach-Object {
    $dir = $_.DirName
    $title = $_.Title
    $path = "$dir/$title"
    $deletedDate = $_.DeletedDate

    $fileExists = Get-PnPFile -url $path -ErrorAction SilentlyContinue

    if ($fileExists) {
    Write-Host "$title exists"
    } else {
    Write-Host "$title doesn't exist"
    if ($deletedDate -gt $date2 -and $deletedDate -lt $date1) {
    Write-host "$title is equal to $date2 and will be restored"
    $_ | Restore-PnpRecycleBinItem -Force -ErrorAction SilentlyContinue
    } else {
    Write-Host "$title is not equal to $date2 and will not be restored"
    }
    }
    }

     

Leavii's avatar
Leavii
Brass Contributor
Mar 28, 2022

 

Redbaron99 

 

Hello,

I assume you are meaning from SharePoint Recycle bin.

I quickly threw together a site, files, and this script and it worked when I deleted files and restored them. I included some resources as well so you could make a better/cleaner script for your need.

 

 

connect-pnponline -url https://your.sharepoint.com/ -interactive

$recycleBin = Get-PnPRecycleBinItem

$recycleBin | ForEach-Object {
    $dir = $_.DirName
    $title = $_.Title
    $path = "$dir/$title"

    $fileExists = Get-PnPFile -url $path -ErrorAction SilentlyContinue

    if ($fileExists) {
        Write-Host "$title exists"
    } else {
        Write-Host "$title Restoring"
        $_ | Restore-PnpRecycleBinItem -Force
    }
}

Read-Host "Done"

 

 

Sources
https://www.sharepointdiary.com/2019/02/sharepoint-online-powershell-to-restore-deleted-items-from-recycle-bin.html#:~:text=SharePoint%20Online%3A%20Restore%20Deleted%20Items%20from%20Recycle%20Bin,to%20restore%20and%20click%20the%20%22Restore%20Selection%22%20link.

https://github.com/joseinazusa/powershell-recursive-folder-restore/blob/master/recursive-recyclebin-restore.ps1

https://pnp.github.io/powershell/cmdlets/Restore-PnPRecycleBinItem.html

https://pnp.github.io/powershell/cmdlets/Get-PnPRecycleBinItem.html

Redbaron99's avatar
Redbaron99
Copper Contributor
Mar 28, 2022
Thank you so much, I’ll mess around with it for a bit. Am still learning PowerShell so thank you for the resources as well!
  • Leavii's avatar
    Leavii
    Brass Contributor
    Mar 28, 2022
    Of course. Always glad to help. Let us know how it goes, eh? 😄
    • Redbaron99's avatar
      Redbaron99
      Copper Contributor
      Mar 28, 2022
      After messing with it, it does seem to be working, I’m giving it a couple of days to test the date filter a bit more. Thank you again.
      • Leavii's avatar
        Leavii
        Brass Contributor
        Mar 28, 2022
        Awesome! Looking forward to seeing how it turns out. Also, marking an answer to your question helps others find answers to the same question. If you made your own script to answer your question please do share 😄

Resources