Skip to content
Tutorials Center
My learning

Topics

Lesson 1 of 38 ยท 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.

Microsoft Power Apps is a low-code platform for building business applications. You drag controls onto a screen, connect them to data, and write short spreadsheet-style formulas to describe behavior. The result is a real app that runs in a browser, on a phone or inside Microsoft Teams, without you writing a classic program from scratch.

This course teaches Power Apps from the first click to governance and application lifecycle management. In this first lesson you will learn what Power Apps is for, how an app is built from simple ideas, and what you can expect from the rest of the course.

About the examples. Power Apps is a cloud product that you use in a web browser, so it cannot run inside this site. Where a lesson shows a formula or a menu path, it is described in words and read-only code. Where an idea can be shown with running code, we use a small JavaScript stand-in that is clearly labelled. A stand-in teaches the idea; it is not Power Apps itself.

Who uses Power Apps

Power Apps targets the huge gap between "we use a spreadsheet" and "we hire a development team." Typical builders are:

  • Citizen developers: people in finance, HR, operations or field service who know their process well and want a tool for it.
  • Professional developers: engineers who use Power Apps for quick internal tools, and extend it with code, custom connectors and components.
  • IT administrators: people who govern what gets built, where data may flow and who may share apps.

Common apps include inspection checklists, leave requests, inventory counters, expense capture with photos, asset trackers, approval dashboards and small customer-service tools.

Three families of apps

Power Apps can build three main kinds of app. You will meet each in detail later.

Kind You start from Best for
Canvas app A blank screen or a data source Pixel-level control of layout, mobile and tablet apps, custom experiences
Model-driven app A data model in Dataverse Data-heavy, process-driven apps with many tables and forms
Power Pages site A website template External-facing portals for customers or partners

This course focuses on canvas and model-driven apps, with Dataverse as the data layer.

An app is screens, controls and formulas

Every Power Apps canvas app is made from the same three ingredients:

  1. Screens hold what the user sees. An app might have a Home screen, a Details screen and an Edit screen.
  2. Controls are the building blocks on a screen: labels, buttons, text inputs, galleries, forms, images.
  3. Formulas are written in a language called Power Fx. A formula is attached to a property of a control or of the app, such as a button's OnSelect or a label's Text.

The key idea is that formulas are reactive, like cells in a spreadsheet. If a label's Text is TextInput1.Text, the label updates by itself whenever the input changes. You do not write an event handler to copy the value.

The stand-in below mimics that behavior with plain JavaScript. A property can be a function of other properties, and asking for it recalculates from the current inputs.

JS Stand-in: reactive properties like spreadsheet cells

Press Run (or Ctrl + Enter) to see the console output here.

No output.

In the real product you would type "Hello, " & TextInput1.Text & "!" in the formula bar for Label1.Text, and Power Apps tracks dependencies for you.

Low-code, not no-code

Power Apps is often called low-code: you can build a lot with clicks, but formulas and data design still matter. Beginners succeed when they treat it like a small programming environment with a friendly editor. That means:

  • Learn Power Fx well. It is the same language across Power Apps, and parts of it appear in Power Automate and Copilot Studio.
  • Design your data before your screens. Most bad apps are bad data models with nice buttons.
  • Think about users, devices and licenses early. They shape what you can build and what it costs.

How apps get data

Apps do not store data themselves. They connect to data sources through connectors. Popular ones are:

  • Microsoft Dataverse: the relational data platform inside Power Platform (see Dataverse tables and columns).
  • SharePoint lists and Excel workbooks in OneDrive.
  • SQL Server, Azure services, Salesforce, and hundreds of other services.
  • Custom connectors that wrap your own REST API.

Each connection is governed by a license tier (standard or premium), which we cover in Licensing, plans and environments.

The next stand-in models an app's data as a list of records and shows the kind of formula work a gallery does: filter, sort and count.

JS Stand-in: filtering and counting records

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Where Power Apps fits in the Power Platform

Power Apps is one of several products that share data, connectors and administration. Together they are called the Power Platform. You will see how they fit in The Power Platform ecosystem.

flowchart LR
  U["User on phone, browser or Teams"] --> A["Power Apps app"]
  A --> C["Connectors"]
  C --> D1["Dataverse"]
  C --> D2["SharePoint"]
  C --> D3["SQL Server and other services"]
  A --> F["Power Automate flows"]

An app talks to data through connectors and can trigger flows for work that happens in the background.

What you will learn in this course

  • Chapters 1 to 4 (this part): getting started, canvas app concepts, controls and formulas, and data with Dataverse.
  • Later chapters: model-driven apps, connectors and integration, components and ALM, governance and performance, and complete projects.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which three ingredients make up a canvas app?

    Screens hold the layout, controls are the building blocks, and Power Fx formulas set their properties.
  2. 2. What does it mean that Power Fx formulas are reactive?

    Like spreadsheet cells, a formula is re-evaluated when its inputs change, so you rarely write manual update code.
  3. 3. Where does a typical app keep its business data?

    Apps connect to data sources such as Dataverse, SharePoint or SQL Server through connectors.
  4. 4. Which app type is best when you need pixel-level control of the layout?

    Canvas apps let you place every control freely; model-driven apps generate layout from a data model.

Summary

  • Power Apps is a low-code platform for business apps that run on web, mobile and Teams.
  • Canvas apps give layout freedom; model-driven apps are generated from a Dataverse model; Power Pages builds external sites.
  • An app is screens, controls and Power Fx formulas attached to properties.
  • Formulas are reactive, like spreadsheet cells.
  • Data lives in data sources reached through connectors.

Next: The Power Platform ecosystem