DEV Community

April Dunnam
April Dunnam

Posted on

Build a Power Platform Yearly Stats Application

It's the end of another year, the time that we all look back and reflect on what we accomplished. As a Power Platform maker, it is a good idea to look back on what you built in the year and the impact you made.

To make this retrospection easier, I build "Power Platform Wrapped", a solution built on the Power Platform to help you get a customized overview of how many Power Apps you built, what you automated with Power Automate and more.

If you want to go straight to the solution and bypass the details, you can download the app here: Power Platform Wrapped

If you want to see a video walkthrough of the app and what it can do, check out this video:

How it's Built

Without going into too many boring details, I'll share a bit about how I built this solution.

The key pieces of information that I wanted to track are the number of Power Apps, Flows, Bots and Power Pages built. I started thinking about how to get that data and realized that all of that information is already available in the Power Platform Center of Excellence Starter Kit.

If you haven't installed the COE Kit in your environment then consider this your nudge to do so now! The COE Toolkit is a set of Power Platform assets (Flows, Power Apps, etc) that gives us additional administrative, governance and analytics capabilities. It runs a series of Flows to gather information about what is in your Power Platform environments and stores all of that data in custom Dataverse tables.

Since all of that data is already store in the COE toolkit, I decided to build on top of that for my year end stats solution. I built a simple Power Apps canvas app that pulls data directly from the underlying COE Dataverse tables.

I realize that not everyone has the COE kit installed so I built another version of the solution that uses the Power Platform Admin connectors instead. This separate solution uses a Power Automate flow to get all of this information using the Admin connectors and sends a summary email out.

If you're looking to help encourage and celebrate your Power Platform makers then this is a great template to try out!

Top comments (0)