DEV Community

April Dunnam
April Dunnam

Posted on

1

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!

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read more →

Top comments (0)

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

đź‘‹ Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay