cls # Connection String Variables, including client specific ID and Tenant #$dateTime = (Get-Date).toString("dd-MM-yyyy-hh-ss") $invocation = (Get-Variable MyInvocation).Value $directorypath = Split-Path $invocation.MyCommand.Path # Set parameters $csvPath = $directorypath + "\Sites.csv" # CSV should have a column 'SiteUrl' $destList = "SMPSitesInventory"; # Define users to exclude # Output CSV for results #$outputCsv = $directorypath + ".\transformSpSites_IntoTeams_Channels_files" + $dateTime + ".csv" #$results = @() $domain = "bankofenglandcouk"; $adminSiteURL = "https://$domain.SharePoint.com" Connect-PnPOnline -Url $adminSiteURL -ClientId $clientId # Read sites from CSV $sites = Import-Csv -Path $csvPath $destconn = Connect-PnPOnline -Url $destiUrl -ClientId $clientId -ReturnConnection foreach ($s in $sites) { $siteUrl = $s.

#connection details $clientId = "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx" $invocation = (Get-Variable MyInvocation).Value $directorypath = Split-Path $invocation.MyCommand.Path $csvPath = $directorypath + "\TeamsChannelsExport.csv" # CSV should have a column 'SiteUrl' # Read sites from CSV $sites = Import-Csv -Path $csvPath #$TenantName = "contoso" #$adminSiteURL = "https://$TenantName-Admin.SharePoint.com" #Connect-PnPOnline -Url $adminSiteURL -ClientId $clientId function Add-ChannelNavigationLink { param( [string]$teamName, [string]$channelName, [string]$hubSiteUrl, [string]$channelSiteURL, [string]$teamSiteUrl, [string]$navParent ) Log-Message "Adding site to hub navigation - $($channelSiteURL)" "Info" if($hubSiteUrl) { try { # if(!