Skip to content

Power Apps

What is Power Apps?

By Suresh Girinathuni

Quick answer

Microsoft Power Apps is a low-code application development platform for building business applications on data from Dataverse, SharePoint, SQL Server, and hundreds of connectors. Canvas apps give makers full control over layout and formulas; model-driven apps generate consistent data-management UI from Dataverse tables, forms, and views; Power Apps Code opens the same platform to professional React and TypeScript development with source control.

Key takeaways

  • Canvas for custom UX, model-driven for Dataverse data ops, Code for pro-code.
  • SharePoint starts simple; Dataverse scales with governance.
  • Check premium-connector and capacity licensing per scenario.

Detailed Explanation

Microsoft Power Apps is a low-code application development platform for building business applications on data from Dataverse, SharePoint, SQL Server, and hundreds of connectors. Canvas apps give makers full control over layout and formulas; model-driven apps generate consistent data-management UI from Dataverse tables, forms, and views; Power Apps Code opens the same platform to professional React and TypeScript development with source control.

How it works

Pick the path by need: custom task UX → canvas with Power Fx formulas; structured data management → model-driven on Dataverse; full code control → Code apps via PAC CLI. All three share environments, solutions, connectors, and Dataverse where used.

Limitations and considerations

Canvas apps over SharePoint hit delegation and scale ceilings on large lists; model-driven apps require Dataverse with its licensing and ALM discipline; premium connectors and Dataverse capacity change the cost picture — verify current licensing per scenario.

This Q&A page is the short-answer layer for “What is Power Apps?” Use the related guides below when you need implementation steps, architecture trade-offs, or troubleshooting detail.

For broader context, visit the Power Apps Code Hub. It connects this topic to surrounding Microsoft 365, Power Platform, SharePoint, Copilot Studio, Dataverse, migration, and Dynamics 365 guidance.

When to use it

Use canvas for focused departmental tools, model-driven for CRM-style data operations, and Code when the team needs components, testing, and pipelines beyond the studios.

Practical example

A facilities team ships a canvas room-booking app on a SharePoint list in weeks, then graduates the asset register to a model-driven app on Dataverse when relationships and security outgrow lists.

Related Questions

What is Microsoft Dataverse?Microsoft Dataverse is Microsoft’s cloud data platform for storing and managing business data used by Power Platform and Dynamics 365.When should I use Dataverse instead of SharePoint for Power Apps?Choose Dataverse when the app needs table relationships, row-level security, auditing, solution ALM, or Dynamics 365 integration. Stay on SharePoint for simple team tools with flat data and list-level permissions.Can Power Apps connect to SharePoint?Yes — SharePoint lists and libraries are first-class Power Apps data sources via the SharePoint connector, ideal for departmental apps. Plan for delegation limits on large lists and graduate to Dataverse when relational needs grow.Can Power Apps connect to SQL Server?Yes — the SQL Server connector reads and writes tables and views, including stored procedures. On-premises databases need an on-premises data gateway; verify premium-licensing implications per scenario.

Related nextM365 Guides

Power AppsPower Apps Code — The Future of Pro-Code Development on the Power PlatformMeet Power Apps Code — Microsoft’s pro-code approach to building Power Platform apps with React, TypeScript, and modern tools. What it is, how it compares to canvas Power Apps, why it says goodbye to delegation warnings, the technologies and skills to learn, when to use it, and why it is not replacing canvas apps.

Sources