powershell VS office365-cli

Here is my Module that includes my functions on Azure Extension Properties. It uses the PnP.PowerShellmodule instead of the Graph SDK.

# Use system-assigned managed identity # https://mmsharepoint.wordpress.com/2023/05/04/authentication-in-azure-automation-with-managed-identity-on-sharepoint-and-microsoft-graph/ # https://pnp.github.io/powershell/articles/azureautomationrunbook.html # Connect to multiple sites # https://github.com/pnp/powershell/issues/1748 # https://robdy.io/multiple-pnp-connections/ # Prod $SourceStr = Get-AutomationVariable -Name 'SharePointSourceFolders' $Target = Get-AutomationVariable -Name 'SharePointTargetFolder' #$SourceList = $SourceStr.Split([System.Environment]::NewLine,[System.StringSplitOptions]::RemoveEmptyEntries) $SourceList = $SourceStr.Split("\n") # Commmon Foreach($Source in $SourceList){ Try{ Write-Output "Source Folder: $Source" #Dev #$SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -Interactive -ReturnConnection #Prod $SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -ManagedIdentity -ReturnConnection #Get the total Size of the folder - with versions $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Job finished" $jobStatus.JobState $jobStatus.Logs $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection -ErrorAction SilentlyContinue if($SourceFolder){ Write-Output "Second Try because folder: $SourceFolder.Name remains" $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Second Try Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Second TryJob finished" $jobStatus.JobState $jobStatus.Logs } else{ Write-Error "Second Try Status: $jobStatus" } } } else{ Write-Error "$jobStatus" } } catch { Write-Error "An error occurred: ${Source}: $_" } # Dispose the connnection variables $SourceSiteConnection = $null Write-Output "Sleep for 2 seconds" Start-Sleep -Milliseconds 2000 }

Reading - https://github.com/pnp/powershell/issues/277

The PnP PowerShell module is the one I would recommend for accessing SharePoint: https://pnp.github.io/powershell/

PnP is the module - it is amazing. The SP cli is a painful (but powerful) nightmare. https://pnp.github.io/powershell/

If you see any room for improvement, please, don’t hesitate to reach out to us either on GitHub or twitter.