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
The service behind this work
Power Platform development
Related use cases
Management and planningProgramme Collaboration Platform on Microsoft 365
A cooperation programme that runs events, registrations, surveys and shared workspaces across many countries cannot do it well with an ageing mail system and separate tools. We built a platform for the programme that puts all of it on Microsoft 365 and Power Platform.
- 78
- tender requirements met
- 65
- programme staff
Copilot and Power Platform Use Case Mapping
Most Copilot projects stall on one question: where does Copilot help, and where does the business need something else? the client had that question across its corporate teams. We turned business problems and role stories into a map that names the Microsoft tool for each, so spend goes to the right place.
- 34
- problems matched to a tool
- 29
- role-based use cases
Grant Management Tool for a Ukrainian Agriculture Programme
When grants, private-sector co-investments and contracts are tracked in different tools, managers cannot see the portfolio, each stage of the grant cycle depends on who holds the file, and money for Ukrainian agriculture moves more slowly than it should. We built one grant management system on Microsoft tools for the client.
- c. 70
- grant system users
- c. 20
- grant managers
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.