Microsoft Power Platform Summary, Technical Evolution by Year & Career Involvement

Microsoft Power Platform is an enterprise-grade, low-code platform that allows organizations to build applications, automate workflows, analyze data, and create AI-powered virtual agents. It natively connects to Microsoft 365, Azure, and Dynamics 365, serving as a core pillar of modern digital transformation.

Microsoft Power Platform Summary and Technical Evolution by Year
Microsoft Power Platform Overview

Core Pillars

  • Power Apps: A low-code development environment for building custom, cross-platform business applications (Canvas or Model-driven) without writing traditional code.
  • Power Automate: An automation service enabling the creation of workflows, API-based integrations, and Robotic Process Automation (RPA) for legacy systems.
  • Power BI: A business analytics service that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
  • Power Pages: A secure, enterprise-grade low-code software-as-a-service (SaaS) platform for designing, configuring, and publishing external-facing websites.
  • Microsoft Copilot: AI-assisted generative capabilities natively built across the platform, allowing users to build apps, write flows, or generate reports using natural language.

Foundational Technologies

  • Dataverse: A secure, cloud-based data storage and management layer featuring a standardized common data model, allowing disparate Microsoft tools to seamlessly share information.
  • Connectors: Over 1,000 pre-built wrappers that facilitate communication between the Power Platform and external services (like Salesforce, SQL databases, or REST APIs).
  • Power Fx: A low-code, strongly-typed functional programming language based on Excel formulas that serves as the logic layer across the platform.

Technical Evolution by Year

The Power Platform did not launch overnight; it evolved through the gradual introduction of several standalone tools before Microsoft formally unified them under one umbrella.

2013–2015: The Origins of Data Analysis & Logic

  • 2013: Power BI is initially released as an add-in for Microsoft Excel, allowing users to build pivot tables and light analytics.
  • 2015: Power BI transitions into a standalone cloud service. Concurrently, Power Apps enters public preview, introducing the low-code app paradigm.

2016–2017: Workflow Automation

  • 2016: Microsoft Flow (the predecessor to Power Automate) is launched to handle cloud-based workflow automation.
  • 2017: Common Data Service (now Dataverse) is introduced to provide a standardized, secure data layer.

2018–2019: The “Power Platform” Unification

  • 2018: Microsoft officially unifies Power BI, Power Apps, and Microsoft Flow under the official name “Microsoft Power Platform”, introducing the formal concept of a connected, low-code business ecosystem.
  • 2019: The Common Data Service gets deeper integration across Dynamics 365 and Microsoft 365, accelerating citizen development across large enterprises.

2020: AI and Robotic Process Automation (RPA)

  • 2020: Microsoft launches AI Builder, allowing users to integrate pre-trained AI models (like form processing and object detection) directly into their apps and workflows.
  • 2020: Softomotive is acquired, bringing RPA (desktop flows) into Power Automate.

2021–2022: New Additions and Expanded Web Presence

  • 2021: The Common Data Service is officially rebranded as Microsoft Dataverse.
  • 2021: Power Fx is introduced as the standard, open-source low-code language.
  • 2022: Power Apps Portals is rebranded and expanded into Power Pages, creating a dedicated, robust tool for building external-facing websites.

2023–2024: The Generative AI Wave

  • 2023: Microsoft embeds generative AI across the suite through Copilot. Users begin building data tables, applications, and automation flows entirely through conversational prompts.
  • 2024: Power Platform deepens its integration with Microsoft Fabric and brings further enterprise-grade management, data governance, and AI agent orchestration features directly into Dataverse.

2025–2026: Agentic Computing and Modern Controls

  • 2025: Power Platform evolves beyond standard applications and automations into “agentic computing.” Makers can build autonomous, AI-driven data agents directly within Dataverse using the Python SDK.
  • 2026: Power Apps rolls out massive updates to its interface, deploying responsive layouts and modern controls as default settings. Advanced lifecycle management and process-mining features cement the platform’s role in modern fusion development.

My Recent MS Power Platform Involvement :

UK Gov : Cloud Migration (Hybrid) – In 2020, working as a Senior Project Manager on a client sponsored Agile proof-of-concept (POC) project to move 3 Client elected Apps (with MS Access, Oracle and SQL 2008 DBs), to the Cloud (Microsoft Azure and Dynamics365 Power Platform). The migration to the cloud was based on 3 primary app patterns namely; re-host, re-platform and re-factor. This project spanned approximately 3 months and started in early February 2020 with a budget of £375k.

The project was a pre-cursor and effort indicator for the larger piece of migration work to move 130 client estate apps to the cloud. This is a very complex app estate with many touch points and different technology stacks.

As the Capgemini Senior PM, responsible for the project planning, control, organisation, stakeholder communication, aligning with current GDPR directives and status reporting against delivery of Capgemini services to the client. As the PM, also the first escalation point for the project team and the client.

C&CA UK's Communications & Engagement Award Winner 2022 - Cloud & Custom Applications - Capgemini UK
December 2022 – C&CA UK’s Communications & Engagement Award Winner – Cloud & Custom Applications – Capgemini UK
Unknown's avatar

Author: Mark Whitfield

Welcome to my site! After graduating in Computing in 1990, I accepted a position as a programmer at a Runcorn based software house specialising in electronic banking software, namely sp/ARCHITECT-BANK on Tandem Computers (now HPE NonStop). This was before the internet became more prevalent and so the notion of enabling desktop access to company accounts for inter-account transfers and book keeping was still quite a cutting edge idea (and smartphones only ever hinted at in Space 1999). The company was called The Software Partnership (which was taken over by Deluxe Data in 1994). I spent 5 years in Runcorn developing code for SP/ARCHITECT for various banks like TSB, Bank of Scotland, Rabobank and Girofon (Denmark) to name but a few. I then moved onto a software house in Salford Quays for further bank facing projects. After a further 23 years in the IT industry and now a Senior IT Project Manager (both Agile and Waterfall delivery), I thought I would echo out my Career Profile in this corner of the internet for quick and easy access.

Leave a comment