See who's actually in your M365 Group in SharePoint (expanded members)
Open Site permissions on any modern SharePoint site and you'll see something like Contoso Marketing Members — Edit. That single line is what SharePoint considers the answer. It is not the answer your CISO, your auditor, or your Copilot rollout wants. They want the list of real people inside that group.
When the group is a Microsoft 365 Group (which is the default for every modern team site), the membership lives in Entra ID, not in SharePoint. The SharePoint permissions UI won't expand it. The classic answer is a PnP PowerShell loop with Get-PnPMicrosoft365GroupMembers. There's a faster no-code path.
The one-toggle fix
The free SharePoint Smart Permissions SPFx web part has an Expand group members option in Settings. Turn it on, run the report, and every group row — SharePoint group, Microsoft 365 Group, or Entra security group — becomes the flat list of individual users inside it, each with the effective permission they get through the group.
Nested groups (a security group inside an M365 Group, an M365 Group inside a SharePoint group) are expanded recursively, so the final report is user rows, not group rows.
What that unlocks
- "Who can edit this site?" answered in seconds instead of a PowerShell loop and a spreadsheet join.
- Stale membership — ex-employees who are still on the M365 Group appear as users, not hidden behind a group name.
- Guests — external users inside the M365 Group show up in the report inline, tagged as guests.
- Copilot readiness — the ACL Copilot honors is the expanded one; that's the one the report now matches.
- Excel exports that a non-admin owner can actually read — no group names to chase.
Why SharePoint doesn't do this natively
SharePoint's permissions model was built around SharePoint groups, which live inside the site collection. Microsoft 365 Groups arrived later, they live in Entra ID, and their membership is fetched via Microsoft Graph. Expanding them in the SharePoint UI would mean a Graph call per group on every page render — so Microsoft chose not to. Smart Permissions does the Graph calls up front, caches, and shows the flat list.
How to turn it on
- Add the Smart Permissions web part to a page on the site you want to report on.
- Open the web part properties, expand Advanced.
- Tick Expand group members. Save the page.
- Run the report. Every group row is now expanded to the users inside.
- Click Export to Excel. The exported workbook has one row per user per scope — the shape that's actually useful for review.
Related
- SharePoint Smart Permissions
- SharePoint permissions report by user
- How to audit SharePoint permissions
- SharePoint permissions inheritance: complete reference
Permissions tools
- SharePoint permissions audit tool — free, read-only, MIT-licensed SPFx web part.
- SharePoint permissions reporting tool — what to look for when choosing one.
Get your first result in about 10 minutes
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
- Download the .sppkg package from the latest release.
- Upload it to your tenant App Catalog.
- Add the web part to a SharePoint page.
Email me when a new release ships
No marketing spam. One short email when a new release ships. You can unsubscribe anytime.
The SharePoint permissions guides
Understand how access is granted, report on who actually has it, then compare the tools that get you there.
Understand
How permission levels, groups, inheritance and sharing links actually fit together.
Where inheritance breaks, why it matters, and how to find every object with unique permissions.
Answer the question a manager asks most, down to a single folder or file.
Report
The free permissions report: every site, library, folder and file, exported to Excel.
What a permissions report should contain and how to run one without PowerShell.
A repeatable audit: scope, run, review, remediate, and re-check.
Find every guest with access before a Copilot rollout or a security review.
Was this page helpful?
One click. No form, no email address.
Missing something in SharePoint Smart Permissions? Feature requests and bug reports go straight to the developer on GitHub — no account needed to read, free account to post.
Request a featureRelated tool
SharePoint Smart Permissions
Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.
Keep reading
How to See Who Has Access to a SharePoint Site (Free Report)
Get the full access list for a SharePoint site — real people behind every group, guests included — instead of the three group names SharePoint shows you.
How to see every SharePoint site you have access to (and build a site directory)
SharePoint has no built-in page that lists every site a person can open. A PnP Modern Search results web part with a contentclass:STS_Site query gives you one — security-trimmed, self-updating, and free.
The SharePoint permissions Excel export — how to turn it into decisions
Exporting a SharePoint permissions report to Excel is easy. Turning 5,000 rows into decisions is the actual audit. Here's the review workflow.
Want a second set of eyes?
Get a SharePoint permissions audit from our team
We review who can see what across your sites, flag oversharing before you roll out Copilot, and help you put a cleanup plan and governance in place.
About the author
Sean Regan
SharePoint & Microsoft 365 consultant with 20+ years of hands-on experience building SPFx web parts, migration tooling and tenant-grade automation. Maintainer of the open-source SharePoint Smart Solutions suite.
