Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Microsoft Power Apps is a suite of apps, services, and connectors that provides a rapid development environment for building low-code custom apps. Using Power Apps, you can quickly build business apps that connect to your organization's data, whether it's stored in Microsoft Dataverse—the underlying data platform for all Power Platform products—or in other online and on-premises data sources.
Understanding Power Apps reference architectures and exploring solution ideas can help you unlock new opportunities for automation, optimization, and innovation in your organization. In this article, we look at:
Key concepts: Learn about key architecture concepts that help you build robust, efficient, and maintainable solutions with Power Apps.
Reference architectures: Explore foundational reference architectures that support building well-architected solutions with Power Apps.
Solution ideas: Discover a range of solution ideas that demonstrate the versatility and power of Power Apps.
Key concepts
| Title | Description |
|---|---|
| Distributed tracing across multiple services in Power Platform | Learn how to achieve observability across services like Power Platform, Azure, and Dynamics 365. |
| Power Apps coding guidelines | Learn about standards for naming objects, collections, and variables, and guidelines for developing consistent, well-performing, and easily maintainable apps. |
| Build large and complex canvas apps | Use the recommendations in this article to better work with large and complex apps in Power Apps Studio and improve your apps' runtime performance. |
| Optimize app or page load for peak performance | One of the key factors that shape a user's perception of an app is how quickly it opens and starts to work. Use the guidelines in this article to build apps that load quickly. |
| Optimized query data patterns | Learn ways to query data more quickly and efficiently. |
| Small data payloads—Limit the amount of data you get | Learn how to limit the size of the data you fetch into Power Apps. |
| Fast calculations | Learn how to fine-tune your Power Fx calculations to make them as fast as possible. |
| Troubleshoot Power Apps canvas app performance issues | Identify common performance issues you might encounter while using a canvas app, along with likely causes and recommendations. |
| Understand canvas app execution phases, data call flow, and performance monitoring | Learn about the phases of execution that an app goes through when it's opened, how apps connect to data sources, and about tools that you can use to monitor app performance. |
| Connect to SQL Server from Power Apps | Learn how to use Power Fx formulas in your apps to connect to data in SQL Server, either directly or by using a view or stored procedures. |
| Use Microsoft SQL Server securely with Power Apps | Understand your options for connecting and authenticating to SQL Server using a security approach that matches the requirements of your app. |
Reference architectures
| Title | Description |
|---|---|
| Streamline document processing with AI Builder | Streamline document processing and automate data extraction from various documents such as forms, invoices, and purchase orders. |
| Perform predictive data analysis using Dataverse, Fabric, and Azure AI services | Learn best practices for data ingestion, model training, and visualization that help you build robust predictive models and gain actionable insights. |
| Integrate Microsoft Fabric Lakehouse data using Dataverse virtual tables | Gather data from multiple internal systems into a Microsoft Fabric Lakehouse, and consume the data in Power Platform apps and automations using Dataverse virtual tables. |
| Integrate Power Platform with SAP for data management | Learn about the architecture, workflows, and connectivity methods available to integrate Power Platform with SAP to ensure a smooth integration process. |
| Use Dataverse background operations | Use custom APIs to define custom messages and implement business logic through plug-ins, allowing for background processing that eliminates the need for a persistent connection during execution. |
| Secure Power Platform access to Azure resources | Use Microsoft Azure Virtual Network support for Power Platform to integrate Power Platform with resources inside your virtual network without exposing them to the public internet. |
| Use REST APIs to extend the functionality of canvas apps | When working with complex algorithms or multiple data sources, shift the logic from the canvas app to a RESTful API to keep formulas in your Power Apps canvas apps simple and move more complex functionality to the server. |
| Use Dataverse as a data source for canvas apps | Learn how creating a Power Apps application that uses Dataverse as a data source helps build a more custom user experience. |
Solution ideas
| Title | Description |
|---|---|
| Healthcare Patient Support Agent | Streamline patient interactions and reduce administrative burdens for healthcare providers. |
| Property rental portal with AI-driven search and payment processing | Build a comprehensive rental portal that uses AI-driven search capabilities and seamless payment processing. |
| Revolutionize vehicle inspections with EVVIE | Inspect vehicles and assess damage using generative AI and Power Platform. |