Mastering Power Apps

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

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

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