Skip to content
DevOps AI ToolKit
Newsletter
All prompts
AI for Microsoft Teams Difficulty: Advanced ClaudeChatGPTCursor

Teams Graph Usage Report Adoption Digest Prompt

Use the Microsoft Graph reports API to build a Teams adoption / usage digest — active users, message and meeting activity, app usage — and post it back into Teams as an Adaptive Card for platform owners.

Target user
M365 platform admins and internal tooling engineers
Difficulty
Advanced
Tools
Claude, ChatGPT, Cursor

The prompt

You are an M365 platform engineer who has built Teams adoption reporting from the Microsoft Graph reports API and delivered it as Adaptive Card digests inside Teams.

I will provide:
- The reporting cadence (daily/weekly/monthly) and period (D7/D30/D90/D180)
- Which metrics matter (active users, messages, meetings, calls, app usage)
- The admin channel to post to and who consumes it
- Whether the tenant has the "display concealed user information" privacy setting enabled
- Auth model (app registration with application permissions)

Your job:

1. **API selection** — map metrics to the correct Graph endpoints:
   - `GET /reports/getTeamsUserActivityUserDetail(period='D7')`
   - `GET /reports/getTeamsUserActivityCounts(period='D30')`
   - `GET /reports/getTeamsDeviceUsageUserCounts(period='D7')`
   - `GET /reports/getM365AppUserDetail(period='D30')` where relevant
   Note these return CSV by default (302 redirect to a download) or JSON with `?$format=application/json`.

2. **Auth** — application permission `Reports.Read.All`, client-credentials flow, and why delegated flows are the wrong choice for a scheduled job.

3. **Data handling** — parse the CSV/JSON, handle the de-identified (`display concealed`) case where names become `AAAAA...`, and compute deltas vs the prior period for trend arrows.

4. **Card design** — Adaptive Card 1.5:
   - KPI header row (`ColumnSet`) with active users, messages, meetings and a trend arrow (up/down) per KPI
   - A small textual sparkline or top-movers `FactSet`
   - Segment breakdown (channel messages vs chat, web vs desktop vs mobile)
   - `Action.OpenUrl` to the full report in SharePoint/Power BI and `Action.ShowCard` for detail

5. **Delivery** — a scheduled Power Automate Workflow or bot posting the card; how to keep it under the ~28 KB card limit by summarizing and linking to detail.

6. **Reliability** — the reports endpoints are eventually consistent and can lag 24-48h; handle empty/partial periods gracefully, retry on 429 with `Retry-After`, and never post a "0 users" card caused by a not-yet-ready report.

7. **Trend intelligence** — flag anomalies (a sudden drop in active users, a spike in guest activity) rather than dumping raw counts.

Output as: (a) the endpoint-to-metric mapping, (b) auth/permission setup, (c) the CSV/JSON parsing + delta computation outline, (d) Adaptive Card JSON, (e) the schedule + reliability plan, (f) anomaly-flagging rules.

Bias toward: application permissions with least privilege, graceful handling of report lag and de-identification, and insight over raw dumps.

Run this prompt with AI

Test it, get an AI-improved version, or compare models — live in the Prompt Workspace. No copy-paste.

Related prompts

More Microsoft Teams prompts & error guides

Browse every Microsoft Teams prompt and troubleshooting guide in one place.

Free download · 368-page PDF

Reading prompts? Get all 500 in one free PDF

500 battle-tested, copy-paste AI prompts engineered by a senior systems engineer — every one with fill-in placeholders and safety/back-out notes. Drop your email and it's yours.

  • 500 prompts: Linux · Kubernetes · Terraform · OpenStack · GitLab · Docker · Monitoring · Incident Response
  • Instant PDF download — yours free, forever
  • Plus one practical AI-workflow email a week (no spam)

Single opt-in · unsubscribe anytime · no spam.