Copy/move folders from SharePoint site to OneDrive user using Powershell

Koen_RealConnections 

So I would approach this in a different way and just use SharePoint Archiving and Backup instead. Just Archive the Files/Sites that is not in use and retrieve them when needed instead of being in someone's OneDrive. Also using archiving the storage is 75% Cheaper

# Install the PnP PowerShell module if not already installed
Install-Module -Name "PnP.PowerShell" -Force -SkipPublisherCheck

# Connect to the source SharePoint site
$sourceSiteUrl = "https://yourtenant.sharepoint.com/sites/SourceSite"
Connect-PnPOnline -Url $sourceSiteUrl -Interactive

# Store the connection for later use
$sourceConnection = Get-PnPConnection

# Connect to the destination SharePoint site
$destinationSiteUrl = "https://yourtenant.sharepoint.com/sites/DestinationSite"
Connect-PnPOnline -Url $destinationSiteUrl -Interactive

# Store the connection for later use
$destinationConnection = Get-PnPConnection



# Define source and destination library and folder
$sourceLibrary = "Documents"
$sourceFolder = "FolderToMove"

$destinationLibrary = "Documents"
$destinationFolder = "FolderToMove"

# Use the source connection
Set-PnPConnection -Connection $sourceConnection

# Get all files and subfolders in the source folder
$files = Get-PnPFolderItem -FolderSiteRelativeUrl "$sourceLibrary/$sourceFolder" -ItemType File
$subFolders = Get-PnPFolderItem -FolderSiteRelativeUrl "$sourceLibrary/$sourceFolder" -ItemType Folder

# Copy each file to the destination folder
foreach ($file in $files) {
    $sourceFileUrl = $file.ServerRelativeUrl
    $destinationFileUrl = $sourceFileUrl -replace $sourceSiteUrl, $destinationSiteUrl

    Set-PnPConnection -Connection $destinationConnection
    Copy-PnPFile -SourceUrl $sourceFileUrl -TargetUrl $destinationFileUrl -OverwriteIfAlreadyExists
}

# Copy each subfolder and its contents recursively
function Copy-FolderContents {
    param (
        [string]$currentFolderUrl
    )

    # Get files and subfolders in the current folder
    $currentFiles = Get-PnPFolderItem -FolderSiteRelativeUrl $currentFolderUrl -ItemType File
    $currentSubFolders = Get-PnPFolderItem -FolderSiteRelativeUrl $currentFolderUrl -ItemType Folder

    # Copy each file
    foreach ($file in $currentFiles) {
        $sourceFileUrl = $file.ServerRelativeUrl
        $destinationFileUrl = $sourceFileUrl -replace $sourceSiteUrl, $destinationSiteUrl

        Set-PnPConnection -Connection $destinationConnection
        Copy-PnPFile -SourceUrl $sourceFileUrl -TargetUrl $destinationFileUrl -OverwriteIfAlreadyExists
    }

    # Recursively copy each subfolder
    foreach ($folder in $currentSubFolders) {
        $sourceFolderUrl = $folder.ServerRelativeUrl
        $destinationFolderUrl = $sourceFolderUrl -replace $sourceSiteUrl, $destinationSiteUrl

        Set-PnPConnection -Connection $destinationConnection
        New-PnPFolder -Name $folder.Name -Folder (Split-Path -Path $destinationFolderUrl -Parent)

        Copy-FolderContents -currentFolderUrl $sourceFolderUrl
    }
}

Copy-FolderContents -currentFolderUrl "$sourceLibrary/$sourceFolder"