Solestyles Boutique’s Digital Transformation - Part 6 - Power Platform in Action - Lessons Learned

Introduction: Why a Series Wrap-Up?

Solestyles Boutique’s journey across the Power Platform has been a story of transformation; from paper invoices and spreadsheets to a seamless blend of Canvas apps on the shop floor, Model-Driven portals for administrators, robust Power Automate flows and dynamic Power BI analytics.

 

After five long and in-depth posts, it’s time to step back, reflect on what has been achieved and explore how these lessons apply to any business regardless of their size, location and complexity.

 
This final post will:

 

  • Recap the core value of each platform component and the problems they solved.
  • Extract universal take-aways, guiding principles for low-code success.
  • Walk through a real-world licensing example, using a 20-store Solestyles boutique example scenario to illustrate the latest Power Platform licence models and Dataverse storage considerations.
  • Gaze into the future, with AI-driven innovations and Copilot for Power Platform that promise to reshape how we build and use low-code solutions.

 

Whether you’ve followed every post in the series or are joining here for the first time, this wrap-up will help you connect the dots, avoid common pitfalls and chart a clear path forward; empowering your organisation to harness the full potential of the Power Platform.

 

Let’s begin with a quick stroll through the series highlights.

 

Series Recap: From Canvas to Analytics

Over the last five posts, I have  guided Solestyles Boutique from paper-bound chaos to a fully integrated, low-code platform powering every aspect of its business:

 

  • Post 1: From Paper Trails to Platform Power
    The stage is set for replacing aging spreadsheets and invoices with a unified Dataverse backbone establishing the central repository for products, orders and customers, and defining the business drivers for a mobile-friendly, secure system.
  • Post 2: Designing Solestyles’ Canvas App
    Next,a tablet-optimised Canvas App is crafted for shop-floor staff: a simple gallery-to-detail-to-cart flow, fully offline-capable, with “Add to Cart,” checkout screens and a seamless “Pay Now” integration that syncs back to Dataverse.
  • Post 3: Unlocking Power Apps Model-Driven
    For the back-office, a Model-Driven App is introduced: rich order and inventory forms, Custom Business Process Flows for approvals, embedded Power BI dashboards, and role-based security that gives assistants and managers just the data they need.
  • Post 4: Mastering Power Automate
    Manual business process flows were then automated; payments, order creation, stock adjustments and special-order notifications with solution-aware flows. Error-handling scopes, retry patterns and scheduled low-stock reports ensured every process ran reliably while Teams alerts kept the buying team in the loop.
  • Post 5: Power BI Analytics Deep Dive
    Finally, a star-schema model in Power BI was built, authored DAX measures like Total Sales and Stock Turnover, designed interactive dashboards aligned to the Solestyles brand, and implemented refresh strategies from incremental to near real-time so managers always see the freshest insights.

 

Together, these posts form an end-to-end blueprint: a single “Solestyles Boutique” solution where Canvas Apps, Model-Driven Apps, Automation and Analytics work together.

 

Universal Takeaways for Any Business

While Solestyles Boutique’s story is unique, the principles that powered its transformation apply to organisations of every size and sector. Here are the five pillars to guide your own Power Platform journey:


1. Embrace a Single-Solution Mindset

Whether you’re building a Canvas App for frontline staff, a Model-Driven portal for managers, or flows and reports to automate and analyse your data, house everything in one solution container. This approach streamlines ALM, keeps versioning consistent and makes it trivial to migrate from Dev to Test to Production without breaking connections or losing environment-specific settings.


2. Design with the User at the Centre

Never underestimate the power of user-centred design. Conduct discovery workshops to map out every persona’s daily tasks:

 

  • Shop assistants need offline galleries and quick-add cart functionality
  • Store managers want clear dashboards and approvals in one place
  • Executives require high-level trends at a glance.

 

Prioritise intuitive navigation, responsive layouts and just-in-time guidance (like Business Process Flows and in-app help) to maximise adoption and minimise training overhead.


3. Treat Data as Your North Star

Centralise all product, order and customer information in Dataverse and resist the urge to scatter data in spreadsheets or ad-hoc lists. A clean, well-modelled data layer (with lookups, calculated and roll-up columns) underpins every Canvas App screen, flow logic and Power BI report. By enforcing referential integrity and reusing environment variables and connection references, you ensure that every component reads from and writes to a single source of truth.


4. Build Resilience & Observability

Real-world systems need to tolerate failures; offline-first caching for poor connectivity, run-after and retry patterns for transient API errors, logging failures into Dataverse or Application Insights for post-mortem analysis, and scheduled health checks that alert you before small issues become business-critical outages. Adopt these patterns early to maintain continuous operations and build stakeholder trust.


5. Embed Governance from Day One

It’s easy to start small and spiral into shadow solutions. From the very first commit, define Data Loss Prevention policies, enforce security roles and field-level permissions, establish naming conventions and version controls, and leverage the CoE Starter Kit to monitor maker activity and policy compliance. A lightweight governance layer preserves agility while ensuring your platform scales securely.

 

By internalising these universal take-aways; single-solution ALM, user-centric design, data-first architecture, resilient operations, and proactive governance; you’ll be well equipped to replicate Solestyles’ success in your own organisation.

 

Licensing & Storage: A Solestyles Boutique (Potential Future) Case Study

All prices are accurate up to and including 2 July 2025 and exclude VAT.  Costs are based on an annual purchase rate, but divided into a monthly price record.


These estimates adhere to Microsoft’s latest published list prices and recommended best practices balancing full functionality with cost efficiency.  

 

High-Level Summary

Over the last few years, Solestyles Boutique has has grown from a single shop on a West Yorkshire high street to a multi-channel retailer juggling in-store sales, weekend pop-ups and an online storefront to a business that now has 20 stores around the UK.

 

 

To move Solestyles Boutique from pilot to production, the following was provisioned:

  • Microsoft 365 Business Standard for all 105 staff (email, Teams, Office apps): 105 × £9.60 = £1 008.00 / month
  • Power Apps Premium Per User for 25 key users (20 store managers + 5 executives): 25 × £15.40 = £385.00  / month
  • Power Apps Premium Per App for 2 080 seats (80 store staff + 2 000 customers): 2 080 × £4.10 = £8 528.00 / month
  • Power Automate Premium (Per User) for a dedicated service account (unlimited runs): 1 × £12.30 = £12.30 / month
  • Power BI Pro for the same 25 key users: 25 × £10.80 = £270.00 / month
  • Dataverse Storage: built-in entitlements (0.25 GB DB + 2 GB file per licence) cover one year’s active data once >12-month-old records are archived externally.

    Estimated Monthly Total: £10,203.30

 

Company Profile & Licence Allocation

Role

Count

Licence

Store Managers

20

Microsoft 365 Business Standard + Power Apps Premium Per User

Store Staff

80

Microsoft 365 Business Standard + Power Apps Premium Per App

Senior Leadership Team (SLT)

5

Microsoft 365 Business Standard + Power Apps Premium Per User + Power BI Pro

Registered Customers

2 000

Power Apps Premium Per App

Service Account

1

Power Automate Premium (Per User)


Detailed Licence Breakdown

Platform

Licence Type

Seats

Unit Price

Monthly Cost

Microsoft 365

Business Standard

105

£9.60 /user/month

£1 008.00

Power Apps

Premium Per User

25

£15.40 /user/month

£385.00

 

Premium Per App

2 080

£4.10 /user/app/month

£8 528.00

Power Automate

Premium (Service Account)

1

£12.30 /user/month

£12.30

Power BI

Pro

25

£10.80 /user/month

£270.00

Dataverse

Built-in entitlement

N/A

 

£0.00

Total

 

 

 

£10,203.30

 

Alternative: Power Pages Portal

For high-volume customer ordering, consider Power Pages in place of 2 000 Premium Per App seats:

 

  • Power Pages Authenticated Users:
    $200 per 100 users/site/month (US list price)
  • Solestyles Example:
    2 000 customers → 20 × $200 = $4 000/month (approx. £3,200.00 at current rates)

 

End-User Experience

Customers authenticate via a branded web portal rather than a Canvas App. They can browse the catalogue, add to cart and check out – all backed by Dataverse. While this removes on-device offline support, it cuts licensing costs by over 60%.

 

Cost-Control Strategies
  • Archive Stale Data: Off-load records >12 months old to Azure Blob Storage or SharePoint to stay within built-in Dataverse entitlements.
  • Leverage Microsoft 365 Add-Ons: Business Standard includes standard Power Apps (basic connectors) and Automate rights  – provision Premium licences only for users requiring premium connectors or Dataverse.
  • Portal vs Premium Per App: Use Power Pages for external users to slash per-app seat costs, at the trade-off of online-only access.
  • Service-Account Automation: Centralise all flows under a single Premium licence rather than licensing each staff user.

 

By aligning all staff on Microsoft 365 Business Standard (for Office, email and Teams), licensing Power Apps only where premium capabilities are essential, centralising automation under one account and archiving older data, Solestyles Boutique sustains its end-to-end low-code platform for ~£10,200.00 / month delivering a fully supported, scalable solution at a fraction of the unoptimised TCO.

 

The Future of Power Platform & AI

Innovation never sleeps especially in the realm of low-code. Microsoft’s Power Platform is rapidly evolving, embedding AI at every layer to accelerate development, sharpen insights and infuse your business processes with generative intelligence. Here’s what Solestyles Boutique can expect (and pilot) in the months ahead:

 

 
Copilot Studio & Copilot Hub

Copilot Studio has emerged as the central workspace for designing AI-driven agents across Canvas, Model-Driven and Power Pages. Released in the 2025 Wave 1 cycle, it now integrates the latest OpenAI models and offers:

 

  • Governance & Auditing via Microsoft Purview and Azure Sentinel, capturing end-user AI interactions.
  • Centralised Management: A unified Copilot Hub in the Power Platform Admin Center provides best-practice templates, cost insights and rollout controls.

 

These enhancements mean Solestyles’ IT team can safely extend Copilot-powered aides; for example, a “Stock Advisor” agent that suggests reorder quantities based on real-time sales trends while maintaining full visibility and compliance.

 

AI Builder Enhancements


AI Builder now delivers deeper decision and content intelligence:

 

  • Document Processing Agent: An out-of-the-box model tailored for invoice and delivery-note scanning—ideal for Solestyles to automate returns and archives at scale.
  • Enhanced Prompt Engineering: Integrated into Copilot Studio, these tools let makers fine-tune AI actions, reuse prompts across solutions and monitor inference costs.
  • Validation Station: A new interface for human-in-the-loop reviews, complete with audit trails and rollback capabilities. 

 

By leveraging these features, Solestyles could, for instance, automatically extract order details from emailed PDFs, reducing manual entry and errors.

 

GenAI in Power Automate

Generative AI isn’t just for chat; it’s woven into Power Automate flows:

 

  • Dynamic Summaries & Routing: Use AI to summarise customer notes, auto-categorise special orders and route them to the correct buying team.
  • Code & Expression Generation: In child flows, embed GPT-powered steps that draft complex switch conditions, expressions or adaptive cards on demand.

 

Imagine a flow that, based on an uploaded design brief, suggests product categories, price tiers and marketing copy accelerating special-order campaigns with minimal manual coding.

 

Tenant Copilot & Agent Factory


Microsoft’s internal roadmap hints at Tenant Copilot and an Agent Factory tools for spinning up AI agents configured to your tenant’s data:

 

  • Digital Twin Setup: Tenant Copilot can scan your environments, security roles and data models to recommend architecture optimisations.
  • Agent Factory: A framework for mass-deploying, monitoring and retiring business agents (e.g. weekly sales briefing bots) across teams.

 

Solestyles could pilot these in a sandbox letting a “Promotions Agent” analyse past campaigns and propose new seasonal offers without draining internal development resources.

 

Practical Next Steps
  1. Pilot Copilot for Makers: Enable Copilot Studio in a dedicated sandbox, assign “Copilot Maker” roles and run a proof-of-concept chatbot that answers product-catalogue questions.
  2. Governance Blueprint: Define Purview policies and Sentinel alerts for AI usage, ensuring data privacy and ethical AI practices from day one.
  3. AI Builder POC: Use the Document Processing template to ingest last quarter’s invoices; measure throughput improvements and error rates.
  4. GenAI Flow PoC: Create a Power Automate flow that summarises daily sales emails into a Teams message via the new AI actions.
  5. Monitor Costs & Usage: Leverage the Copilot Hub’s cost insights to track AI consumption, adjusting model selections (e.g. GPT versus Claude) for ROI.

 

By embracing these AI-driven innovations, Solestyles Boutique can transform from a data-driven retailer to an AI-augmented organisation unlocking rapid prototyping, intelligent automation and deeper customer understanding.

 

Conclusion & Next Steps

So, what does the Solestyles application look like today?

After a few months of iterative development culminating in a final four-week sprint of polishing, testing and user feedback Solestyles Boutique’s Power Platform solution now delivers a seamless, end-to-end retail experience. Below are the core screens that staff and customers will interact with:


Launch Screen

 

 

This is the home page of the Application. From here, users tap Customer, Staff or Management to dive straight into the relevant experience.  The Assistance option is an AI agent configured to answer FAQ style questions.


Customer Gallery

 

A tablet-optimised product browse interface. Shoppers filter by size, colour or collection; product data and images cache for offline browsing.


Full Inventory

 

 

The Model-Driven App’s inventory view. Staff see real-time stock levels, low-stock warnings and can raise special orders or adjust counts with a single click.


Inventory Management Report

 

An embedded Power BI dashboard in the management portal, showing turnover rates, reorder recommendations and trend lines all kept fresh via scheduled and incremental refresh.

 

Next Steps
  1. User Acceptance Testing & Initial Version Sign-Off
    1. Run UAT sessions with each store manager to validate workflows and gather final feedback.
    2. Incorporate any last-mile tweaks before formal business sign-off.
  2. Training & Documentation
    1. Deliver role-based training workshops and publish a concise user guide (PDF and in-app help).
    2. Record short “how-to” videos for common tasks: placing an order, approving a markdown, running the inventory report.
  3. Go-Live Rollout
    1. Launch in pilot phase: three stores first, monitor Application Insights telemetry and CoE dashboards.
    2. Proceed with full rollout once stability and performance meet SLAs.
  4. Ongoing Support & Improvement
    1. Establish a monthly governance call to review usage, performance metrics and backlog items.
    2. Plan quarterly enhancements – AI-driven chatbots in Copilot Studio, deeper Power BI analytics and new Power Automate flows.

 

With these final steps, Solestyles Boutique will transform from a proof-of-concept to a production-grade, low-code platform – empowering staff, delighting customers and providing leadership with data-driven confidence.


Thank you for following the Solestyles series! We invite you to share your own Power Platform stories or pose questions below

 

Afternote!! at the time of writing, a number of changes to Solestyles size and requirements caused substantial delays in the work that could be completed.  The Application has been deployed and is being massively used, whilst also generating a freedom-of-thought regarding business processes, improvements and next steps/future requirements. 

Leave a Reply

Mark Tonks
aka. SharePointMark

Microsoft Solution Architect, Senior Project Manager, and Mental Health Advocate

Mark Tonks
Business Links