Skip to content

wyattdave/my-power-platform

Repository files navigation

My Power Platform

Your Year on the Power Platform — in a Dashboard

A Chrome extension (works on all Chromium browsers — Edge, Brave, etc.) that pulls your Power Platform activity and transforms it into a visual dashboard.

Chrome Web Store Blog Post License

My Power Platform Dashboard


Getting Started

  1. Install the extension from the Chrome Web Store
  2. Log in at make.powerautomate.com
  3. Click the extension icon
  4. Wait a few seconds

That's it — the dashboard loads automatically.

Note: The extension saves data to local storage, so if you re-open it without a valid token it will display the last imported data.


Dashboard Sections

Timeline

Plots your creations over time with months on the x-axis. Separate lines for:

  • Power Automate Flows
  • Solution-aware Canvas Apps
  • Copilot Agents

Components

Shows totals for Flows, Apps, and Agents in summary charts.

Solutions

Displays the distribution of your Solutions across your top 4 environments. Microsoft-installed solutions (prefixed msdyn) are filtered out automatically.

Environment Variables

Breaks down your environment variables by type:

  • String, Number, Boolean, JSON, Data Source, Secret

Connection References

Charts your most-used connector types including SharePoint, Dataverse, Outlook 365, MS Forms, Office 365 Users, MS Teams, Power BI, Excel Business, OneDrive Business, Approvals, and others.

The Blurb

Key stats and callouts — biggest Solution, average components, and more. You'll also be tagged based on what you build most:

Tag Meaning
Flow Rider Mostly Flows
Canvas Campbell Mostly Canvas Apps
Agent Smith Mostly Copilot Agents

Weighting: 2 Flows = 1 App, 2 Apps = 1 Agent.


Buttons & Controls

Button Description
Date Range Defaults to the current year. Change the from/to date pickers and click Update. Going over a year stacks months (e.g. 2 years summed, not 24 months).
Data Downloads the raw data as a JSON file (every component with name, id, etc.).
Envir Downloads a list of environments with component totals.
CSV Downloads every component in a CSV file.

How It Works

The extension borrows your existing access token to call Power Platform APIs, then uses Chart.js to render the dashboard.

APIs Used

API Endpoint
Get User ID {dynamicsUrl}/api/data/v9.2/WhoAmI
Get User Name {dynamicsUrl}/api/data/v9.2/systemusers({userId})
Get Flows api.flow.microsoft.com/providers/Microsoft.ProcessSimple/environments/{environmentId}/flows?api-version=2016-11-01
Get Apps {dynamicsUrl}/api/data/v9.2/canvasapps?$filter=...
Get Agents {dynamicsUrl}/api/data/v9.2/bots?$filter=...
Get Connection References {dynamicsUrl}/api/data/v9.2/connectionreferences?$filter=...
Get Environment Variables {dynamicsUrl}/api/data/v9.2/environmentvariabledefinitions?$filter=...
Get Solutions {dynamicsUrl}/api/data/v9.2/solutions?$filter=...
Get Solution Components {dynamicsUrl}/api/data/v9.2/solutioncomponents?$filter=...

Known Quirks & Notes

  • Canvas Apps use createdtime while every other table uses createdon.
  • The Flow API for environments/My Flows has no query filters — all filtering is done in code.
  • Canvas Apps use the Dataverse table (different API/token), so only solution-aware apps appear.
  • Connection Reference connectors are nearly infinite — only the most common ones are targeted.
  • The bot and connectionreference tables are dynamically added, so they don't have a fixed entity number across environments.
  • Some auto-installed Microsoft solutions (prefixed msdyn) are filtered out.
  • Components shared with you won't appear; only components created by you in the date range are shown.
  • The token is geo-specific — if you work across environments in different geos, only environments in the same geo as your current session will appear.
  • If some environments show a red icon, the WhoAmI API may have timed out (throttling). Try again or check the developer console.

Tech Stack

Contributing

Feel free to clone, fork, or open issues and PRs.

git clone https://github.com/wyattdave/my-power-platform.git

License

See LICENSE for details.


Built by David Wyatt — Microsoft MVP, Power Platform Developer. Read the full blog post: My Power Platform - Your Year in a Dashboard

Releases

No releases published

Packages

 
 
 

Contributors