Skip to content

Innovation Portfolio App with Stage Gates, Idea to Sunset

Global management consultancy

In short

How can an innovation team track ideas from first pitch to sunset in one app?

Innovation portfolios run on spreadsheets, slide decks and memory. Ideas wait without a decision, weak products carry on past their value and leaders cannot see where money and people are going. We ran a proof of concept workshop and built a model-driven app that takes each idea through stage gates to scale or sunset.

Results in numbers

requirements mapped
37
data model tables
11
days to deliver
148

At a glance

  • 37 requirements mapped to Power Platform
  • One record from idea to product to sunset
  • Delivered in about 148 person days

The client

The client is a global management consultancy. Its innovation team moves software ideas and products through funding gates, and needs one view of the portfolio, the people and the budgets on Microsoft 365.

What it was costing them

  • No single view: ideas and products live in separate files, so the portfolio cannot be filtered by stage, type or resource need.
  • Slow gate decisions: criteria sit in documents and in people's heads, so pass or fail calls depend on who is in the room.
  • Products that should stop do not: without sunset measures, low value products keep using people and budget.
  • Hidden resource gaps: demand for roles and chargeable staff without a project are tracked by hand.

What we built

We built one model-driven app on Dataverse where an idea and the product it becomes share a single record, guided by a business process flow.

  • One record from idea to product: the Innovation table holds both, so history stays intact when an idea becomes a product.
  • Clear stage gates: a business process flow guides each step and asks for a rationale on every move between stages and gates.
  • Gate decisions on evidence: required fields and criteria for each gate, numeric or document based, support a pass or fail call.
  • A clean stop: the Deactivate button is renamed Sunsetting and works at any stage, backed by sunset measures and alerts.
  • A portfolio you can slice: Product Portfolio views filter by stage, product type and resource need.
  • Budgets under control: budgets, versions and amendments track requested, approved and spent amounts, with approver notifications.
  • Risks with owners: risks, actions and status reviews attach to each innovation, with a dashboard for the review meeting.
  • A full audit trail: Dataverse audit history records every change.

Results

  • The fit gap analysis mapped 37 requirements to Dataverse, business process flows, security roles, Power Automate and dashboards.
  • The app covers 11 tables, up to 10 notification flows and up to 4 dashboards.
  • Delivered in about 148 person days, against a range of about 95 to 256 across scenarios.
  • Result: leaders can filter the whole portfolio by stage in one view, replacing manual status packs.

The risk most teams miss

At month three the risk is process drift. Teams redefine stages and gates, and the app breaks if they are hard coded. The app keeps stages and entry criteria configurable, with redefinition of the lifecycle as a separate later item. Security by business unit and role needs decisions early, because budgets and risks are sensitive. A named owner for the process matters more than any feature.

What we would add today

Improvements we would add on top of what is live.

  • Add a Copilot Studio agent that answers which products are overdue for a gate review, using Dataverse data.
  • Use AI Builder prompts to summarise status review notes and draft gate rationale from uploaded documents, for the reviewer to edit.
  • Surface sunset and health scores in Power BI or Fabric over Dataverse, with one shared semantic model.
  • Deploy through Power Platform pipelines across development, test and production, with connection references.

Technology

Power Apps model-driven app, Dataverse, Business Process Flows, Power Automate, SharePoint Online, Power BI, Microsoft Entra ID.

Tell us how your innovation ideas move from pitch to scale or stop today, and we will tell you how to run them as one governed portfolio.

Products and capabilities

  • Power Apps
  • Dataverse
  • Power Automate
  • model-driven app
  • business process flow
  • stage gates
  • portfolio management
  • fit gap analysis

Related use cases

Management and planning

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.