All courses are available in-person or remotely.
To attend remotely, select "Remote Online" as your location on book now.

Build smarter, scalable Canvas apps by creating a real-world Task Management solution in Power Apps connected to a SharePoint (Work Tracker) list. You’ll learn how to design galleries and forms, implement filtering (including delegation considerations), and write back to SharePoint using Patch and bulk update patterns.

This pathway is hands-on and trainer-led. You’ll improve app performance with collections and OnStart logic (including Concurrent), calculate key metrics using Named Formulas and variables, and apply UI/UX enhancements like validation, notifications, and safe delete prompts the stuff that makes an app feel “production-ready” instead of “weekend prototype.”

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

  • Build a Task Management (Work Tracker) Canvas app connected to a SharePoint list
  • Connect and work with multiple data sources, then bind galleries and controls confidently
  • Implement filtering using Combo Boxes and understand delegation warnings and limits
  • Use Named Formulas and variables (screen, global, and formula variables) for dynamic calculations
  • Update data using Patch, bulk updates with ForAll, and sync changes back to SharePoint
  • Improve performance using collections, caching, and Concurrent loading patterns

Prerequisite:

Participants should have intermediate Excel skills and a basic understanding of Power Apps, including experience creating simple Canvas apps (controls, screens, and formulas) or completion of the Power Apps Beginner course.

Course Details

Download Course PDF
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East
Date
Course
City
Status
Fri 6 Feb 26
Fri
6
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Remote East
Status: Confirmed
Confirmed
Fri 13 Feb 26
Fri
13
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Remote East
Status: Confirmed
Confirmed
Tue 17 Mar 26
Tue
17
Mar
Power Apps Intermediate (Building Smarter, Scalable Apps)
Remote East
Status: Scheduled
Scheduled
Brisbane

We currently have no public courses scheduled. Please contact us to register your interest.

Sydney

We currently have no public courses scheduled. Please contact us to register your interest.

Melbourne
Date
Course
City
Status
Fri 13 Feb 26
Fri
13
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Melbourne
Status: Scheduled
Scheduled
Canberra

We currently have no public courses scheduled. Please contact us to register your interest.

Adelaide
Date
Course
City
Status
Fri 6 Feb 26
Fri
6
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Adelaide
Status: Scheduled
Scheduled
Tue 17 Mar 26
Tue
17
Mar
Power Apps Intermediate (Building Smarter, Scalable Apps)
Adelaide
Status: Scheduled
Scheduled
Fri 1 May 26
Fri
1
May
Power Apps Intermediate (Building Smarter, Scalable Apps)
Adelaide
Status: Scheduled
Scheduled
Fri 12 Jun 26
Fri
12
Jun
Power Apps Intermediate (Building Smarter, Scalable Apps)
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Wed 18 Feb 26
Wed
18
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Perth
Status: Scheduled
Scheduled
Wed 3 Jun 26
Wed
3
Jun
Power Apps Intermediate (Building Smarter, Scalable Apps)
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Wed 18 Feb 26
Wed
18
Feb
Power Apps Intermediate (Building Smarter, Scalable Apps)
Remote West
Status: Scheduled
Scheduled
Wed 3 Jun 26
Wed
3
Jun
Power Apps Intermediate (Building Smarter, Scalable Apps)
Remote West
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power Apps Training Courses

Course Icon Power Apps Beginner

This beginner Power Apps training course teaches you how to build custom business apps using Microsoft’s low-code platform.

download course pdf
Price: $440
Course Icon Power Apps Advanced

Our advanced Power Apps training course covers model-driven apps, Common Data Service (CDS), and portal development for enterprise use.

download course pdf
Price: $595
Course Icon Power Apps Intermediate (Power Automate + Power BI Integration)

In this intermediate Power Apps training course, you’ll work with canvas components, collections, and Power Automate integrations.

download course pdf
Price: $595

Power Apps Intermediate Pathway 1: Building Smarter, Scalable Apps Course Content

Expand All | Collapse All

SharePoint Integration & Data Management

Create the app and set screen layout

Create and configure the Work Tracker SharePoint list

Import initial records

Add multiple data connections

Bind a gallery to the Work Tracker data source

Set gallery layout and apply conditional formatting

Bind additional controls and add input controls

Use Coalesce for error handling

Filter with Combo Box and understand delegation warnings

Collections & OnStart Performance

Use collections to cache data

Improve performance and reliability with collections

Write OnStart logic for loading data

Use Concurrent to speed up loading

Calculations & Variables

Create app-level Named Formulas

Handle formula errors and use formulas in controls

Use screen variables with UpdateContext

Create global variables with Set

Use formula variables with With and understand limitations

Check and debug values in the Variables pane

Updating & Handling Data (SharePoint)

Update a single record using Patch (to a collection)

Select and bulk update records using ForAll

Sync changes from collections back to SharePoint

Update Choice fields and Person fields

Add new records using Defaults

Validate forms and minimise date entry effort

Remove records safely with warnings and confirmation prompts

Enhancing User Experience

Use context variables to control visibility and layout changes

Provide clear success and validation messages using Notify

Refresh collections after data source changes to keep data in sync

Frequently Asked Questions

What is PowerApps?

PowerApps is a Microsoft application that allows anybody to create an App using a point-and-click approach. It empowers users to create apps to solve problems and improve processes in the workplace without the need for IT developers. We are a market leader in PowerApps training. 

What is Remote Training?

Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, and participate in discussions as if they were in the room.

Which courses are available if I am working from home?

All of our Public Courses are available to be delivered remotely. Book any course as normal and you will receive login details and instructions the evening before your course.

How are PowerApps used in the workplace?

How PowerApps is used is as varied as Microsoft's customer base. A common use of PowerApps is as a data collection tool. Workers in the field collect data via the app on their own devices which is then collated in the cloud. The combined data can be analysed using Power BI to make data-driven decisions. The government of NSW are using PowerApps data collection to help reduce the level of homelessness, Priceline is using PowerApps to better serve customers and Virgin Airlines has included PowerApps in their safety compliance procedures. Our PowerApps course will empower you to create innovative solutions for your workplace problems. 

How long does it take to learn PowerApps?

After our one-day PowerApps beginner course, you will be able to create a professional app that you can share within your organisation. You can continue on our intermediate course to advance your knowledge and capability within PowerApps. Learning how to integrate PowerApps with Power Automate and Power BI will open up lots more possibilities. Our Power Apps training can also be completed as part of one of our packages, which culminates in a Microsoft certification. 

I previously attended a course with Excel Consulting, will the training be similar?

Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu better reflects our direction, continued innovation and commitment to delivering next-level learning. We have always refined and continue to update our courses but retain our excellent trainers and deliver the same high-quality content.

Course Details

Download Course PDF
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

skills test nexacu

Skills Test

Try our short skills test and find out which course is right for you.

Skills Test

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Power Apps Beginner

This beginner Power Apps training course teaches you how to build custom business apps using Microsoft’s low-code platform.

download course pdf
Price: $440
Course Icon Power Apps Advanced

Our advanced Power Apps training course covers model-driven apps, Common Data Service (CDS), and portal development for enterprise use.

download course pdf
Price: $595
Course Icon Power Apps Intermediate (Power Automate + Power BI Integration)

In this intermediate Power Apps training course, you’ll work with canvas components, collections, and Power Automate integrations.

download course pdf
Price: $595

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Nationwide by Leading Organisations

at Nexacu, we're proud to be the trusted training partner for hundreds of leading organisations accross Australia and New Zealand. From government departments to top corporates, we help teams upskill and succeed everyday

  • 400+ companies rely on Nexacu for team training
  • Trusted by federal, state, and local government agencies
  • Delivering training across 9 countries

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals