Microsoft Power Apps Course

Lesson 1 • Setting Up Your Development Environment

Guides students through environment creation, role assignment, and tool configuration. Ensures a working workspace before any app is built.

Lesson 2 • Navigating Power Apps Studio

Introduces the canvas studio interface, property panels, and formula bar. Students gain confidence moving through the authoring environment efficiently.

Lesson 3 • Power Apps Ecosystem Overview

Covers the three app types, licensing tiers, and platform positioning within Microsoft 365. Establishes context for all subsequent technical work.

Lesson 1 • Working with Core Controls

Covers text inputs, buttons, labels, galleries, and forms as the primary building blocks. Students assemble interactive UI components from these controls.

Lesson 2 • Saving, Publishing, and Sharing Apps

Covers version control, publishing steps, and sharing with users or groups. Students understand the full deployment lifecycle for a canvas app.

Lesson 3 • Designing Screens and Layouts

Teaches screen creation, layout containers, and responsive design principles. Directly shapes the visual structure of every app built in the course.

Lesson 4 • Connecting to SharePoint and Excel Data

Demonstrates adding SharePoint lists and Excel tables as live data sources. Students retrieve, display, and filter real records inside their app.

Lesson 1 • Table and Record Functions

Covers Filter, Search, LookUp, AddColumns, and related table functions. Students transform and query data entirely within formulas.

Lesson 2 • Error Handling and Debugging

Introduces IfError, IsError, and the Monitor tool for diagnosing formula failures. Students learn systematic debugging practices that reduce production issues.

Lesson 3 • Patch, Remove, and SubmitForm

Teaches writing, updating, and deleting records through Patch and Remove functions. Students implement full CRUD operations without custom code.

Lesson 4 • Collections and Variables

Explains global variables, context variables, and in-memory collections for state management. These patterns underpin dynamic app behaviour in all later chapters.

Lesson 1 • Dataverse for Canvas Apps

Demonstrates connecting canvas apps to Dataverse and leveraging server-side delegation. Students replace local data sources with scalable Dataverse tables.

Lesson 2 • Business Rules and Calculated Columns

Teaches server-side business rules, calculated fields, and rollup columns in Dataverse. Logic runs at the data layer, independent of any specific app.

Lesson 3 • Dataverse Architecture and Tables

Explains Dataverse structure, standard vs. custom tables, and column types. Provides the schema knowledge needed before building model-driven apps.

Lesson 4 • Dataverse Security Model

Explains security roles, field-level security, and record ownership models. Students configure access control that meets enterprise governance requirements.

Lesson 1 • Dashboards and Charts

Teaches system dashboards, interactive dashboards, and chart configuration. Students surface key metrics directly inside the model-driven app.

Lesson 2 • Business Process Flows

Introduces guided multi-stage processes that enforce consistent data entry across teams. Students design and activate flows tied to specific Dataverse tables.

Lesson 3 • Customising the App Experience

Covers command bar customisation, ribbon rules, and app-level navigation settings. Students tailor the UI to match organisational workflows and branding.

Lesson 4 • Designing Views and Forms

Covers system and custom views, main forms, quick-view forms, and card forms. Students control how records are listed and edited within the app.

Lesson 1 • Automating Data Operations

Uses scheduled and automated flows to sync, transform, and archive data connected to apps. Students offload heavy data tasks from the app to background flows.

Lesson 2 • Approval Workflows and Notifications

Builds approval flows triggered by app submissions and sends adaptive card notifications. Students implement common enterprise approval scenarios end to end.

Lesson 3 • Power Automate Fundamentals for Makers

Reviews flow types, triggers, and actions relevant to Power Apps integration. Provides the minimum Automate knowledge needed before connecting flows to apps.

Lesson 1 • Custom Connectors

Covers building custom connectors from OpenAPI definitions to call external REST APIs. Students extend Power Apps beyond the standard connector catalogue.

Lesson 2 • Performance Optimisation Strategies

Identifies delegation limits, concurrent loading, and rendering bottlenecks that slow apps. Students apply proven techniques to reduce load times and improve responsiveness.

Lesson 3 • Component Libraries and Reusability

Teaches creating, publishing, and consuming reusable components across multiple apps. Students eliminate duplicated UI logic and enforce consistent design patterns.

Lesson 4 • Responsive Design and Accessibility

Applies flexible layout containers and accessibility properties to support all users and devices. Students meet organisational accessibility standards within their apps.

Lesson 1 • Source Control with Azure DevOps

Integrates Power Apps solutions with Git repositories using Power Platform CLI and pipelines. Students version-control app assets and collaborate without overwriting each other's work.

Lesson 2 • Environment Strategy and Management

Defines development, test, and production environment patterns and their governance implications. Students design an environment topology that supports safe, controlled releases.

Lesson 3 • CI/CD Pipelines for Power Apps

Builds automated build and release pipelines that deploy solutions across environments. Students reduce manual deployment errors and enforce quality gates before production.

Lesson 4 • Monitoring, Auditing, and Compliance

Uses analytics, audit logs, and Centre of Excellence tools to track app usage and policy adherence. Students maintain visibility and control over the entire app portfolio.