How to add a MS365 group to many SharePoint sites as Site collection administrator

Question

Hello All,&nbsp;I have over 500 sites in Excel file/.scv.&nbsp;I created a MS365 group and added several users.&nbsp;Now, I want to add this MS365 group&nbsp;to all 500 sites as Site Collection Administrator.&nbsp;I need to do it with PowerShell. I hope someone out there would be able to help asap.&nbsp;Thanks

nicolaskheirallah · Answer

Naligurtan&nbsp;&nbsp;You will need to Modify this one to fit your needs such as looping through the CSV/excel but it should give you a base and understanding:&nbsp;#Parameters
$SiteURL = "https://contoso.sharepoint.com"
$GroupOwner= "email address removed for privacy reasons"
 
Try {
    #Connect to PnP Online
    Connect-PnPOnline -Url $SiteURL -Interactive
 
    #Get the Site
    $Site = Get-PnPSite -Includes GroupId
      
    #Add Group to Microsoft 365 Group connected to the site
    Add-PnPMicrosoft365GroupOwner -Identity $Site.GroupId -Users $GroupOwner
}
Catch {
    write-host -f Red "`tError:" $_.Exception.Message

naligurtan · Answer

Thanks. The problem is I don't have much experience of PowerShell. I would appreciate if you could please write down how to pick up data from .csv file etc.

nicolaskheirallah · Answer

Why not give it a try and if you get stuck i'll try to help you 🙂 This is a perfect use-case to learn!

Try to break it down to these steps:

1. Import the CSV to powershell
2. Iterate through the CSV
3. Apply the groups through each iterations

Forum Discussion

How to add a MS365 group to many SharePoint sites as Site collection administrator

Share

Resources