Public/Migration/MailboxMove/Permission/Update-MailboxMovePermissionBatch.ps1
function Update-MailboxMovePermissionBatch { <# .SYNOPSIS Update BatchName from batches.xlsx found on SharePoint This will create a new file that you will need to copy to SharePoint It is a copy of the Batches.xlsx found on SharePoint, however it updates BatchName column based on your selection. .DESCRIPTION Update BatchName from batches.xlsx found on SharePoint This will create a new file that you will need to copy to SharePoint It is a copy of the Batches.xlsx found on SharePoint, however it updates BatchName column based on your selection. .PARAMETER SharePointURL Sharepoint url ex. https://fabrikam.sharepoint.com/sites/Contoso .PARAMETER ExcelFile Excel file found in "Shared Documents" of SharePoint site specified in SharePointURL ex. "Batches.xlsx" Minimum headers required are: BatchName, UserPrincipalName .EXAMPLE Update-MailboxMovePermissionBatch -SharePointURL 'https://fabrikam.sharepoint.com/sites/Contoso' -ExcelFile 'Batches.xlsx' .NOTES General notes #> [CmdletBinding()] param ( [Parameter(Mandatory)] [ValidateNotNullOrEmpty()] [string] $SharePointURL, [Parameter(Mandatory)] [ValidateNotNullOrEmpty()] [string] $ExcelFile, [Parameter()] [switch] $IncludeMigrated ) end { $UserInputBatch = Read-Host "Enter BatchName with which to update batches.xlsx" if ($UserInputBatch) { $LinkSplat = @{ SharePointURL = $SharePointURL ExcelFile = $ExcelFile IncludeMigrated = $IncludeMigrated UserInputBatch = $UserInputBatch } Invoke-UpdateMailboxMovePermissionBatch @LinkSplat } } } |