Update Committee SharePoint & Distribution List Members

ℹ️

Full sync. For each selected group, members you keep in the roster (plus extras) are added if missing. Anyone currently in the group who is not in that desired list is removed.
Sign in as Global Admin when PowerShell opens the browser login window. Rows without a group email or member email are skipped.

1 · Upload Member Committees.xlsx

📄

Drop the Excel file here or click to browse

Requires sheets named SharePoint and Distribution List

Microsoft 365 groups that back committee SharePoint sites. Group email comes from the SharePoint Group Email column.

Groups to sync

Group owner

Owner email (optional)

Added as an Owner on the groups you check below. Does not by itself add them as a member.

Additional members (not in the spreadsheet)

Assign to SharePoint groups

Imported members

Each person is included by default. Uncheck to drop them from every SharePoint group. Use Committees to change which groups they belong to.

Mail-enabled committee groups. Group email comes from the Distribution List Email column.

Groups to sync

Group owner

Owner email (optional)

Added as an Owner on the groups you check below. Does not by itself add them as a member.

Additional members (not in the spreadsheet)

Assign to distribution lists

Imported members

Each person is included by default. Uncheck to drop them from every distribution list. Use Committees to change which lists they belong to.

2 · PowerShell Setup (optional)

I already have PowerShell 7 and the Microsoft Graph module installed

Run these once in Terminal.

Install PowerShell 7 (Homebrew)

brew install --cask powershell

Copied!

Launch PowerShell, then install Microsoft Graph

pwsh Install-Module Microsoft.Graph -Scope CurrentUser -Force

Copied!

3 · Ready-to-Run Commands

Upload the workbook, review both sections, then copy the commands in order. When the sync finishes, an HTML summary is saved to Downloads and opened in your browser — use Print → Save as PDF if you need a PDF copy.

A Launch PowerShell

macOS: open Terminal. Windows: open PowerShell 7 or Windows Terminal, then run:

pwsh

Copied!

B Connect to Microsoft Graph

A browser window will open. Sign in with your M365 Global Admin account.

Connect-MgGraph -Scopes "User.Read.All","Group.ReadWrite.All","GroupMember.ReadWrite.All" -NoWelcome

Copied!

C Sync SharePoint groups & distribution lists

One combined script. Processes only the groups you selected in each section. Writes an HTML change report to Downloads and opens it.

# Upload the Excel file and select at least one group — the script will appear here.

Copied!