Smart Solutions
Need help?
  • 100% Free & MIT Licensed
  • No third-party data hosting
SharePoint PermissionsMicrosoft 365 GroupsHow-to

See who's actually in your M365 Group in SharePoint (expanded members)

6 min readBy Offered as a service by our team

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

  1. Add the Smart Permissions web part to a page on the site you want to report on.
  2. Open the web part properties, expand Advanced.
  3. Tick Expand group members. Save the page.
  4. Run the report. Every group row is now expanded to the users inside.
  5. Click Export to Excel. The exported workbook has one row per user per scope — the shape that's actually useful for review.

Related

Permissions tools

Free · MIT license · no sign-up

Get your first result in about 10 minutes

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

  1. Download the .sppkg package from the latest release.
  2. Upload it to your tenant App Catalog.
  3. Add the web part to a SharePoint page.
Install guide
Download the latest releaseView on GitHub
Email me when a new release ships
Get notified when SharePoint Smart Permissions updates

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.

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 feature

Related tool

SharePoint Smart Permissions

Visual permissions audit + Excel export. No PowerShell. Free, MIT licensed, no sign-up.

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.