Case Study

Microsoft Copilot and Power Platform for Construction Project Operations

How Excel Power Construction Is Connecting Projects, People, Plant and Procurement with Microsoft Copilot and Power Platform

  • Construction
  • United Kingdom
  • Copilot & Power Platform
Client Story

A Crux of the Case Story

Excel Power Construction ran its projects through Teams, SharePoint lists, a stock control system, a time-clocking app and Xero. Each held part of the picture, so the managing director spent much of his time chasing people and pulling data into Excel. Dynamics Square designed a phased approach using Microsoft Copilot and Power Platform to connect project, resource, equipment and procurement data, and to automate the requests and follow-ups that were previously chased by hand.

Business Overview

Excel Power Construction delivers construction projects that depend on the right people, plant, vehicles, equipment and materials being in the right place at the right time. Each project involves drawings, risk assessments and method statements (RAMS), material deliveries, procurement, plant hire and galvanising collections.

The business already worked inside Microsoft 365. New projects were set up in Teams, and SharePoint held lists and forms for almost everything: van and equipment registers, consumables, holiday requests and more.

Alongside Microsoft 365, the company used a bespoke stock control system that had become outdated, a separate app for clocking in and out, and Xero for accounting. None of these systems talked to each other.

As a result, information sat in silos. The team pulled data manually into Excel to plan resources, and the managing director spent a large part of each week checking status, chasing requests and making sure everyone knew what was coming next.

The leadership team wanted the business to run in sync, with everyone able to see live project status, ownership and deadlines without being chased.

Excel Power Construction business overview

What are The
Business Challenges

Project, stock, timekeeping and accounting data sat in separate systems.

Staff pulled data manually into Excel to plan resources.

There was no single view of which people, vehicles, plant and equipment were free for a new project.

Holiday and sickness were not linked to resource planning.

Requests for procurement, plant hire and deliveries were chased by hand.

Site progress was not reported back in a structured, daily way.

Stock and consumables were reordered without automatic alerts.

Invoicing was not linked to project milestones or completion.

The business needed its existing Microsoft tools to work together as one connected system.

What the Business Needed

Excel Power Construction Copilot and Power Platform requirements
  • A live dashboard showing every project, its resources and its status.
  • Resource and equipment allocation that checks availability before assigning to a new project.
  • Holiday and sickness built into resource planning.
  • Closed-loop request tracking, with deadlines, notifications and acknowledgement.
  • Daily site returns from supervisors on their phones, linked to projects.
  • Automatic reorder alerts for stock and consumables.
  • Interim and milestone invoicing based on project completion.
  • Copilot as an AI layer across Microsoft 365.

The goal was a business that runs in sync, without the managing director chasing every task.

Business Objectives

Excel Power Construction set clear objectives:

Connect project, resource, equipment and procurement data in one place.

Automate request tracking and follow-ups across the team.

Give supervisors a simple mobile way to report daily site progress.

Trigger stock and consumables reorders automatically.

Link invoicing to project milestones.

Use Copilot to help staff find information and act on it faster.

Start with quick wins on the existing Microsoft 365 platform, then decide on a full ERP layer.

Excel Power Construction Copilot and Power Platform

Solutions Proposed by Dynamics Square

Dynamics Square recommended a phased approach: deliver quick wins with Power Platform and Copilot on top of the Microsoft 365 tools the team already used, then assess whether the business had outgrown Xero and needed an ERP foundation such as Microsoft Dynamics 365 Business Central.

Discovery and Process Mapping

  • Ran a discovery session with the managing director and operations lead.
  • Mapped how projects, resources, equipment, procurement and invoicing flowed through Teams, SharePoint and the existing apps.
  • Prioritised the processes where automation would save the most management time.

Closed-Loop Request Management

  • Built a request tracking process with Power Automate, so each request has an owner, a deadline and a status.
  • Set up automatic notifications, acknowledgement and status updates.
  • Created request logs per recipient so priorities are clear.

Resource, Plant and Equipment Allocation

  • Brought equipment, vehicle, consumable and staff registers together in one data model.
  • Linked holiday and sickness to resource availability.
  • Checked availability automatically when resources are assigned to a new project.

Site Returns and Live Dashboards

  • Gave supervisors a mobile way to submit daily site returns and job check-off sheets through Teams.
  • Streamed project status into Power BI dashboards visible to the whole team.
  • Set up stock and consumables reorder alerts.

Copilot and the Path to ERP

  • Enabled Microsoft 365 Copilot to help staff summarise, find and act on project information.
  • Assessed milestone-based invoicing and whether Business Central should replace Xero as the finance and project foundation.

Results and Impact: What This Transformation Means

The first phase turns Excel Power Construction’s existing Microsoft 365 tools into a connected operations platform.

Requests are tracked from creation to completion, without manual chasing.

Everyone can see live project status, ownership and deadlines.

Resources, plant and equipment are allocated against real availability.

Supervisors report daily site progress from their phones.

Stock and consumables reorders are triggered automatically.

Copilot helps staff find and act on project information faster.

Why This Case Matters and Future Prospects

Many construction and contracting businesses already pay for Microsoft 365 but use only a fraction of it. Teams and SharePoint become filing cabinets, while the real coordination happens by phone, email and spreadsheet.

Excel Power Construction shows how much can be achieved by connecting what is already there. Power Automate, Power Apps and Power BI can automate requests, resource checks and site reporting quickly, and Copilot adds an AI layer that helps people work with the information.

The phased approach also protects the business from over-investing too early. Quick wins prove the value first; the decision on a full ERP foundation follows, based on real needs.

The next phase of the journey is already defined:

  • Milestone and interim invoicing linked to project completion.
  • A decision on moving from Xero to Business Central.
  • Replacing the legacy stock control system.
  • Integrating time-clocking data with projects and payroll.
  • Expanding Copilot use across commercial and operations teams.
  • Further dashboards for directors and project managers.

With its operations connected, Excel Power Construction can take on more projects without adding more chasing.

Business consultant

Consult To Reveal Best Approach

Connect with us to facilitate your system to drive a parallel approach in the market you deal with. We help enterprises to implement their unique needs.

Let’s build the future of your business—together!

The right technology can change everything, and Dynamics Square ensures your business gets the tools it needs to succeed. Take the first step towards smarter solutions now!

Phone