Loading
ADadruich®

Power Platform · Internal Tooling

Pool Management

An internal bench-management platform for 270+ consultants — built end to end on Power Apps, Power Automate and SharePoint.

  • Power Apps
  • Power Automate
  • SharePoint
  • Power BI
  • Excel

01 — Overview

Tracking who is available between assignments used to live in a spreadsheet passed around by email — stale the moment it was sent, impossible to filter, and with no history of who joined the bench or left it.

I built a platform that replaces that file entirely. Consultant data arrives as a monthly export, gets normalized, compared against what already exists, and lands in a structured data layer that the application reads from. Everything downstream — availability, joiners, leavers, CV coverage, reporting — is derived from that pipeline rather than maintained by hand.

The front end is a Power Apps canvas application with custom HTML components. The data layer is SharePoint. The logic layer is a set of Power Automate flows that handle ingestion, comparison, document linking, notification and reporting.

Raw upload

The monthly Excel export lands in a SharePoint document library. Nothing is entered by hand.

Reformat

A flow normalizes the file against a fixed column template and writes the result to a separate formatted folder.

Ingestion

The formatted drop triggers a second flow that parses the rows into the SharePoint list backing the application.

Comparison

A diff against existing records derives new joiners, leavers, join and exit dates, and resolves duplicates before anything is written.

Each derived set writes to its own list — joiners, leavers, active pool — so the application reads clean, purpose-built collections rather than filtering one large table at runtime.

02 — Automation

01

CV linkage

A flow scans the CV document library and matches files against consultant records by name, flagging anyone without a document. The missing-CV count is derived, never entered.

02

CV reminders

One click sends a templated email to every consultant flagged as missing a CV. The list regenerates itself on the next scan.

03

Upload notifications

Admins are notified when a file is uploaded and again when processing completes, so nobody has to guess whether the import worked.

04

Power BI generation

A button in the app triggers report generation and distribution to a defined recipient list — reporting becomes a click rather than a request.

05

Excel export

Any filtered view exports to Excel through a flow, preserving the active filter set rather than dumping the whole table.

06

Supervisor reporting

Scheduled summaries go to supervisors with pool movement and coverage, formatted as custom HTML email.

03 — Interface

Derived KPIs

Pool size, joiners, leavers and CV coverage each read from their own list, populated by the comparison flow. The dashboard reflects the last import rather than whatever someone last typed.

Native charting

Distribution by technology renders inside Power Apps rather than embedded from Power BI — faster to load, and it stays interactive with the app's own filter state.

Nine-dimension filtering

Technology, category, hiring date, availability, last project, internal project, language levels and CV status filter simultaneously, with per-consultant detail views covering assignment history, availability windows and financial exposure.

A spreadsheet became a system. Managers filter and export in seconds, and the numbers are a consequence of the data rather than a description of it.

All work