Real world automation stories with Microsoft Power Automate

This post contains a set of automation stories curated by the Power CAT team with a focus on robotics process automation (RPA) in Power Automate.

There are over 350,000 organizations using Microsoft Power Automate each month to automate their processes. These stories showcase how individuals and organizations are leveraging the breadth of capabilities in Power Automate to automate their processes.

From citizen developers with no formal programming background to seasoned “pro-devs/ RPA devs” to partners with decades of software experience to IT pros managing cloud services and infrastructure, several have setup an Automation Center of Excellence and are cultivating communities of makers to further expand low code development throughout the organization.

For a longer list of curated stories, videos and presentations on Microsoft Power Platform, visit and explore more Power Automate customer stories.

T-Mobile adds RPA to their Six Sigma toolbox with Power Automate Desktop, Process Advisor and AI Builder

Brian Hodel is a Power Platform developer at T-Mobile with a background in Six Sigma, continuous process improvement and RPA using Winshuttle. In this session Brian, shares his journey from an automation developer perspective. He shares how he started with cloud flows in Power Automate, leveraged Power Automate Desktop to migrate legacy systems and process 12x more requests with no data errors; use process advisor to optimize how to automate the process, AI to automate manual tasks of data entry and chatbots to enable users to self-serve themselves. Brian also shared his views on shadow-IT, key pillars of COE and Power Platform benefits.

Speakers: Brian Hodel (Power Platform Developer, T-Mobile)

Themes: Pro-dev adoption of Power Automate, Center of Excellence.

Watchlink

Pembina embraces citizen development

Jeff Hiscock, an IT Enterprise Architecture Manager at Pembina Corporation, based in Calgary, is helping lead the vision and strategy to enable more business units drive rapid automation with Microsoft Power Platform. Cameron Relke is a Commercial Analyst in the Transmission Business Unit, who, as a citizen developer has innovated within his business through adopting Power Automate Desktop. By doing so, he has automated the mundane aspects of his own job and advanced his career. Learn from Jeff and Cameron on how they’re collaborating across IT and business units to scale rapid automation with the Power Platform.

Speakers: Jeff Hiscock (IT Enterprise Architecture Manager, Pembina), Cameron Relke (Commercial Analyst, Pembina)

Themes: Citizen development, Center of Excellence, IT + Business partnership

Watch:  link

Hanover Insurance drives business and IT-led automation with Power Automate Desktop (RPA)

With a mission to be the premier P&C franchise in the independent agency channel, Hanover Insurance is a leading provider of specialized property and casualty insurance products to individuals, families, and businesses. In this session, hear from business leader Mina Rona and Automation leader Prashant Hinge on how they have leveraged Power Automate Desktop and Power Apps to automate the manual time-consuming tasks spent on the underwriting process. This has saved Hanover hundreds of hours and inspired the team to think of more opportunities for automation to save for their skilled staff.

Mina Rona is Vice President and Chief Underwriting Officer with over 24 years of experience in the insurance industry. Prashant Hinge is Assistant Vice President responsible for innovation and strategic integration. In addition to the technical solutions, this story highlights the strong collaborative partnership that have made the strategy and implementations a success.

Speakers: Mina Rona (Vice President and CUO, Hanover Insurance), Prashant Hinge (AVP Innovation and Strategic Integration, Hanover Insurance)

Themes: IT + Business partnership

Watchlink

Hanover Insurance

Coca-Cola Bottling Company United dispenses streamlined order management with RPA in Microsoft Power Automate

Coca-Cola Bottling Company United (Coca-Cola United) supplies Coca-Cola products directly to 200,000 retailers and restaurants. When Coca-Cola introduced its new Freestyle vending machine, which depends on cartridges that are delivered to the customer, Coca-Cola United needed to streamline its order and invoicing procedures to scale to demand. “Coca-Cola innovation collided with our supply chain system,” says Bob Means, Director of Business Solutions at Coca-Cola Bottling Company United. “Replenishing the high-tech, small flavor cartridges was best done by outsourcing production, but it created a back-office nightmare.”

Processing a cartridge replacement required a dedicated customer relationship management (CRM) agent to manually push it through a complex 11-step process involving multiple disparate systems, such as SAP and more. A single agent could service only 50 Freestyle orders; however, nearly 50,000 orders were in the queue.

Power Automate provided an ideal solution, automating repetitive processes across Windows and web applications. Now, when a CRM agent enters an order into the CRM system, a desktop flow (RPA) signs into the SAP system, accesses orders that are tracked in a Microsoft Azure SQL database rather than an Excel spreadsheet, and creates a purchase order. The flow then submits the order to the supplier’s web applications and monitors the email system for invoice and delivery emails, and extracts information from the attachments to close the process in the Accounts Payable system—all using desktop flows (RPA) running in unattended mode, a key capability of Power Automate. The solution was built by Happiest Minds, a gold competency member of the Microsoft Partner Network

Speakers: Allan McDaniel, Bob Means

Themes: IT + Business + Partner built solution

Watchlink | customer story

Manual Freestyle cartridge replacement before RPA
Manual Freestyle cartridge replacement before RPA

TC Energy – Bot Wars | Entrepreneur reimagines how we work

TC energy describes how they have empowered business technologists – putting technology in everyone’s hands – not just to use it, but to build it. They have posted a blog on their website for details.

Themes: Citizen enablement

Linkblog post on customer’s website

Microsoft IT automates revenue processing with Power Automate

Every day, hundreds of millions of transactions are processed through Microsoft Power Platform, in a massive operation that runs 24 hours a day, 7 days a week. Because so much of the case management surrounding those transactions involves manual work, the sheer volume means a degree of inefficiency and human error is unavoidable. Modern systems have the advantage of APIs to eliminate that inefficiency and the possibility of human error. For legacy systems that don’t have the luxury of an API, RPA accomplishes the same thing.

For the thousands of BPO agents stationed throughout the world, using RPA as a virtual worker to replace agents for mundane, repetitive tasks frees them up for more impactful work. To date we’ve incorporated 1,100 business rules into RPA, which translates to upwards of 10 million instances of those rules being automated bringing the efficiency and security of digital transformation to legacy revenue processing platforms.

Themes: IT-pro

Link: customer story

Microsoft IT automates revenue processing with Power Automate

Aioi Nissay Dowa builds citizen developer culture, drives innovation with Microsoft Power Platform

Aioi Nissay Dowa Insurance, Japan’s largest insurance company, has created a virtuous cycle in which Microsoft Power Automate Desktop flows are used to optimize citizen developer training and certification processes. This helps empower citizen developers in the company, who in turn have become catalysts for accelerating their digital transformation.

Using the robotic process automation capabilities in Microsoft Power Automate, the company built an on-demand e-learning portal to support employee training and certification for Power Apps model-driven app development.

Aioi Nissay Dowa is on track to increase its citizen developer certifications by 350 percent and reduce its training costs by USD1.4 million, transforming its company culture to foster a more proactive, innovation-driven employee mindset.

Speakers: Takashi Yano

Themes: Citizen development

LinksMBAS presentation | customer story
Aioi Nissay Dowa builds citizen developer culture, drives innovation with Microsoft Power Platform 

Related links