Bulk Adding Members to O365 Group

[Gongalong]

Hi folks,

 

I want to add a student year’s worth of accounts (around 200) to an Office 365 group. Note it’s an O365 group, not an Exchange group.

 

Frustratingly the web interface for groups both as a user and an admin is different to the Exchange interface. The latter makes it so easy to easy large numbers of users, but the former seems to require that they are added individually (!).

 

Am I missing something and is there an interface hidden away, or some other workaround, that gives similar kind of functionality to the Exchange interface?

 

I’m guessing Azure PowerShell might have some facility, but the learning curve for both that, and connecting it to O365 (which I failed to do last time), are things I’d really rather avoid for such a simple job.

 

TIA

[apearce]

Hey - Office 365 Groups are also Azure AD Groups. You could download the Azure AD Powershell Cmdlets and bulk add them into this group which means they are in the Office 365 Group as well.

[SteveM555]

Are you familiar with Powershell and O365?

 

If so I can send you some scripts to import accounts into groups from a CSV file.

[Gongalong]

I have tried to connect to it before, but couldn't get it to work. It looks like that's my only alternative, so I'll retry.

[SteveM555]

I have tried to connect to it before, but couldn't get it to work. It looks like that's my only alternative, so I'll retry.

 

Once you're connected I use the following....

 

Import-Csv H:\email.csv | foreach {Add-DistributionGroupMember -Identity $_.group -Member $_.member}

 

With the CSV containing one column of...

 

member,group
Joe Bloggs,All Staff
Some User,All Staff
John Smith,All Support
Darth Vader,All Support

 

It'll throw an error if the member is already in the group, but it will just carry on processing them anyway. That's the simplest method I've found of doing it... I agree the admin UI should have better group management.

[Gongalong]

Why didn't MS make the Groups dialog the same as Exchange distribution list dialog? Sigh...