Power Apps and Power Automate Course

Lesson 1 • Data Sources and Connectors Basics

Introduces standard and premium connectors, authentication types, and connection management. Prepares students to connect apps and flows to real data.

Lesson 2 • Licensing and Environment Setup

Explains licence tiers, trial activation, and environment types. Students configure a personal developer environment ready for hands-on labs.

Lesson 3 • Power Platform Overview and Architecture

Covers the four pillars—Power Apps, Power Automate, Power BI, and Power Pages—and how they interconnect. Sets the conceptual map for the entire course.

Lesson 1 • Testing, Debugging, and Publishing

Introduces Monitor tool, formula errors, and app checker. Students validate app behaviour and publish a polished app to their organisation.

Lesson 2 • Canvas App Studio Interface

Explores the design canvas, property pane, formula bar, and tree view. Mastery of the interface accelerates all subsequent app-building tasks.

Lesson 3 • Power Fx Formula Language Fundamentals

Teaches Power Fx syntax, data types, and common functions for logic and data manipulation. Formulas are the engine behind every dynamic canvas app behaviour.

Lesson 4 • Core Controls and Layouts

Covers galleries, forms, buttons, labels, and input controls. Students assemble a structured UI that displays and captures data effectively.

Lesson 5 • Connecting Apps to Data Sources

Demonstrates binding SharePoint lists, Excel tables, and Dataverse tables to app controls. Students retrieve, display, and write data within a single app.

Lesson 1 • Relationships and Lookups

Explains one-to-many, many-to-many, and polymorphic relationships. Students model realistic entity relationships that drive form and view behaviour.

Lesson 2 • Security Roles and Access Control

Covers Dataverse security roles, teams, and row-level access. Students configure role-based access so users see only the data they are authorised to view.

Lesson 3 • Model-Driven App Designer

Walks through the modern app designer, site map, forms, and views. Students assemble a navigable model-driven app from existing Dataverse tables.

Lesson 4 • Dataverse Tables and Columns

Covers standard and custom tables, column types, and primary keys. A well-designed Dataverse schema is the prerequisite for every model-driven app.

Lesson 1 • Error Handling and Run History

Covers Configure Run After, Scope actions, and run history analysis. Students build resilient flows that recover from failures and surface useful error messages.

Lesson 2 • Conditions, Switches, and Branching

Teaches conditional branching with Condition and Switch controls. Students build flows that take different paths based on data values.

Lesson 3 • Actions, Dynamic Content, and Expressions

Covers adding actions, mapping dynamic content tokens, and writing expressions. Students transform and route data between steps using built-in functions.

Lesson 4 • Flow Types and Trigger Patterns

Distinguishes automated, instant, and scheduled flow types and their trigger events. Choosing the right trigger is the first design decision in every flow.

Lesson 1 • Approval Connector Deep Dive

Covers the Approvals connector, approval types, and response handling. The Approvals connector is the foundation of every structured review process.

Lesson 2 • Audit Trails and Reporting

Covers logging approval decisions to Dataverse and surfacing results in a canvas app. Students create a traceable record of every approval action taken.

Lesson 3 • Email and Teams Notifications

Teaches HTML email formatting, adaptive cards in Teams, and targeted notifications. Rich notifications improve approver response rates and user experience.

Lesson 1 • Accessibility and Responsive Design

Applies WCAG-aligned accessibility properties and flexible layout containers. Students produce apps that meet organisational accessibility standards on any screen size.

Lesson 2 • Offline Capability and Local Storage

Teaches SaveData, LoadData, and Connection.Connected patterns for offline scenarios. Students build apps that function without network access and sync on reconnect.

Lesson 3 • Component Libraries and Reusable Controls

Covers building, publishing, and consuming component libraries across multiple apps. Shared components enforce UI consistency and reduce development time.

Lesson 4 • Named Formulas and App-Level Logic

Introduces named formulas, App.OnStart optimisation, and formula reuse strategies. Centralising logic reduces duplication and simplifies future maintenance.

Lesson 1 • Dataverse and Power Apps Triggers

Covers Dataverse row-created, modified, and deleted triggers and the Power Apps trigger. Students automate backend processes that respond to app user actions.

Lesson 2 • HTTP Actions and REST API Calls

Covers the HTTP action, authentication headers, and JSON response parsing. Direct API calls unlock integrations beyond the standard connector catalogue.

Lesson 3 • Child Flows and Flow Modularity

Teaches child flow patterns, input/output parameters, and solution-aware flow design. Modular flows are easier to test, reuse, and maintain across projects.

Lesson 4 • Building Custom Connectors

Walks through OpenAPI definition, authentication setup, and action configuration in the custom connector wizard. Students package an external API as a reusable connector.

Lesson 1 • Monitoring, Analytics, and Capacity

Uses Power Platform admin centre analytics, flow run history, and capacity dashboards. Students identify usage trends and optimise resource allocation across environments.

Lesson 2 • Governance, DLP, and Admin Controls

Covers data loss prevention policies, connector classification, and tenant-level admin controls. Students configure DLP policies that protect sensitive data without blocking productivity.

Lesson 3 • Environment Strategy and Pipelines

Designs a dev-test-production environment topology and configures Power Platform Pipelines. Students automate solution promotion with environment variable substitution.

Lesson 4 • Source Control with Azure DevOps

Integrates solution export with Azure DevOps repos and build pipelines using Power Platform CLI. Students commit solution changes and trigger CI/CD from a pull request.