queuemigrations.ps1

$credentials = 'D:\codes\AutomationScripts\GetCredentials.ps1'

$migrationDataFolder = '\\masterterminal\c$\AutomatedMigrationData'
$packagesFolder = 'packages'
$mailFolder = 'mails'
$reportsFolder = 'reports'

$inputFolder = 'input'
$processingFolder = 'processing'
$finalFolder = 'final'

$migrationConfigSiteUrl = 'https://yourtenant.sharepoint.com/sites/HSSPilot'
$migrationConfigList = 'Migrationsconfig'


function Download-MigrationItem {
    
    Param(
    [string] $sourcePath,
    [String] $destinationSite,
    [String] $destinationlibrary,
    [string] $id
    )

    $path = $migrationDataFolder + '\' + $packagesFolder + '\' + $inputFolder + '\' + (Get-Date).ToString("yyyyMMdd-hhmmss") + "_" + $id + "_" +  $destinationlibrary + ".csv"

    $props = @{

        Id = $Id
        source = $sourcePath
        destinationSite = $destinationSite
        destinationlibrary = $destinationlibrary
    }

    $object = new-object psobject -Property $props

    # Write migration data as a packet
    $object | Export-Csv -Path $path -NoTypeInformation     
}


Function Check-MigrationItems{

    Connect-PnPOnline -Url $migrationConfigSiteUrl -Credentials $credentials    
    $itemIds = (Get-PnPListItem -List $migrationConfigList -PageSize 1 -Query "<View><Query><Where><And><And><Eq><FieldRef Name='ReadyToMigrate'/><Value Type='Integer'>1</Value></Eq><Eq><FieldRef Name='Started'/><Value Type='Integer'>0</Value></Eq></And><Eq><FieldRef Name='Migrated'/><Value Type='Integer'>0</Value></Eq></And></Where></Query></View>").Id

    #$itemIds

    if($itemIds)
    {
        foreach($itemid in $itemIds)
        {
            #Get Item from the List
            $item = (Get-PnPListItem -List "MigrationList" -Id $itemid -Fields "Id","Source","DestinationSite","DestinationLibrary","TerminalName","MigrateAllData").fieldvalues

            #$item

            #Download migration data as a Csv
            Download-MigrationItem -id $itemid -sourcePath $item.Source -destinationSite $item.DestinationSite -destinationlibrary $item.DestinationLibrary

            #Set Item processing as started
            Set-PnPListItem -List "MigrationList" -Identity $itemid -Values @{"Started" = $true;}
        }
    }
    else
    {
        write-host "No migration items available. Sleeping for 1 Minute."
        Start-Sleep -Seconds 30
    }
}


while($true)
{
    Check-MigrationItems   
    write-host "No migration items available. Sleeping for 30 Minutes."
    Start-Sleep -Seconds 1800   
}