Microsoft Power Apps

Microsoft Power Apps
Name	Microsoft Power Apps
Developer	Microsoft
Released	30 November 2015
Operating system	Microsoft Windows, iOS, Android
Genre	Low-code development platform
License	Proprietary software

Microsoft Power Apps. It is a suite of applications, services, and a data platform within the Microsoft Power Platform that provides a rapid application development environment for building custom business applications. The platform is designed to enable both professional developers and non-technical "citizen developers" to create software tailored to specific organizational needs without requiring extensive knowledge of traditional programming languages. Its core components and connectors integrate deeply with other Microsoft 365 services and a wide array of external data sources.

Overview

Launched in late 2015, the platform emerged from Microsoft's broader strategy to empower business users and democratize application development. It exists as a central pillar of the Microsoft Power Platform, which also includes Power Automate, Power BI, and Power Virtual Agents. The environment supports the creation of two primary types of applications: canvas apps, which offer a free-form, drag and drop design experience, and model-driven apps, which are generated from underlying Dataverse data models and provide a more structured, form-based interface. This dual approach allows organizations to address a spectrum of use cases, from simple task automation to complex enterprise systems.

Features and capabilities

Key features include a visual designer that uses Excel-like expressions for logic, specifically the Power Fx language. The platform provides hundreds of pre-built connectors to services like SharePoint, Microsoft SQL Server, Salesforce, Twitter, and Google Services. Advanced capabilities include artificial intelligence integration through AI Builder, the ability to incorporate custom code via Azure Functions, and robust offline functionality for mobile applications. Security and governance are managed through integration with Microsoft Entra ID and detailed role-based security within the Dataverse.

Development and deployment

Development occurs primarily within a web browser via Power Apps Studio, though there is also a dedicated Microsoft Windows application. The process is centered on connecting to data sources, designing the user interface, and implementing business logic. Applications can be published and shared directly within an organization’s Microsoft 365 tenant, allowing for instant distribution to users on iOS, Android, or in a web browser. For more advanced scenarios, developers can use solutions to package and deploy applications along with their components across different environments, facilitating ALM practices.

Licensing and pricing

Licensing operates on a per-user or per-app basis, with plans tied to the broader Microsoft Power Platform. The premium plan is required for accessing most connectors beyond core Microsoft 365 services and for using the Dataverse. Specific plans exist for individual "citizen developers" and for running applications, with pricing models detailed on the official Microsoft website. Volume licensing is available through enterprise agreements like the Microsoft Enterprise Agreement.

Integration and ecosystem

The platform is deeply integrated with the Microsoft 365 suite, including Teams, SharePoint, and Outlook. It shares the Dataverse with other Power Platform components like Power Automate and Power Virtual Agents, enabling cohesive workflow automation and chatbot creation. Furthermore, it connects to broader Microsoft Azure services such as Azure Logic Apps and Azure API Management, extending its capabilities for professional developers. A large community and marketplace exist on the Power Apps Community and AppSource.

Criticisms and limitations

Common criticisms include the potential for creating ungoverned "shadow IT" applications by citizen developers, which can lead to data security and compliance risks. Performance can be a concern with very complex applications or large datasets, and the per-user licensing model can become costly for broadly deployed applications. While extensible, there are limitations compared to traditional development in .NET or JavaScript, and vendor lock-in to the Microsoft ecosystem is a frequent consideration for organizations.

Category:Microsoft software Category:Low-code development platforms Category:Cloud computing Category:2015 software