Microsoft Power Apps Tutorial
Learn Microsoft Power Apps step by step: 38 lessons in 9 chapters with examples, quizzes, diagrams and projects.
Start learning →
of lessons completed
Getting Started
- What Is Microsoft Power Apps? Learn what Power Apps is, who builds with it, what kinds of apps it makes, and how a low-code app is really a set of screens, controls and formulas.
- The Power Platform Ecosystem See how Power Apps, Power Automate, Power BI, Copilot Studio, Power Pages and Dataverse fit together, and learn which product solves which problem.
- Licensing, Plans and Environments Understand Power Apps standard and premium connectors, per-app and per-user plans, the free Developer Plan, and the environments where your apps live.
- Power Apps Studio and the Maker Portal Take a guided tour of the Power Apps maker portal and Studio: Tree view, Insert pane, properties, formula bar, App checker, Monitor and preview mode.
- Build Your First Canvas App Follow a step-by-step workflow to build a simple task app in Power Apps: create the app, add a data source, a gallery, a search box and a button.
Concepts and Canvas Apps
- Canvas Apps Versus Model-Driven Apps Compare canvas and model-driven Power Apps in layout control, data requirements, speed of building, mobile use and governance, with a practical decision guide.
- Anatomy of a Canvas App Learn how a canvas app is organized: the App object with OnStart and Formulas, screens, controls, properties, the name rules, and how formulas are evaluated.
- Screens and Navigation in Power Apps Add screens, move between them with Navigate and Back, pass context values, use transitions, and design a navigation pattern for a multi-screen canvas app.
- Responsive Layout with Containers Build canvas app layouts that adapt to any screen using horizontal and vertical containers, flexible width and height, Parent.Width formulas and breakpoints.
Controls and Formulas
- Power Fx Basics Learn the Power Fx formula language: data types, operators, text, number and date functions, If and Switch, blank values, and how to read and write formulas.
- Variables and Collections in Power Apps Understand global variables, context variables, collections and named formulas in Power Apps, when to use each, and how Set, UpdateContext, Collect and ClearCollect work.
- Common Controls in Power Apps Learn the everyday Power Apps controls: label, text input, button, dropdown, combo box, toggle, checkbox, date picker, slider, with their key properties and formulas.
- The Gallery Control Master the Power Apps gallery: Items, ThisItem, Selected, templates, layouts, wrap count, nested galleries, buttons inside rows, and ForAll, Sum and CountRows.
- Forms and Validation in Power Apps Build Edit and Display forms in Power Apps: DataSource, Item, data cards, SubmitForm, OnSuccess, OnFailure, NewForm, ResetForm and custom validation with Notify.
Data and Dataverse
- Data Sources and Delegation Learn how Power Apps connects to data sources, what delegation means, the 500 and 2000 row data row limit, delegation warnings, and how to design queries that scale.
- Dataverse Tables and Columns Learn Dataverse basics for Power Apps: standard, custom and activity tables, primary columns, column data types, calculated and rollup columns, keys and views.
- Filter, Search, Sort and Patch Learn the core data functions in Power Apps: Filter, LookUp, Search, SortByColumns, AddColumns, GroupBy, Patch, Remove, UpdateIf and error handling with IfError.
- Relationships and Choices in Dataverse Model related data in Dataverse with lookups, one-to-many and many-to-many relationships, and choice columns, and use them in Power Apps formulas such as ThisItem.Customer.Name.
Model-driven Apps
- Model-driven Apps - The Big Picture Understand model-driven Power Apps: how tables, forms, views and a site map generate the interface for you, and when to choose them over a canvas app.
- Forms, Views and Columns Learn the form types, tabs, sections and views of model-driven Power Apps: main forms, quick create, view filters, sorting and how columns reach the screen.
- Business Rules and Command Bar Commands Add logic to model-driven Power Apps with business rules (conditions and actions on forms) and command bar buttons built with Power Fx. Includes stand-ins.
- Site Maps, Dashboards and Charts Design navigation with the model-driven app site map, then add system and personal dashboards, charts and views so users see key numbers at a glance.
Connectors and Integration
- Connectors - The Big Picture Learn what Power Apps connectors are, the difference between standard, premium and custom connectors, connections, tabular and action connectors, and licensing basics.
- Custom Connectors and OpenAPI Build a Power Apps custom connector for your own REST API: describe it with OpenAPI, choose authentication, define actions and test it. Includes a checker stand-in.
- Calling Power Automate Flows from Apps Learn how a canvas app triggers Power Automate flows: the Power Apps trigger, passing inputs, returning outputs with Respond to a Power App, errors and when to use a flow.
- SharePoint, Outlook and Teams Integration Use the Microsoft 365 connectors in Power Apps: SharePoint lists, Outlook email and calendar, Teams messages and an app embedded in Teams. Includes safe stand-ins.
Components and ALM
- Canvas Components and Component Libraries Reuse UI in canvas apps with components: input and output properties, behavior properties, component libraries, updates across apps and design-system tips.
- Solutions and Environments Learn Power Platform environments (dev, test, prod) and solutions (managed vs unmanaged, publishers, layers) so your apps move safely between environments.
- Pipelines, Source Control and the CLI Automate Power Apps deployment: Power Platform pipelines, the pac CLI to unpack solutions into source control, Git workflows and a release checklist.
- Environment Variables and Connection References Make solutions portable: use environment variables for URLs and settings, and connection references for credentials, so one package works in Dev, Test and Prod.
Governance and Performance
- Security Roles, Sharing and Row Access Control who can see and change what in Power Apps: Dataverse security roles, privileges and access levels, business units, teams, column security and app sharing.
- Data Loss Prevention Policies and Governance Understand Power Platform data policies (DLP): Business, Non-business and Blocked connector groups, scope, environment groups, the CoE Starter Kit and governance habits.
- Delegation and Performance Tuning Understand Power Apps delegation, the 500/2000 row data limit, delegable functions, and tuning tips: Concurrent, caching, fewer controls, lazy loading and gallery design.
- Monitor, Testing and Troubleshooting Debug and test Power Apps: the Monitor tool, Test Studio and Power Apps Test Engine, app checker, analytics and a checklist for common errors in canvas and model-driven apps.
Projects and Practice
- Project: Expense Approval App Plan and build an expense approval solution: Dataverse tables, a canvas submit app, an approval flow, security roles and ALM. Includes runnable logic stand-ins.
- Project: Inventory Model-driven App Build a model-driven inventory app: tables and relationships, forms, views, business rules, a reorder command, dashboard and roles, with stand-ins that test the logic.
- Project: Lifecycle and Governance Plan Design a complete Power Platform plan for an organization: environment strategy, solution layout, DLP policies, roles, deployment path and a readiness checker.
- Practice: Power Apps Review Questions Practice Power Apps with scenario questions on model-driven apps, connectors, solutions, security, delegation and governance, plus design exercises and a self-test tool.