Advanced Power Apps Course

Lesson 1 • Navigating Power Apps Studio

Introduces the canvas and model-driven studio interfaces, toolbars, and property panes. Builds the navigation fluency required for efficient app development.

Lesson 2 • Licensing and Environment Setup

Explains licence tiers, capacity limits, and environment provisioning. Students leave able to select the correct licence and configure a dev environment.

Lesson 3 • Data Source Connections

Demonstrates adding and managing connectors to external data sources. Connects foundational data concepts to practical app-building workflows.

Lesson 1 • Navigation and Screen Flow

Implements Navigate, Back, and deep-link patterns to create intuitive multi-screen flows. Ties screen design to user experience goals.

Lesson 2 • Core Input and Display Controls

Covers text inputs, dropdowns, galleries, forms, and media controls with their key properties. Provides the building blocks for all data-entry and display screens.

Lesson 3 • Screen Layout and Responsive Design

Teaches container controls, flexible layouts, and breakpoint strategies for multi-device support. Directly enables professional-grade UI construction.

Lesson 4 • Styling and Theming

Applies consistent colour palettes, typography, and icon sets across screens using global variables. Ensures brand-aligned, maintainable app aesthetics.

Lesson 1 • Advanced Formula Techniques

Explores With, ForAll, and concurrent execution for performance and readability. Prepares students for complex, production-grade formula design.

Lesson 2 • Conditional and Branching Logic

Applies If, Switch, and IIf to drive dynamic control visibility, colour, and data routing. Connects formula logic directly to UI behaviour outcomes.

Lesson 3 • Power Fx Language Fundamentals

Introduces data types, operators, and expression evaluation order in Power Fx. Establishes the syntax foundation for all formula work in the course.

Lesson 4 • Variables and Collections

Explains Set, UpdateContext, Collect, and ClearCollect for state management. Teaches when to use global vs. local variables for clean app architecture.

Lesson 1 • Dataverse Tables and Columns

Creates standard and custom tables, configures column types, and sets required constraints. Provides the data foundation for model-driven and canvas apps.

Lesson 2 • Relationships and Lookups

Configures one-to-many, many-to-many, and polymorphic relationships between tables. Enables relational data retrieval across complex app scenarios.

Lesson 3 • Dataverse Security Model

Implements security roles, field-level security, and record ownership to control data access. Aligns data governance with organisational permission structures.

Lesson 4 • Solutions and ALM Basics

Packages tables, apps, and flows into managed and unmanaged solutions for deployment. Introduces application lifecycle management practices for Dataverse assets.

Lesson 1 • Dashboards and Charts

Builds system dashboards with charts, lists, and iframes for operational visibility. Delivers actionable insights directly within the model-driven app.

Lesson 2 • Form Design and Customisation

Designs main, quick-create, and card forms with tabs, sections, and field controls. Directly shapes the data-entry experience for end users.

Lesson 3 • Views and Grids Configuration

Creates and customises system, public, and personal views with filters and column sets. Enables users to surface the right records in the right context.

Lesson 4 • Model-Driven App Structure

Explains site maps, app modules, and navigation areas that define model-driven app structure. Establishes the architectural difference from canvas apps.

Lesson 1 • Automated and Scheduled Flows

Builds automated flows on Dataverse row events and scheduled recurrence triggers. Automates background data processing without user intervention.

Lesson 2 • Approval Workflows

Implements sequential and parallel approval flows with adaptive card notifications. Enables structured review processes integrated with Power Apps forms.

Lesson 3 • Triggering Flows from Canvas Apps

Configures instant flows with Power Apps triggers and passes parameters from button actions. Bridges user interactions in the app to automated backend processes.

Lesson 1 • Data Loss Prevention Policies

Configures DLP policies to classify connectors and restrict data movement across boundaries. Aligns app connectivity with organisational data governance requirements.

Lesson 2 • App Performance Profiling

Uses the Monitor tool and performance analyser to identify slow formulas and network calls. Translates profiling data into targeted optimisation actions.

Lesson 3 • Role-Based Access and Sharing

Shares canvas apps with security groups and assigns model-driven app security roles. Controls who can access, edit, and co-own apps in production.

Lesson 4 • Delegation and Query Optimisation

Resolves delegation warnings and rewrites non-delegable queries using server-side filtering. Prevents data truncation and performance degradation at scale.

Lesson 1 • Offline-Capable App Design

Implements local collection caching and sync patterns for apps used without connectivity. Addresses data conflict resolution and sync status feedback.

Lesson 2 • ALM Pipelines and CI/CD

Automates solution export, build validation, and deployment using pipeline tools. Establishes repeatable, auditable release processes for enterprise teams.

Lesson 3 • Custom Connectors

Builds custom connectors from OpenAPI definitions to integrate external REST APIs. Extends Power Apps beyond standard connector limitations.

Lesson 4 • App Lifecycle and Maintenance

Manages versioning, rollback, and deprecation strategies for live production apps. Ensures long-term maintainability and minimal user disruption during updates.