Created by Claude - please verify

Copilot candidates - Microsoft 365 app usage (30 days) of licensed members who have no Copilot plan; a ranking aid, not a recommendation engine.

Required Microsoft Graph permissions

Reports.Read.All User.Read.All Organization.Read.All — application permissions, granted to the app registration with admin consent.

Endpoints: GET /v1.0/reports/getM365AppUserDetail(period='D30') · GET /v1.0/users (assignedLicenses) · GET /v1.0/subscribedSkus · GET /v1.0/copilot/reports/getMicrosoft365CopilotUsageUserDetail(period='D30')

Score = 2 points per app used (Outlook, Word, Excel, PowerPoint, OneNote, Teams) + 1 per platform (Windows, Mac, mobile, web). Pair with Copilot Licence Adoption to find seats to move.

If a permission is missing, this report shows a red load error with the Graph status code — not an empty table.

Copilot Licence Candidates

Copilot pays off for people who already live in Outlook, Teams, Word, Excel and PowerPoint. These are the heaviest Microsoft 365 users who do not have a Copilot licence yet - the first place to move a seat that is going unused.

Every licensed member already has Copilot.