Meet the developers combining Power Platform and Azure to go faster
Software developers around the world are embracing low-code as a powerful part of their toolkit — they look at Power Platform as the next layer of abstraction that reduces repeated work, adds to their skill set, and lets them focus their coding energy on the problems that matter most. The increased level of productivity is also changing the way these developers work with their users — as fusion teams creating a much more active and rewarding environment for building impactful solutions faster than ever before.
Let’s meet a few of these developers and look at examples of solutions built using Power Platform along with Azure services.
Quick links: Stories | Architecture examples | Resources
At Western States Caterpillar, Chris used Power Apps with custom connectors to equip field staff with mobile apps that integrate with internal and external systems. Chris has added Power Platform skills to his 20+ years of experience building .NET apps and full stack solutions. Learn more here.
“We love where Microsoft is going with ‘low code meets pro dev’.”
Tae is a Power Platform and Dynamics 365 Technical Lead with 18+ years of experience building solutions using Visual Studio, .NET, Azure Functions, and PCF controls, and managing ALM processes using Azure DevOps.
At Blackmores Australia, Tae helped develop enterprise grade solutions using Dynamics 365, Power Platform and Azure. Learn more here.
Dawood is CTO at BezoMoney in Accra, Ghana. As a developer, he has broad experience with tools such as Microsoft Azure, CosmosDB, Visual Studio, Python, PHP, etc. He expanded his skillset to include Power Platform and built low-code solutions to help onboard new team members.
“I double up in many places and in many roles as a CTO and a community builder. I use Power Platform to save tons of time.”
At Avanade, Samantha is a Senior Power Platform Consultant with a computer science degree who has leaned on her code-first and low-code development skills to build business application solutions for the past 5+ years.
“Working as a full stack developer I was used to building most custom components from scratch. That’s what I love about working with the Power Platform, that if I ever need a custom UI component or a background process, I can easily build that in a fraction of the time.”
As a Senior Automation Developer with 8+ years of experience in the City of Ottawa IT team, Jeffery has built Power Virtual Agents chatbots, trained citizen developers, and integrated Power Platform solutions with Azure DevOps and external APIs. Learn more here.
“We integrated Power Platform with Azure DevOps, which allowed us to do source control, automated pipelines, and release approvals.”
As a Principal Developer at T-Mobile, Brian has utilized his solution architecture, business analyst and Lean/Six Sigma skills to develop business critical applications using the entire spectrum of Microsoft Power Platform products. Learn more here.
“Microsoft Power Platform gives you access to a set of tools to solve an array of challenges in a variety of ways. It is accessible to everyone, from beginners to pro developers.”
A selection of customer stories that feature code-first developers building solutions using Microsoft Power Platform along with Microsoft Azure.
A team of full stack developers used Dynamics 365 and Power Platform, including Microsoft Dataverse, to consolidate and unify data from 10+ systems. There was no off-the-shelf solution that met their needs. Using a low-code plus code-first approach enabled them to develop the solution cost-effectively and has resulted in efficiencies such as 50% percent reduction in the time taken to process supplier reports.
City of Ottawa
City of Ottawa IT used a fusion development approach to deploy an external facing chatbot for citizens and an internal chatbot for employees. The chatbot built using Power Virtual Agents uses Power Automate and custom code to integrate with multiple internal and external systems. It has handled over 48,000 chats in a six-month period, saved 4,000 phone hours, freed up the time of 2.5 employees to focus on other tasks and saved over CAD 240K.
Coca-Cola Bottling Company United
Power Automate desktop flows were used to automate complex back-end processes for managing vending machines cartridge replacements. In addition to Power Automate, the solution uses Power Apps, AI Builder, Azure Blob Storage and Azure Key Vault. The solution has freed up existing Coca-Cola United employees to work on higher value tasks and eliminated the need to hire 10 additional full-time employees to handle the increase in orders.
Ecolab leveraged Power Platform integrated with Dynamics 365, Azure, and Microsoft 365 to build “The Hub” – a unified mobile app for field staff to manage several sales and service processes. All data is centralized in a single location, sales reps no longer waste time trying to remember which tool to use for what data, the time to train a rep has greatly improved, and when traveling the can access saved information in the app while offline.
FortisAlberta won a Canadian Safety Technology Award for this Microsoft Power Platform solution used to more efficiently document Injury Prevention Plans (IPPs). They transitioned away from paper forms to using Power Apps and Power BI. The solution, built by Fidelity Factory, uses Azure SQL to store data and Azure App Service and Blob Storage to process and store audio files.
G&J Pepsi has digitally transformed their organization using Microsoft Power Platform, Dynamics 365 and Azure services. They’ve equipped 900+ field personnel with mobile solutions that have saved the organization over $1.5 million.
IKEA Sweden partnered with implementation partner Capgemini to build a Dynamics 365 and Power Platform solution for its sales staff. The holistic solution has provided a single automated system for the sales team when engaging directly with individual customers (B2C) and businesses (B2B).
Greeters at the bank branches use a tablet app, built using Power Apps, connected to Dynamics 365 to welcome customers and manage the appointment experience during the customer visit. Azure functions are used to calculate and optimize wait times.
Nsure.com is a proprietary online insurance shopping platform that enables consumers to transparently compare home and auto insurance quotes from more than 50 top-rated insurers and purchase a policy within minutes. A back-end system driven by Power Platform, Dynamics 365, and Azure services automates much of the process. The automation has resulted in over 50% of their customers completing their insurance purchasing without having to speak to an agent.
Priceline stores (Australian Pharmaceutical Industries)
James Matson shares his journey and perspective as a professional developer adopting low code technologies to optimize retail store operations. His in-store solutions integrate with multiple cloud services and have enabled retail operations employees to have near real-time data available on their mobile devices.
Rabobank is the second-largest bank in the Netherlands, with more than 40,000 employees in 38 countries. As part of a broad digitization strategy, Rabobank adopted Power Platform to streamline internal processes and today runs more than 2,500 Power Apps and Power Automate solutions, built in partnership between code-first and citizen developers. Over 55% of the entire organization uses Power Platform solutions. As one example, a “Reorganization App” built to assist HR and managers has reduced an analysis that used to take three weeks down to three minutes.
Toyota has established a center of excellence to enable makers across the organization to build solutions. They’ve extended Power Apps development with Microsoft Azure Cognitive Services and Azure Machine Learning to create an accessory installation app that uses computer vision to look at vehicles and determine whether they are equipped with the appropriate equipment and whether that equipment is in the desired condition.
Western States Caterpillar
Western States Caterpillar Equipment Company is an authorized Caterpillar dealer with seventeen branches in the United States. Pro-developers in the IT team built mobile Power Apps solutions in collaboration with business teams. The apps connect with multiple internal and external systems and are used to manage equipment rentals, sales activities, and more. As a result, rental returns across their $140M fleet of equipment can now be processed and equipment made ready to rent again within a single day.
Solution Architecture Examples
These are a few of the many real-world solution architecture examples that show how low-code capabilities in Power Platform are used in conjunction with code-first programming patterns and capabilities in Microsoft Azure.
Rabobank – Scaling adoption across the organization
Rabobank is the second-largest bank in the Netherlands, with more than 40,000 employees in 38 countries. As part of a broad digitization strategy, Rabobank adopted Power Platform to streamline internal processes and today runs more than 2,500 Power Apps and Power Automate solutions. Power Platform was recently chosen as the default platform for all internal application and business process automation development.
As Rabobank moved to a new, digital model, the bank has been reorganizing its workforce to better align to that model. But the process was time-consuming. Previously, HR professionals would spend weeks pouring over Excel spreadsheets matching employees with new job roles. The problem was not just manual processing. Even more challenging was the sheer volume of data and analysis required.
They built a solution called R@app (Reorganization App) that uses Power Apps, Power Automate, Power BI, SharePoint, Bing Maps, Azure SQL, and Azure Data Factory. It integrates with Workday, the bank’s HR system, and leverages customized Python algorithms.
The solution was delivered right on schedule and performance was even better than expected. To quote the customer, “With our reorganization app (R@pp) built with Power Platform, analysis that used to take three weeks can now be done in three minutes. Better yet, we have achieved a placement accuracy of 99.1%, which is far higher than what we could manage previously.”
For more details: Read the Rabobank story
The business process flow for the bank’s reorganization app called R@pp.
EY – Loan forgiveness portal
When the COVID-19 pandemic hit the United States, the government passed the Coronavirus Aid, Relief, and Economic Security (CARES) Act, which included financial support for small businesses. This support was provided under the Paycheck Protection Program (PPP), and it included loans as well as forgiveness on qualified expenses. The scope was huge, and banks had to rapidly respond to manage tens of thousands of applications.
As the loan forgiveness program evolved, the eligibility criteria kept changing, making it difficult to calculate forgiveness levels and process claims. Moreover, because PPP was set up as a temporary program, stakeholders wanted minimal investment in infrastructure and operating costs.
A team of professional developers in the Low Code Services area within the Client Technology division at EY turned to Microsoft Power Platform and Azure and were able to successfully stand up a solution within weeks as opposed to months. The solution that EY created consists primarily of two different applications: a borrower portal using Power Apps portals, and the lender application using a Power Apps model-driven app. Both interact with the same data that is stored within Dataverse. The solution works seamlessly with multiple third-party services using both prebuilt and custom connectors. This ability to connect with multiple third-party services was one of the most important aspects of the solution. It’s what enabled the tool to cover the entire application process and submit a complete loan forgiveness application—something other competitors couldn’t match.
Diagram showing the complete solution architecture, including connectors to multiple services covering user authentication, data verification, and submission.
Blackmores Group – Enabling rapid development of new products
Blackmores Group is a highly regarded Australian health supplement maker. In a field where new product development plays a key role in maintaining market share, time is critical. Blackmores wanted to uncover the insights it needed to hasten product development and costly off-the-shelf options didn’t quite fit the company’s requirements. After successfully using Dynamics 365 and Power Platform to develop several solutions for areas such as employee coaching, vendor management and portfolio management, the fusion development team at Blackmores, consisting of professional developers and analysts, embarked on an ambitious effort called ‘Project Lucky’. This would serve as a central platform that brought together key data that was scattered among 10 siloed business systems.
The team designed Project Lucky as a central platform that brings together data scattered among 10 siloed business systems. It uses Dataverse as the data repository and incorporates a broad spectrum of Azure services, including Azure Functions to easily connect data sources for easier processing and faster reaction to events. The team uses Azure Data Lake Storage to scale and secure its data lake with encryption at rest and for advanced threat protection. With the Application Insights feature in Azure Monitor, the team gains a rich outlook across applications that accelerates proactive remediation. Blackmores relies on Azure Event Hubs, a fully managed, real-time data ingestion service. A future version will incorporate Azure Machine Learning and other AI capabilities in Azure.
“Our team treats Power Apps and Azure as one platform that we use to build our solutions… Our ability to extend Microsoft Power Platform with Azure gives us the confidence to use it for complex projects like Project Lucky.”
Solution architecture diagram for Project Lucky – includes integration between Microsoft Platform, Azure, Teams, Project for Web and existing internal systems.
IKEA Sweden – Reimagining the customer experience
IKEA Sweden partnered with Capgemini, a Microsoft Gold Partner, to build a Dynamics 365 and Power Platform solution for its sales staff to improve the kitchen buying experience for individual customers (B2C) and businesses (B2B). This project enabled tracking of the sales process from the first meeting with the customer to the installation of the kitchen and contributed toward IKEA realizing the vision of having a holistic single view of the customer over the lifetime of their relationship.
The IKEA Sales Tool solution consists of four apps:
- Kitchen App: Used by in-store hosts to get an overview of customer bookings, manage resources (co-workers) and schedule drop-in customers to meet with sales specialists. Store managers and team managers use the app for reporting on key statistics.
- Co-Worker App: All IKEA employees are internally referred to as “co-workers.” In-store sales specialists use this app to start and end in-store customer meetings, add meeting notes, update revenue details, and book revisits.
- B2B App: Used to manage the business-to-business sales pipeline. It is the first attempt to create a single customer view for IKEA’s B2B customers, with data consolidated from multiple sources.
- Customer Support Center App: Customer Support Center agents use this app to book, rebook or cancel appointments on behalf of customers.
The solution architecture includes Dynamics 365 Sales and Power Apps model-driven apps as the front-end experience. Dynamics 365 Field Service is used for scheduling and distributing appointments. Power Automate is used for automatic updates of status fields and sending notifications. All data is stored in Dataverse. Azure Logic Apps is used to email customer meeting summary notes and quotes. Azure functions are used for complex and time-consuming custom business logic. Azure blob storage is used for secure storage of information. Azure Key Vault is used for managing credentials and storing access and security related data in the cloud.
For more details: Read the IKEA Sweden technical case study on the Power Apps blog
Solution architecture diagram for the IKEA Kitchen Tool solution
Western States Caterpillar: Mobile apps for the field
With a thriving rental business across several stores in the United States, Western States Caterpillar turned to Microsoft Power Platform to modernize and transform two critical business processes that were fundamental to their growth:
- Managing the rental return process in a way that reduced turnaround time – “Return to Ready” app
- Enabling sales teams in the field to better understand their prospects and customer spend – “Client Connect” app.
The Strategy & BI Solutions team followed a ‘low-code plus code-first’ development pattern for both their Return to Ready and Client Connect apps. Both apps read equipment and customer spend data from a SQL Server database which is a replication of their Microsoft Dynamics AX 2012 ERP data. The retrieve and write of data and events are performed through a Power Platform custom connector which interacts with custom web APIs developed in ASP. NET Core. The two apps have been developed with Power Apps. All pictures taken from the Return to Ready app is handled by an Azure hosted web API that leverages Azure Blob storage. The AI Builder Business Card scanner is used by the Client Connect app to create prospects and contacts easily across all their stores. All information of their rentals and sales created and updated in the apps are surfaced into Power BI reports.
Screenshot of swagger definition file for the custom connector
High level solution architecture that combines low-code and code-first development patterns
- Microsoft Power Platform is the best way for teams to build together – blog post with resources
- Pro-dev features and learning paths – E-book | learning path | Build conference session | webinar
- New Power Apps developer plan – get started | documentation
- Microsoft Mechanics episode on pro-dev adoption of Power Platform – blog | video
- Low code application development on Azure – landing page | YouTube video playlist | tours
- Power Apps and Microsoft Azure better together – landing page | TEI report | ROI calculator
- POWERful Devs virtual conference and ongoing videos – video series
- Additional pro-dev topics:
- Azure APIM Connector on the Power Platform – blog post
- GitHub actions for Power Platform – blog post
- Power Apps for enterprise developers – documentation
- Register and use custom connections – documentation
- Build and certify your own connector – blog post | documentation
- Power Apps Component Framework (PCF) – documentation | community gallery
- Calling Azure AD protected Azure Functions using a Custom Connector – blog post | documentation
- Register and use custom connectors in Power Apps