Mastering Power Apps

Mastering Power Apps provides a deep dive into Microsoft’s low-code platform for building business applications. Tailored for users with existing Power Apps experience, this course develops the skills needed to design, implement, and manage advanced Power Apps solutions. Learners will explore responsive design, sophisticated data operations, SharePoint integration, and automation via Power Automate. Through hands-on labs and real-world tasks, learners gain proficiency in app optimisation, administration, and advanced control customisation.

Please note - Under the umbrella term of Power Apps, Microsoft include three types of apps: Canvas Apps, Model-driven apps and Power Pages (previously known as Power Apps Portals). This course exclusively looks at canvas apps and uses generic Office 365 data sources (i.e. not Dataverse or SQL) for examples.

For training on Model-driven apps and Dataverse, please refer to course Mastering Power Platform Dataverse and Model-Driven Apps (QAMPMOD).

Power Pages are covered on the course Microsoft Power Platform Developer (MPL400).

By the end of this course, learners will be able to:

• Design apps using advanced controls and custom components
• Create responsive layouts that adjust to different devices
• Implement complex data operations including sorting, filtering, and patching
• Integrate Power Apps with SharePoint and Power Automate
• Apply validation, error handling, and performance tuning techniques
• Manage app environments, versioning, and deployment through the Power Platform admin centre

To fully benefit from this course, learners should have:

• Previous experience with creating basic apps in Microsoft Power Apps
• A working knowledge of Office 365, particularly SharePoint and OneDrive
• Familiarity with Excel formulas and basic data concepts

Attendance of the QA course Microsoft PowerApps Essentials (QAPAESS) can be used to provide the pre-requisite skills for this course.

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Instructors will demonstrate features throughout the event. Optional Lab exercises are available for students to complete within a delegate created free trial tenancy. Microsoft may require a valid credit card to create 30 day free tenancies which must be cancelled within 30 days to avoid incurring charges. QA have no control over the Microsoft 365 trial tenancy signup or billing process.

Target audience

This course is ideal for:

• Power Platform users ready to advance their app development skills
• Business analysts and citizen developers involved in creating custom data tools and workflow automation
• IT professionals supporting low-code app development in Microsoft environments

Module 1 – Advanced controls

• Connectors, connections, and delegation
• Working with components, timers, galleries, and forms
• Customising data cards and using charts
• Dropdown vs combo box controls
• Dynamic icons and conditional control visibility

Module 2 – Responsive apps

• App dimensioning and screen orientation
• Disabling 'Scale to fit' for dynamic UIs
• Layout containers (vertical and horizontal)
• Using flexible and fixed control sizing
• Screen size detection and adaptive layouts

Module 3 – Advanced data operations

• Understanding records, tables, and shaping functions
• Using AddColumns, DropColumns, Filter, SortByColumns, etc.
• Managing collections and global/context variables
• Implementing the Patch function for CRUD operations
• Using named formulas for performance optimisation

Module 4 – Administration

• Power Platform admin centre and app environments
• Sharing, publishing, and version control
• Data policies and licensing considerations

Module 5 – Integration with Power Automate

• Understanding flows: triggers, actions, and responses
• Calling flows from apps and passing parameters
• Capturing and handling flow output

Module 6 – Working with SharePoint

• Connecting to SharePoint data sources
• Customising and replacing SharePoint list forms
• Managing complex columns (choice, person, lookup)
• Uploading files to SharePoint using Power Automate

Module 7 – Optimising Power Apps

• Data validation techniques using IsMatch and logic
• Improving perceived app performance and load time
• Limiting control dependencies across screens
• Handling large datasets efficiently
• Error Handling
• Using Power Apps Monitor and Test Framework for diagnostics

Exams and assessments

There is no formal exam associated with this course. Instead, learners complete structured lab exercises that simulate real-life scenarios and test their understanding through applied builds.

Hands-on learning

• Labs covering real-world app scenarios including task tracking, SharePoint form replacement, and workflow automation
• Responsive design exercises with vertical and horizontal containers
• Advanced data shaping and Patch-based updates
• End-to-end app build integrating SharePoint, OneDrive, and Power Automate