Power Community

Power Community

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

Chris Jaques

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-Rim Han

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 Iddris

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.”

Samantha Brown

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.”

Jeffery Kozera

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.”

Brian Hodel

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.”

Highlighted stories

A selection of customer stories that feature code-first developers building solutions using Microsoft Power Platform along with Microsoft Azure.

customer story

Blackmores
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.


story

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.


customer story

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.

MBAS presentation

Ecolab
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.

customer story

EY
EY has implemented multiple complex digital solutions built by code-first professional developers working in fusion teams. They use Power Platform with Dataverse as the primary data store, along with Azure, and integrate with several third-party services. Scenarios include – processing emergency loans for small businesses, managing global employee mobility, transforming an annual salary review process, helping executives manage quality and risks, and more. The loan processing app alone has been used to process over 50,000 loans totaling more than $10 billion on behalf of its banking customers.


customer story
FortisAlberta
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.
customer story
customer story

G&J Pepsi
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.

customer story

IKEA Sweden

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).
Ignite presentation with demo

Metro Bank
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.


customer story

NSure
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.

customer story

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.


customer story

Rabobank
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.

customer story - Power Apps

Toyota
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.


video

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. The solution includes integration with Workday, the bank’s HR system, and a customized Python algorithm.

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.

For more details: Read the EY-PPP customer story | Watch the EY-PPP presentation | Watch the EY-PPP video

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.”

– Tijn Tacke, Head of Business Applications, Blackmores Group

For more details: Read the Blackmores customer story | Watch the Blackmores presentation

Solution architecture for 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 AppUsed 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 solution

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.

For more details: Read the Western States Caterpillar technical case study on the Power Apps blog

Screenshot of Swagger definition for custom connector

Screenshot of swagger definition file for the custom connector

Solution architecture diagram for Western States Caterpillar mobile apps built using Microsoft Power Platform and pro-code extensibility.

High level solution architecture that combines low-code and code-first development patterns

Resources

Video thumbnail to launch 'Power Platform loves Developers' montage video

Watch developers from around world share their perspective on adopting Power Platform to go faster

Related links

90+ Power Platform customer stories

60+ Power Platform customer story videos

Power Champions

Customer presentations at Microsoft Business Applications Summit (MBAS)

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisement -spot_img

Latest News

- Advertisement -spot_img

More Articles Like This

- Advertisement -spot_img