Power Community

Power Community

Power Apps Portals

Announcing the preview of Microsoft Power Pages

Sangya Singh, Chief Experience Officer, Power Platform, Tuesday, May 24, 2022 We are pleased to announce the preview of Microsoft Power Pages, the fifth product in the Microsoft Power Platform family. For years, organizations have been using Power Apps portals as a fast, easy way to create business websites and add to existing sites. Now, as a new, standalone product, Power Pages empowers anyone, regardless of their technical background, with an effective platform to create data-powered, modern, and secure websites. In addition to being low-code, Power Pages extends far beyond portals former capabilities to enable organizations of any size to securely build websites with exciting new aesthetic features such as a versatile Template Hub, Design Studio, and other advanced capabilities for customization with pro-dev extensibility. As part of the preview, we’ve added new features that will impress even the most advanced developers on your team. This includes options to extend your low-code site by leveraging tools like JavaScript, Liquid templates, code components, and web APIs. Discover how Power Pages can help you build your next website with ease—and deliver real business value. Dive deeper in our Power Pages preview announcement and learn how you can sign up for a free Power Pages trial today.

Announcing rich text editor for Power Apps portals

We are happy to announce the rich text editor (RTE) can now be used with Power Apps portals starting with version 9.4.3.x. Feature capabilities This feature provides the following capabilities: Use the control with your text fields and allow your portal users to author and view rich formatted content. The rich text editing capabilities are powered by the same code component that is available for Power Apps. Prerequisites Your portal version must be 9.4.3.x or later. Check out the step-by-step tutorial documentation here for detailed overview and configuration. We are looking forward to your feedback as we march towards general availability Your feedback will help us continue to build on and improve the capabilities of this feature. We want to hear from you!

Announcing rich text editor for Power Apps portals

We are happy to announce the rich text editor (RTE) can now be used with Power Apps portals starting with version 9.4.3.x. Feature capabilities This feature provides the following capabilities: Use the control with your text fields and allow your portal users to author and view rich formatted content. The rich text editing capabilities are powered by the same code component that is available for Power Apps. Prerequisites Your portal version must be 9.4.3.x or later. Check out the step-by-step tutorial documentation here for detailed overview and configuration. We are looking forward to your feedback as we march towards general availability Your feedback will help us continue to build on and improve the capabilities of this feature. We want to hear from you!

Access Migration to Power Apps and Dataverse is released to General Availability

Beginning today, Microsoft Access users can migrate their data into Power Apps and Dataverse.  Customers who have the current or monthly channel for Microsoft 365 and Office can update their Microsoft Access to make use of the Dataverse Connector and migration tool. The Access migration tool and connector provided within MS Access streamlines the process of migrating tables, relationships, and data with setup taking just a few minutes, and migration handled for you. Figure 1. Access, Dataverse, and Power Apps With the GA of this feature, Access customers are now one-click away from unlocking the following capabilities for the data currently managed in an Access DB: New security and compliance capabilities through Dataverse cloud storage using Azure Active Directory and role-based security while managing it from Access The ability to have real-time sharing and editing of Access data using cloud-based data stores, with front-end apps created in Access, Power Apps Mobile and Microsoft Teams  New front end app scenarios on mobile devices or with Microsoft Teams Extending the ability for users to incorporate their existing data into Power Apps and Dataverse is an important feature. Almost every user who starts working with the Power Platform begins with existing data. By offering easier ways to migrate Access data to Power Apps, customers can implement apps, workflows, virtual agents, and perform analytics on data that was previously not available to them. The Access data will behave like any other Dataverse data once migrated. In addition, user’s Access forms and queries will continue to work uninterrupted, allowing a migration without business disruption. Figure 4: The workflow of migrating data from Access to Dataverse, with synchronous usage by Access forms and Power Apps. Today’s announcement expands and enriches the cloud story for Access and continues Power Apps and Dataverse’s commitment to helping users incorporate their existing content to enrich their business. Take the next step to migrate Access data to Dataverse and the Power Platform To test out this new capability you will need to have an existing Power Apps trial environment, Power Apps license, or Power Apps installed as part of your Microsoft Teams license. Talk to your administrator to confirm if your organization is on the current channel as of May 2022 for Microsoft 365 and try the new Dataverse Connector. Once you have updated your Access application, you will be able to start migration from within Access by right clicking a table and selecting Export and Dataverse. Figure 2: The Export menu in Access with the Dataverse option You can also open a table, select the External Data tab on the ribbon, and select Dataverse. Figure 3: MS Access Ribbon with Dataverse Export button Dataverse Options Users will have the option to migrate their Access data into Dataverse or Dataverse for Teams, allowing them to choose the capabilities that best suit their needs. Dataverse provides the full featured extensibility of the Power Platform providing citizen developers and development professionals alike the power to explore the possibilities of their data and share it across their entire organization, or externally using Portals. Dataverse for Teams provides the ability to create apps, flows, virtual agents and more within a team structure using Microsoft Teams, the collaboration tool of choice for the modern enterprise. If you are interested to take the next step and evaluate this powerful combination yourself, visit https://aka.ms/AccessAndPowerPlatform. For support documentation on how to migrate go here To learn more about these capabilities register for Microsoft BUILD and see two different on demand sessions that educate and demonstrate these capabilities. BUILD Session # OD122 – Title: Access Connector for Dataverse and Power Platform GA Launch BUILD Session # OD123 – Title: Pro developer capabilities of Power Apps and Dataverse for Access Developers

Updating ownership for Power Apps apps

Recently, a customer asked a question that we felt would be applicable to many of you responsible for administration of the Microsoft Power Platform: How does removal of an app owner’s profile from Azure Active Directory (AAD) impact access to the app? Before we answer that, you need to know that in Microsoft Power Apps, there are two different application types: Model-driven apps Canvas apps Model-driven apps and canvas apps manage their ownership differently. In this blog post, we’ll explain how to update ownership of each type of app. Note: If you need more background information about the two types of apps, watch The difference between Canvas Apps and Model Apps – YouTube or review Start building apps – Power Apps | Microsoft Docs and Power Apps architectural design – Where to place logic – Power Apps | Microsoft Docs Model-driven and Canvas apps manage their ownership differently. Model-driven app ownership In a model-driven app there is no concept of a co-owner. If the original owner/creator leaves the organization, what happens to the application? Users who already have the app shared with them can continue to use it. What if an update or maintenance is required? Well, our admins can help us here. Users with the role of System Customizer, System Administrator, or Environment Maker in the environment can manage the application but they don’t technically “own” the app. What happens when the owner leaves? Ideally, the owner would work with the organization during their outgoing knowledge transfer sessions: explain what it does, what are the use cases, who is the user-base, and hand over any documentation to a new owner. To change the ownership though you will need to export the application and re-import it under another user. If they leave without being able to do this, then admins noted above can do this. Deleting or removing the owner won’t have any impact on the performance of the app itself. For more information, see Model-driven app FAQ – Power Apps | Microsoft Docs. Below are some common questions relating to ownership and changes: Q: How do you change the owner? A: Export the app and re-import it as under another user. You will need to re-share the app to the users. Q: What happens if the original owner leaves? A: Users who already have access to the app can continue to use it. A: Ideally, the owner would work with the organization to export the application, explain how it operates and hand over any documentation. Q: What happens if we need to update the app? A: Admins can help here. Users with the role(s) of System Customizer, System Administrator or Environment Maker can manage changes to the application. Q: What happens if the owner’s account is deleted? A: Deleting or removing the owner won’t have any impact on the performance of the app itself. Canvas apps ownership Canvas apps, unlike Model-driven apps, can be co-owned or have the owner replaced. If an owner is leaving, they can share the app through the Maker portal. Note that this ownership change does not affect the users with whom it is shared. For more information please see: Manage Power Apps – Power Platform | Microsoft Docs On the other hand, if the owner of the app left without adding a co-owner an admin can change the owner through PowerShell. First, you will need Tenant Admin access. You will also need the Environment Id (envId) and App Id (appId). You will also need to specify the user Id; in this example we will change the ownership to your Id. Second be sure you have the Power App cmdlets installed. You can do this with the following commands. Run PowerShell in admin mode and enter: Install-Module -Name Microsoft.PowerApps.Administration.PowerShell Install-Module -Name Microsoft.PowerApps.PowerShell – AllowClobber If you already have the cmdlets installed, nothing will occur and you are good to go; otherwise, you will see the cmdlets installed. Next, run the Add-PowerAppsAccount cmtlet allowing you to add your account for Power Apps: Add-PowerAppsAccount Next, update the owner, using the appId and envId you found earlier: Set-AdminPowerAppOwner -AppName "" -EnvironmentName "" -AppOwner $Global:currentSession.userId When this command succeeds, the response is minimal, showing only a reference to app Id. The app is now “owned” by the new user. Reference documentation for the PowerShell commands: Add-PowerAppsAccount (Microsoft.PowerApps.Administration.PowerShell) | Microsoft Docs Set-AdminPowerAppOwner (Microsoft.PowerApps.Administration.PowerShell) | Microsoft Docs

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. BlackmoresA 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 OttawaCity 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 UnitedPower 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. EcolabEcolab 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. EYEY 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. FortisAlbertaFortisAlberta 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 G&J PepsiG&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 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). Metro BankGreeters 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. NSureNsure.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. RabobankRabobank 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. ToyotaToyota 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 CaterpillarWestern 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. 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 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. For more details: Read the Western States Caterpillar technical case study on the Power Apps blog Screenshot of swagger definition file for the custom connector High level solution architecture that combines low-code and code-first development patterns Resources 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)

Meet the developers combining low-code, Azure and Power Platform 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 that use 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 and 5+ years of experience developing business application solutions. “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 – Z) A selection of customer stories that feature code-first developers building solutions using Microsoft Power Platform along with Microsoft Azure. BlackmoresA team of full stack developers used Dynamics 365 and Power Platform, including Microsoft Dataverse, to consolidate and unify data from 10+ systems. 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. Coca-Cola Bottling Company UnitedPower 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. EcolabEcolab 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. EYEY 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 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 G&J PepsiG&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 IKEA Sweden partnered with implementation partner Capgemini to build a Dynamics 365 and Power Platform solution for its sales staff. The holistic solution improves the kitchen sales experience when engageing with individual customers (B2C) and businesses (B2B). Metro BankGreeters 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 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. Priceline stores (Australian Pharmaceutical Industries)James Matson shares his journey as a professional developer adopting low code technologies to optimize retail store operations. 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. ToyotaToyota 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. 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. 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 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. For more details: Read the Western States Caterpillar technical case study on the Power Apps blog Screenshot of swagger definition file for the custom connector High level solution architecture that combines low-code and code-first development patterns Resources 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)

Hearing Australia Audiologist adopts Microsoft Power Platform to transform hearing loss prevention program

Hearing Australia is Australia’s largest provider of government-funded hearing services for children, young adults, Aboriginal and Torres Strait Islander peoples, pensioners, and veterans. They have been servicing people with hearing loss in Australia for 75 years. The organization runs the Hearing Assessment Program – Early Ears (HAPEE) which is funded by a government grant and is dedicated to the prevention, early detection, and treatment of hearing loss in Aboriginal and Torres Strait Islander children aged 0 to 6 years old, not yet attending full time school. HAPEE has three key objectives: Provide training and support to local primary health care professionals and early childhood educators to help detect and prevent avoidable hearing loss. Provide awareness raising activities so that families can identify hearing loss and ear disease early on in their young children and learn practical ways to support their children’s hearing health. Provide diagnostic assessment and clinical services to communities. These three key objectives help Aboriginal and Torres Strait Islander communities assess and manage ear disease themselves. Jacqui Peck, an audiologist at Hearing Australia, recognized they needed a system to help Community Engagement Officers and Audiologists collect the information gathered from their community visits for HAPEE. However, the Information and Communication Technology (ICT) team did not have sufficient capacity to build the system, Jacqui took the initiative to find a low-code platform that she could easily learn and self-build the solution. She loved the ease of building Power Apps solutions with Dataverse. By partnering with code-first developers in the ICT team, development best practices were applied. From the development guidance received, Jacqui built two Power Apps model-driven apps, embedded Power BI reports, several Power Automate cloud flows and utilized the built-in Dynamics 365 Apps for phones and Outlook. The solution is actively used today by more than 100 Community Engagement Officers and Audiologists who are now able to collect and update data from their mobile devices, even when visiting remote communities with no internet coverage. This article describes how Jacqui adopted Dataverse and Power Apps model-driven app to build a low-code solution for the HAPEE program. This solution later won the Australian Information Industry Association’s ACT Division Government and Public Sector Solution of the Year Award, and over the past year Jacqui’s career has evolved from being an audiologist to a low-code developer and analyst in the ICT team. Business Challenge All clinical aspects of Hearing Australia’s services are covered in their current IT systems. HAPEE was a new initiative that required the collection of additional non-clinical information – something that was not easily available in existing systems. As new programs take time to mature, Jacqui had found the information for HAPEE was in a fragmented form for their Community Engagement Officers and Audiologists which caused several issues: It was difficult to circulate their efforts with the Aboriginal and Torres Strait Islander communities to other stakeholders in the program. They lacked access to the most up-to-date information when visiting communities. This includes latest information on the community of their next visit, such as activities that had already taken place and what considerations and customs needed to be followed to provide culturally appropriate services. These issues were impacting the team as they were spending a lot of time in finding and updating the information. It was labor intensive, and as the program expanded, limitations of the existing systems became more apparent. Jacqui Peck’s journey adopting low-code Jacqui has over 13 years of experience in adult rehabilitation and pediatric audiology across Australia and New Zealand. In 2019 Jacqui joined Hearing Australia as a pediatric outreach audiologist for the HAPEE program, visiting remote areas of Australia to work with Aboriginal and Torres Strait Islander communities to prevent hearing loss in young children. The HAPEE program was new at the time and Jacqui saw the need for a better way of managing HAPEE’s data and information. Her original idea was to have a paper form where all information needed by Community Engagement Officers and Audiologists was available in one place and could be printed prior to a community visit. However, using manual forms and other data sources such as Excel spreadsheets would still result in duplication of information leading to difficulties in updating and maintaining the information long term. Additionally, it was difficult to know if the information being viewed and acted upon from a paper form was the most up-to date or if there was newer information available. Jacqui realized she needed a digital solution for HAPEE but their ICT team had no capacity to work on a new project. Determined to come up with a solution, Jacqui explored the Power Platform as a low-code approach to fill the gap – it ticked all the boxes. She learnt everything she could about Power Apps and Dataverse during a 3-month stint in the Australian outback where she was testing ears by day and building apps at night. With Jacqui’s business knowledge and the ICT team’s code-first development experience, together, as a fusion team, they developed the “HAPEE Operations Hub” solution for Hearing Australia. This reduced dependency on the ICT team for development and accelerated the delivery of a much-needed solution for HAPEE. “Power Apps really allows us to create our solutions, so building something, rebuilding it, refining it, and getting it up to the minimal viable product point of maturity. And that way, ICT has a really clear idea about working with the product that we already know works.” – Jacqui Peck, Low-Code Developer and Analyst, Hearing Australia As a result of Jacqui’s dedication to HAPEE, her willingness to learn new skills and her partnership with the ICT team, Hearing Australia developed a low-code Power Platform solution that is now used by over 100 Community Engagement Officers and Audiologists in the remote communities of Australia. Later in 2021, this solution led to Hearing Australia winning the Australian Capital Territory Government Public Sector Solution of the Year award from the Australian Information Industry Association. Jacqui is now part of the ICT team as a Low-Code Developer and Analyst where she continues to champion building low-code solutions. HAPEE Power Platform solution Dataverse as the foundation After developing a minimum viable product for HAPEE and gaining approval from the ICT team, Jacqui was provided with her own environment to build the next version of the HAPEE solution. Jacqui and the ICT team decided early on to build on Dataverse as the data source. This was important as Jacqui realized using SharePoint or Excel would not be a scalable solution for HAPEE as they grow exponentially. With complex data they needed the ability to see all the links between their data – between the people who work in the community, the community members themselves, the cultural information they need to capture, the site visits, as well as manage and monitor hundreds of items of equipment and people Australia wide. Having a relational database in Dataverse provided a scalable solution and the team were able to gain insights through the built-in dashboards in Power Apps model-driven apps. The capabilities extended further by incorporating Power BI visualizations, using the Dynamics 365 app for phones and the Dynamics 365 App for Outlook. Solution architecture diagram of the Power Platform HAPEE Operations Hub solution. HAPEE Operations Hub This is a Power Apps model-driven app that is the front-end user interface for all Audiologists and Community Engagement Officers. All users can access the app anywhere including remote locations with offline capabilities through an additional offline model-driven app. The records in the app are designed in a way that enables easy visibility into their level of engagement and support with more than 200 Aboriginal and Torres Strait Islander communities. Hearing Australia can track the capability building of a clinic with the HAPEE Power Apps model-driven app, how well the clinic can support their health workers in providing hearing assessments to the Aboriginal and Torres Strait Islander communities. For visualization of how they’re tracking across the communities, they embedded Power BI reports with Bing Maps in the app. This allows them to see all community visits, including areas which may not have had a lot of activity and thus requires more attention from HAPEE. It also allows the program to track attendance rates to clinics and training. Power Automate acts as the central nervous system to the model-driven app and is used to refresh the dataset to generate the Power BI reports, sync data with a SharePoint Online list for historical data purposes, and automatically update fields with geolocation details. There is work underway to develop automation to notify users when training certificates expire and when equipment needs to be recalibrated. Embedded Power BI dashboard provides greater visibility of their reach and efforts across the communities. Community Engagement Officers and Audiologists have benefitted from additional capabilities that come built-in with Dataverse and Power Platform: The Dynamics 365 for phones and tablets app enables them to capture information instantly during onsite visits to communities in remote areas. The Dynamics 365 App for Outlook enables them to effectively track cases and enquires and received via email communications. The information is directly saved into Dataverse without them needing to leave Outlook. Left – Dynamics 365 for phones and tablets app, right – Dynamics 365 App for Outlook. “As an audiologist, I can now be out in the community with no internet and find the most up to date information on my phone or laptop offline. It was a game changer.” – Jacqui Peck, Low-Code Developer and Analyst, Hearing Australia Impact and key benefits Today there are over 100 Community Engagement Officers and Audiologists all over Australia entering and updating the information in the HAPEE apps which will continue to grow and evolve with the program. Some of the key benefits of the HAPEE solution are as follows: With Dataverse, Hearing Australia now has a single source of truth for information on their communities, clinics, audiology equipment, and how they are tracking for capability building, training, and awareness raising activities. The offline capability of the solution enables Community Engagement Officers or Audiologists to continue to work in remote areas during their community visits. Clinical Audiologists have accessible information on the communities they visit, which has improved their ability to provide services in culturally appropriate ways. They are able to provide the data required under the reporting requirements of the grant agreement. Upcoming Power Platform solutions Hearing Australia Outreach This is a Power Apps canvas app that Community Engagement Officers and Audiologists can use when visiting communities. It allows them to: Search where the community is and access the information on their location. View the profile of a community to ensure they are familiar with the cultural customs of the community prior to their visit. Access training and resources. Capture their awareness training activities during their community visit. Any information created or updated will be synced back to Dataverse and will be visible in the HAPEE Operations Hub model-driven app by the other users. Provides access to the cultural information of communities so that Community Engagement Officers and Audiologists can provide culturally appropriate services. An advantage of the app is that it allows Community Engagement Officers to quickly view the profile of the community prior to their visit and understand the customs and culture of the community. This is really important as every Aboriginal and Torres Strait Islander community in Australia is unique. HAPEE Equipment Portal Currently in development is a Power Apps portal that enables Hearing Australia’s HAPEE partners, such as the Department of Health, to monitor and directly update equipment details in the existing Dataverse instance. External partners will be able to see and update the same equipment details as the Community Engagement Officers and Audiologists. The information accessible through this portal includes: Equipment Catalogue: A list of equipment makes and models Equipment Units: List and details of individual equipment units/items, who they are allocated to, the condition and calibration status Organisations: A list of organisations where HAPEE services are provided, this may include parent organisations and stakeholders The portal will allow HAPEE partners to collaborate in a secure way and update equipment information used by the program. By extending the capabilities of the HAPEE program to external users, the portal will help Hearing Australia achieve greater collaboration for the good of the communities serviced Australia wide. Fusion team development Having citizen developers like Jacqui collaborate with code-first developers on the ICT team has enabled Hearing Australia to go further in creating solutions that work for their teams. With a small ICT team of code-first developers not familiar with the business knowledge, citizen developers can contribute to the development of enterprise solutions. Apps are developed in greater alignment to the business needs while staying in tune with code-first development practices. The outcome is far greater than working in isolation which is evident from Jacqui’s efforts as a citizen developer working alongside the ICT team. The partnership worked as follows: ICT team provided Jacqui with dedicated environments for development, testing and production usage to ensure the HAPEE apps were properly governed and are in a state where they can be merged into their enterprise solutions. Jacqui built the foundations of the apps – tables, columns, forms and focused on the user experience of the interfaces. When she needed further guidance on development best practices, she reached out to the ICT team for assistance. Together they worked in collaboration by communicating through Azure DevOps and as a method to track development efforts. “I can see a future where we will use Jacqui as a role model and do more of this user led innovation. We’re a small ICT team here and the benefit of getting developers across the organization would be fantastic. It’s a great story about using technology to benefit Australians.” – Mike Brett, Chief Information Officer, Hearing Australia Looking ahead The HAPEE apps have shown that through fusion teams, they are able to develop mature and functional apps that can integrate into their core systems by utilizing citizen developers who have strong knowledge of business operations combined with code-first developers to take the apps to the next level and ensure best practices are implemented. They are looking into creating a Centre of Excellence for Hearing Australia to enable fusion team development and achieve more with the Power Platform towards their needs. They also plan on integrating the HAPEE app with Hearing Australia’s core business Dynamics 365 applications FOCUS – Finance, Operations, Clinical and User System. In the future, Hearing Australia hopes to make information more accessible and relevant to the communities by allowing them to update the information themselves. “The most exciting thing I think is about being able to have a solution for the audiologists as well as the community engagement officers and it’s really an application that is built for HAPEE – to me that’s really important.” – Jacqui Peck, Low-Code Developer and Analyst, Hearing Australia Award acknowledgement In 2021 Hearing Australia won an Australian Information Industry Association award for the Australian Capital Territory in the Government Public Sector Solution of the Year category. To learn more about the award browse to the Australian Information Industry Association website. This is a testament to Jacqui’s efforts as a citizen developer and the innovative Power Platform solutions for HAPEE that she developed with guidance from the ICT team. “Jacqui has pioneered citizen development as a new way of working in Hearing Australia. What we’re seeing is that it really does empower people to solve their problems rather than rely on IT to do it. They can prototype and develop how they would like the application to work. We can then embed it back into our core systems and use it across the enterprise. So for us, it is a new way of working and it’s really exciting.” – Mike Brett, Chief Information Officer, Hearing Australia Related links

Microsoft Power Platform Stories

ADH ClinicSmall business owner transitioned from paper to digital, enabling her to stay open and continue delivering treatments during the COVID-19 pandemic. The solution includes Microsoft Bookings, Forms, Power Apps, Power Automate and Dataverse. Aioi Nissay Dowa InsuranceAioi Nissay Dowa Insurance, Japan’s largest insurance company, used Power Automate desktop flows to optimize citizen developer training & certification processes. American Red CrossA training specialist used Power Apps to digitize the process for First Aid and CPR instructors to order supplies. Ardent Mills Ardent Mills operates in more than 40 locations that specialize in flour, quinoa, pulses, and organic & gluten-free products. A citizen developer built several Power Apps solutions that are used daily across all locations. They are adopting Dataverse in their journey to building a paperless state-of-the-art mill. Arm Arm is a leading semiconductor and software design company headquartered in Cambridge, England. They used the Center of Excellence (CoE) Starter Kit to establish guardrails for managing the platform and form a thriving community of makers. ArmaninoArmanino used Power Apps connected to Azure SQL to build workspace scheduling solution that helps manage office space for its agile workforce. Arriva LondonMobile Power Apps were created to digitize the process for repairing buses and measuring operational performance. Autoglass (part of Belron group)Over 40 Power Apps solutions created, including apps for field technicians, an internal leadership conference, and more. The apps connect to Microsoft Dataverse and SharePoint. BlackmoresA team of full stack developers used Dynamics 365 and Power Platform, along with Microsoft Dataverse, to consolidate and unify several systems. Includes apps for coaching sales staff, managing vendors, and more. C.H. RobinsonPower Apps canvas apps and Power BI reports embedded in Dynamics 365 are used to capture rich customer information and gain insights on sales opportunities. Built by partner PowerObjects. Capitol RecordsCapitol Records migrated an old Infopath solution to a modern experience using Power Apps and Power Automate. It used for managing the schedule for new releases. Centrica Centrica is an international energy services and solutions company that serves millions of customers in the United Kingdom. Following their early success with Power Platform, they invested further in Microsoft Dataverse and setup a robust Center of Excellence to enable Power Platform adoption at scale. ChevronChevron has built a scaled up Center of Excellence with robust governance processes enabling hundreds of makers to build thousands of apps. Choice Aviation Choice Aviation Services is a US-based international airline cargo company that offers a full range of logistics services. They leveraged Microsoft Power Apps, Power Automate and Power BI to create a one-of-kind logistics system that is setting new standards of efficiency for the industry. City of KobeMultiple solutions built to respond to the COVID crisis – to provide status on special cash payments and provide information via chatbots and dashboards. Uses Power Apps portals, Power Automate, Power Virtual Agents, and Power BI. 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. Coca-Cola Bottling Company UnitedPower Automate desktop flows were used to automate complex back-end processes for managing vending machines cartridge replacements. Custom Air Products and ServicesPower Platform solution built by a citizen developer, Rebecca Sackett, is used to track the entire lifecycle of HVAC units from “cradle to crate” as they pass through the manufacturing process. Cancer Research UKMicrosoft Power Platform, SharePoint Online, and Teams was adopted to help accelerate fundraising opportunities and advance cancer research. Apps built for procurement, connecting research teams, and helping patients find cutting-edge trials. Degrees of ChangeDegrees of Change provides underrepresented youth equitable access to education. Using Microsoft Power Platform, including Dataverse, they built several apps that have helped them go paperless, enabling them to improve a yearly application scoring process, and serve more students, more effectively. EcolabEcolab leveraged Power Platform integrated with Dynamics 365, Azure, and Microsoft 365 to build “The Hub” – a unified app for managing core sales and service processes. ElectrolockElectrolock is a premiere provider of insulation products and solutions for the manufacturing industry. They partnered with Confluent to build an inventory management solution using Power apps, Power Automate and Microsoft Dataverse. Eneco GroupPower Apps solution connected to SharePoint Online to create a customized room finder experience in Eneco’s state of the art headquarters building in Rotterdam. Environment CanterburyProjects for managing the regions freshwater and natural resources are tracked using Power Apps, Power Automate and Power BI, include key milestones and long-term outcomes. EYEY has implemented multiple complex digital solutions built by code-first professional developers working in fusion teams. They use Power Platform (including Dataverse) 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 FortisAlberta FortisAlberta won a Canadian Safety Technology Award for this Microsoft Power Platform solution. To more efficiently document Injury Prevention Plans (IPPs), they transitioned away from paper forms to using Power Apps and Power BI. Solution built by Fidelity Factory.customer story G&J PepsiG&J Pepsi has digitally transformed their organization with Power Apps, Power Automate and Power BI, equipping nearly 900 field personnel with mobile apps that have saved the organization over $1.5 million. Giant EagleGiant Eagle is one of the nation’s largest food, fuel, and pharmacy retailers and distributors. With Microsoft Power Platform, the company has harnessed its innovative spirit to produce solutions that have increased productivity, reduced costs, and made for more engaged team members. GSKGSK has seen rapid viral adoption of the Power Platform through a community of makers that has grown to nearly 3000 people across 47 countries. Building solutions for improving safety, tracking manufacturing processes, and more. H&M H&M Group is a Swedish multinational clothing-retail company with more than 5,000 stores in 78 countries. They set up a Center of Excellence (CoE) using the Microsoft Power Platform CoE Starter Kit. As a result, a growing community of citizen developers has created thousands of Power Platform solutions across the company. Hanover Insurance Business and IT leaders at Hanover Insurance have partnered closely to automate time consuming manual tasks during the underwriting process. They successfully adopted Power Automate for desktop RPA capabilities and built custom apps using Power Apps to drive rapid automation. Hawkary PharmaceuticalsPharmaceutical sales and marketing manager in Iraq used Power Apps, Power Automate and Power BI to collect daily reports from medical sales representatives and generate reports for insights and analysis. Hearing Australia Hearing Australia is Australia’s largest provider of government-funded hearing services, operating in over 170 locations. A citizen developer, in partnership with the IT team, used Power Apps and Dataverse to streamline how Community Engagement Officers, audiologists and operations team collect and track critical program information. HexionSales staff use a Power Apps canvas app with AI Builder capabilities to scan business cards at events. Data is integrated into Microsoft Dynamics 365 and Dataverse. In addition, 80+ Power Automate flows are used to automate several business processes. IKEA SwedenPower Apps model-driven apps are used to manage in-store kitchen sales appointments, B2B sales pipeline, and speed up customer support requests. Built by Microsoft Gold Partner Capgemini. illimity Banklllimity, a young and innovative bank in Italy, automated the approval of special employee benefits using Power Automate. This turned a complex process into a hassle free experience with significant cost savings. Integrated Power Services (IPS)IPS transformed machine repair processes from paper to digital with a suite of Power Apps that run on ruggedized tablets used by technicians on the factory floor. Built by Confluent. Inter PipelinePresentation at the MBAS 2019 conference highlights the Inter Pipeline IT low-code strategy that includes bottom up innovation with strong collaboration between IT teams and business units. Island Council of TenerifeCoordinators for the Ansina program that promotes health and wellness in the community have used Power Apps embedded as a custom form in SharePoint to manage hundreds of events. Built by Intelequia. Johnson Controls Serving four million customers in 150 countries, more than 100,000 Johnson Controls employees create and deploy systems and digital solutions that optimize building performance, safety, sustainability, and comfort. Utilizing Microsoft Power Platform, Johnson Controls is building a new class of training deployment and tracking solutions. Kelly RoofingPower Apps mobile app used to capture photos and status updates at job sites. Integrated with Microsoft Dynamics 365, Dataverse, SharePoint and Teams. Built by PowerObjects. Leonard CheshireCare workers use Power Apps canvas apps and model-driven apps, along with Dynamics 365, to manage health care for people with disabilities. Built by QUANTIQ. Leonardo Global SolutionsPower Apps used to manage multi-stage inspection process to ensure adherence against facility management guidelines for canteens, cleaning, green areas, and more. Built by NTT Data. London Heathrow AirportFrom security guard to IT User Adoption Specialist, Samit Saini has built apps that improve the passenger experience at Heathrow airport. He has trained a community of super users who are now building apps and digitizing business processes at Heathrow. London’s Air Ambulance CharityThe life-saving charity treats an average of five patients every day. They partnered with Intelogy to build a suite of checklist apps that have replaced the existing paper-based processes. The solutions use Power Apps, Power Automate, Power BI and Dataverse. Metro BankA Power Apps tablet app connected to Dynamics 365 is used to welcome customers and manage the appointment experience when the visit the bank. Miami DolphinsThe Miami Dolphins, well known for football, also own Hard Rock Stadium, which hosts a wide range of sports and entertainment events. To free its service agents from repeatedly answering routine questions, the organization used Power Virtual Agents to build a chatbot that’s now available 24×7 on their web properties. Microsoft Account PlanningGlobal sales and marketing organization digitally transforms the account planning process for thousands of enterprise accounts using a Power Apps canvas app, Power Automate and Power BI connected to Dataverse. Microsoft Global Demand Center The Global Demand Center (GDC) is the connected sales and marketing engine that runs all commercial marketing campaigns for the company. In partnership with Accenture and Avanade, they used Power Automate, Power Apps, Power Virtual Agents and Power BI to reinvent operations and recover 25% of capacity and budget. Microsoft HRMobile suite of apps deployed to all Microsoft employees for viewing employee news, people profiles, global holidays, reporting vacation time, sending kudos and more. Microsoft Operations“Citizen developers within Microsoft built an “Intelligent Launch Assistant” that lets release managers quickly define the scope of a launch, document change requests, track issues and risks, and more.” Nestlé Waters Derek Lichtenwalner was a brick layer for ten years before joining Nestlé Waters as a production operator and then moved to line supervisor. He taught himself Power Apps and built several apps that are used daily at their manufacturing facilities for safety checks, operational reviews, visitor check-in, and more. North State GroceryNorth State Grocery partnered with SkyLite Systems to streamline the process for managing incoming customer requests for new products in grocery stores. This was built as a SharePoint custom form using Power Apps. Novo Nordisk The Global Clinical Development department at Novo Nordisk started their Power Platform journey in Dec 2019 with access to premium licenses and the full capabilities of the platform, including Portals. They accelerated adoption during COVID-19, built several applications, and are expanding to other parts of the organization. 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. Office DepotOffice depot saved hundreds of thousands of dollars by rapidly creating multiple Power Apps solutions that run embedded in Teams. An example is the Payroll Action Form app that replaced a fax process and resulted in faster and more accurate payments to associates. Partners In HealthGift officers use Power Apps to review donations and drive follow up actions. Power BI dashboards are used to gain insights on the donation process. PayPalPayPal uses Microsoft Teams for employees to collaborate. They’re creating a Power Apps and Power BI solution to manage the list of all portfolios and programs which will be deeply integrated with Teams. Pembina Pipeline The IT Enterprise Architecture team partnered with citizen developers in business units to use RPA capabilities in Power Automate for desktop, along with cloud flows, to rapidly automate business transactions against legacy systems brought in via an acquisition. Pinnacle GroupCitizen developer built 14+ Power Apps connected to SharePoint to conduct safety audits, centralize profit center listings, manage innovation ideas, and more. Priceline stores (Australian Pharmaceutical Industries)James Matson shares his journey as a professional developer adopting low code technologies to optimize retail store operations. QuoteWizardQuoteWizard used Microsoft Power Platform and Power Automate to build an automated, AI-powered ticket routing system to match tickets with the right talent at the right time. This has helped the company improve efficiency, hone its competitive edge, and deliver a better employee experience. R3 Retail DevelopmentFamily-owned small business now runs their business on the Power Platform, offering a customized app for complex project management tasks in retail installation projects. Built by Confluent. 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. Regal BeloitSales teams use a mobile Power Apps solution to streamline the process for documenting cost savings and sending proposals for approval. The app was built by a Marketing Manager. Reliable ElectricDigitization of complex work order estimation process for custom electrical projects in high-end homes. Rockwell Automation Rockwell Automation is a world leader in industrial automation and information. Using Power BI and Azure, and the Microsoft modern data warehouse architecture, they created a unified platform for analytics. Their world class BI Center of Excellence with training events and a thriving community has enabled serve-serve BI across the company. San Diego Workforce PartnershipUsing Microsoft Teams, a website chatbot built with Power Virtual Agents, and omnichannel capabilities within Dynamics 365 Customer Service, Workforce Partnership employees have been able to increase remote collaboration and engage with more people in need of support. SchlumbergerSchlumberger has a robust Center of Excellence with hundreds of apps, flows and dashboards built across several business units. The apps are used for managing the response to COVID, tracking fitness activities, managing promotion evaluations, executive feedback, and more. Seattle Visiting Nurses Association (SVNA)Seattle Visiting Nurses Association transformed their vaccine delivery process so that patients, nursing staff and admin staff could safely deliver flu vaccinations using Microsoft Dataverse, Power Apps, and Power Automate. Built by Signetic. SNCFSNCF started with a grassroots app development effort and now have hundreds of Power Apps in production. They’ve built a company-wide center of excellence to enable thousands on the Power Platform. Sonae Sonae MC, a company in the Sonae portfolio, is a leader in the food retail sector based in Portugal. Their Workplace Design team used Power Automate to build a solution to enhance their Sonae Contacto Traineeship Programme for attracting, retaining, and onboarding selected candidates. Standard BankStandard Bank has created a center of excellence focused on Microsoft Power Platform and Microsoft 365. Their driving principle –“apps built by business for business”. Swiss Federal Railway (SBB)The Rapid Solution Unit modernized over 200 forms by recreating them with Power Apps. Scenarios include supply chain management, HR, finance, cargo management, and more. Tacoma Public SchoolsLauren Taylor, Principal at Manitou Public Elementary used Power Apps, Power Automate and Power BI to create solutions for managing student reading assessments, return to school approvals, and more. Apps and dashboards run embedded in Microsoft Teams. Team RubiconTeam Rubicon uses Power Apps to manage complex operations from reconnaissance of disaster sites to execution of support efforts. They also use Power Apps Portals to recruit and train volunteers. TelstraField technicians and managers use 70+ tools for daily operations. Includes Power Apps, Power Automate and Power BI. The Power Platform solutions are led by a citizen developer who is now project owner for the PowerFactory Center of Excellence initiative. T-MobileTeams and executives track use Power Platform with Microsoft Dataverse to track approvals for all company-wide initiatives. T-Mobile has also setup a community of champions building Power Platform solutions across multiple business units. Total Solar (France)Total Solar has used Power Apps, Power Automate and Power BI, along with Microsoft teams to replace spreadsheets and centralize the management of projects from around the globe. ToyotaToyota has a robust Power Apps center of excellence to enable makers across the organization to build solutions. This includes field engineers using Power Apps and Power Automate to manage approvals. TransAltaPower Apps solution that connects to several backend services is used for resource planning and effective decision making. University of OxfordThe world-renowned university, which teaches 25,000 students every year, has created a range of easy-to-use Power Apps solutions. These includes apps that handle course fees, funding applications, assigning colleges, childcare services for staff, and more. Virgin AtlanticThe IT Lite Team delivers quick wins for business units –apps for managing VIP customers, compliance audits, cargo delivery, and more. Plus, an admin app built in Power Apps to manage the Power Apps footprint in the organization. Visiting Nurse Service & Hospice of Suffolk (VNSHS)Power Automate used to optimize complex backend processes for tracking and communication between care providers for 90k visits per year. Western States Caterpillar Western States Caterpillar Equipment Company is an authorized Caterpillar dealer for five mountain states in the United States. Pro-developers in the IT team built mobile Power Apps in collaboration with business teams. The apps are used to manage equipment rentals, sales activities, and more. WestJet Airlines WestJet Airlines built a Power Virtual Agents chatbot that answers employee questions on several ‘people and culture’ related topics. The chatbot has helped further a culture of self-sufficiency and innovation. ZF Group Hundreds of makers at ZF Group are digitizing excel and paper-based processes with Power Apps, Power Automate, Power BI and Dataverse for Teams. Solutions include – performance reviews, turnover tracking, improving teamwork, and more.

Announcing the general availability of pay-as-you-go for Power Apps

We are pleased to announce the general availability of a new and more flexible way to pay for Power Apps and related Power Platform services. Customers now can use an Azure subscription to cover their Power Apps usage and Dataverse capacity costs based on actual usage. Register to join us for a Power Apps pay-as-you-go webinar on March 22, 2022 Historically, low-code platforms have required customers to figure out their licensing needs in advance – often involving time-consuming procurement processes negotiated between developers, makers and IT professionals. While there are many benefits to the scale and predictability of user-based licensing, several scenarios today require the agility of a usage-based model. With deep roots in both Microsoft 365 as well as Azure, Power Platform is uniquely equipped to offer customers both options. With the new pay-as-you-go plan, customers only pay for what they use, giving them more flexibility to get started with low code with low risk and then scale their investments over time based on the usage patterns of their solutions. Great for developers building Power Apps that leverage Azure services The pay-as-you-go option for Power Apps is a great solution for developers who are already using Azure subscriptions to pay for the cloud services they need for their applications. Let’s say you are planning to build a Power Apps mobile app that leverages Dataverse as well as a set of Azure-hosted APIs. Today you would need to purchase Power Apps licenses from Microsoft or a partner, and allocate those licenses before deploying your app , and also pay for the Azure services you are using with your Azure subscription. Now, with Power Apps pay-as-you-go you can simply use the same Azure subscription you are using to pay for your Azure services to pay for Power Apps as well. Test the waters When building a new app it is often tough to predict how many users will want to use it, making it hard to forecast your licensing needs in advance. Now you can start with the pay-as-you-go option to gauge usage patterns then determine whether purchasing a pre-paid Power Apps subscription plan makes sense. Only pay when users use your apps Let’s say you have created an app (or set of apps) that you need to share with a large set of users in your organization, but which you expect will only be used by a varying subset of those users on an occasional basis. In this instance it may be more economical to leverage Power Apps pay-as-you-go instead of purchasing pre-paid Power Apps subscription plans for every user you share the app with. Share costs across your organization Many organizations want to allocate software license costs to the department or team that used the licenses.  Power Apps pay-as-you-go makes this possible by letting teams pay for Power Apps using Azure subscriptions linked to their own departmental budgets, and by providing the option to use Azure Cost Management and Azure tags to visualize and divide up costs. How it works To take advantage of Power Apps pay-as-you-go simply link the environment containing your apps to an Azure subscription. Usage of Power Apps and Dataverse in that environment will then be billed to your subscription using a new set of Azure meters: Power Apps per app pay-as-you-go meter: this meter provides the flexibility for organizations to pay only when users run an app . This contrasts with the existing Power Apps per app subscription plan which requires licenses to be purchased and allocated to an environment in advance of sharing apps, and with which licenses are consumed when an app is shared with a user (regardless of whether that user runs the app or not). Dataverse pay-as-you-go meters: these meters let you pay for the Dataverse storage consumed by your apps. There are separate meters for Dataverse database storage, file storage, and log storage. 1GB of database storage and 1GB of file storage is included with each environment you link to Azure. Power Platform requests meter: we have recently increased the Power Platform request limits (formerly called API calls) for Power Platform licenses to cover the needs of most customers and scenarios. For customers with extremely high scale scenarios who need more than those limits, the Power Platform requests meter will all be available for overages above and beyond standard Power Platform request limits. For more information, pricing, and examples covering how each meter works please see our docs. Setting up pay-as-you-go billing for Power Apps You can set up pay-as-you-go billing either in Power Apps or the Power Platform admin center. To get started you will need: Access to an Azure subscription with permissions to create new resources in that subscription and to register resource providers. Typically people get these permissions by having an “Owner” or “Contributor” role in the subscription. Admin access to an environment in the Power Platform. Then you can follow the steps below in Power Apps or the Power Platform admin center: From Power Apps From Power Apps select Settings for an app and then select Setup pay as you go.  You will then create a link between the environment your app is in to an Azure subscription. This link is called a billing policy. Enter your subscription details and click Next. From the Power Platform admin center In the Power Platform admin center admins can create and edit billing policies and link multiple environments to the same Azure subscription. This is a great way to aggregate Power Platform costs for environments that a team owns to that team’s Azure subscription. From the Power Platform admin center select Policies - > Billing Policies - > New billing policy and follow the steps. Monitoring and managing costs Moving from a pre-pay licensing model to a pay-as-you-go model often raises questions about how to monitor costs to prevent unexpected charges. With Power Platform pay-as-you-go we will provide a range of options for customers to stay on top of their costs: Azure Cost Management In the Azure portal, Azure Cost Management lets you view a breakdown of charges associated with your meters and see how they are changing over time. Azure Cost Management also allows you to set budgets for each meter. These budgets can be used to trigger alerts when you approach spend thresholds you define. They can also be user to trigger automated administrative actions you can configure to manage your Azure spend. Azure tags You can add customizable tags to the Power Platform account resources in your subscription. Tagging is a great way to organize related Azure resources by solution area, department, cost center and more. This can be helpful to streamline internal chargebacks and administrative functions. Detailed usage reports   The Power Platform admin center will provide a downloadable report with a detailed breakdown of which users, apps and environments generated charges for the Power Platform pay-as-you-go Azure meters. Using pay-as-you-go and pre-pay together Pay-as-you-go is configured on an environment-by-environment basis, so you have the flexibility to adopt it wherever it makes sense for your organization and stick with the pre-paid model where it doesn’t. In the example below the customer has chosen to use pay-as-you-go for their HR team and the Finance team’s environments, but not for their Marketing team’s environments. Furthermore, within a pay-as-you-go environment it is possible to disable the Power Apps per app pay-as-you-go meter for specific apps. Any unlicensed users will be blocked from accessing those apps. The pre-paid Power Apps per app subscription plan cannot be used to license users in a pay-as-you-go environment, but the per user plan can be. This means that you can simultaneously leverage the per user plan to license some users of your apps in a pay-as-you-go environment while also using the Power Apps per app pay-as-you-go meter to cover others. What’s coming next Looking forward we plan to introduce capabilities like APIs to link environments to Azure subscriptions, and integration with the Power Platform Center of Excellence Starter Kit. Longer term we have a range of services that would make sense to offer in a pay-as-you-go model and would love your input on where we should focus our efforts next. Please give it a try and share your thoughts! Webinar: Register to join us for a Power Apps pay-as-you-go webinar on March 22, 2022 Docs: Power Apps pay-as-you-go documentation Questions: Power Apps community forum Mechanics video: https://aka.ms/IgniteNov21/PPMechanics
- Advertisement -spot_img

Latest News

Announcing general availability of automatic aggregations

Less than a year ago, we announced support for automatic aggregations in public preview. Today, we are excited to...
- Advertisement -spot_img