Create a Dynamic Distribution List from members of an "Office 365 Group"

[DougTraylor]

Hello.  I have been asked to nest an Office 365 Group into a distribution list, but I don't believe this is possible.  I had the bright idea that I could create a Dynamic Distribution List from the members of the UnifiedGroup, but my command is returning 0 members.

I got the below CN from PowerShell using:

"get-unifiedgroup (groupname) |fl"

I am trying: 

memberofgroup -eq "CN=(groupname)_539b0afa-fa6e-4cfe-a3bb-e91cf0d435f0,OU=(companydomain).onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=NAMPR01A004,DC=prod,DC=outlook,DC=com"

Is "memberofgroup" functional for members of UnifiedGroups (Office 365 Group)?

Thank you,

Doug

[#2]

You can only use AD attributes such as notes/Title/manager etc. or the 15 custom attributes to build Dyn Distro's and Dynamic groups, you can't use group memberships of other groups to build those out.

[#3]

What's the entire cmdlet? Here's an example that works just fine for me:

Get-Mailbox -Filter "MemberOfGroup -eq 'CN=default_8d405d20-65d9-4650-abca-352770e4438b,OU=tenant.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=EURPR03A001,DC=prod,DC=outlook,DC=com'"

And you can use the same filter for a DDG.

@ChrisWebbTech that's not true, those are simply the attributes exposed in the UI, but you can use pretty much anything for the recipientfilter query if you do it via PowerShell.

[#4]

Well. Learned something new. Docs never mentioned that. Good to know!

[#5 · Accepted solution]

Ok, I figured it out using powershell. 🙂  The key turned out to be the recipientfilter needed the recipientType and memberofgroup attributes>

New-DynamicDistributionGroup -Name "MyDDG" -RecipientFilter {((RecipientType -eq 'UserMailbox') -and (memberOfgroup -eq "CN=MyO365Group_430c61d4-7b32-4b35-957b-644912193d28,OU=MyCompany.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=NAMPR01A004,DC=prod,DC=outlook,DC=com"))}

Works like a charm.

Thanks for looking!

Doug