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

Take your Task Management app to the next level by integrating Power Automate and Power BI with Power Apps and SharePoint. You’ll work hands-on to assign users via flows, generate and save PDFs to SharePoint, send critical task reports by email, and embed a Power BI report for visual insights and dashboard-style reporting.

This pathway mirrors a structured, step-by-step build: prepare SharePoint and the app, create and install flows, pass parameters between Power Apps and Power Automate, format and send email reports, generate PDFs from app screens, and embed Power BI tiles with optional URL filtering. You’ll leave with reusable patterns for real business apps not just demos.

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

  • Prepare and validate SharePoint list settings and import Excel data
  • Import and configure an MSAPP app and establish connections
  • Build flows to assign users and update SharePoint Person fields correctly
  • Create a “Critical Tasks” reporting flow with filtering, sorting, variables, and HTML tables
  • Generate PDFs from Power Apps and save them to SharePoint via flows
  • Embed Power BI tiles with optional URL filtering and improve navigation using reusable components

Prerequisite:

Intermediate Excel and basic Power Apps Canvas app skills (or Power Apps Beginner / Intermediate Pathway 1). SharePoint Lists helpful.

Course Details

Download Course PDF
Price
$595
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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
Thu 19 Mar 26
Thu
19
Mar
Power Apps Intermediate (Power Automate + Power BI Integration)
Remote East
Status: Scheduled
Scheduled
Fri 27 Mar 26
Fri
27
Mar
Power Apps Intermediate (Power Automate + Power BI Integration)
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Thu 19 Mar 26
Thu
19
Mar
Power Apps Intermediate (Power Automate + Power BI Integration)
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Fri 27 Mar 26
Fri
27
Mar
Power Apps Intermediate (Power Automate + Power BI Integration)
Sydney
Status: Scheduled
Scheduled
Melbourne

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

Canberra

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

Adelaide

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

Perth

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

Remote West

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

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 Intermediate (Building Smarter, Scalable Apps)

In this intermediate Power Apps pathway, you’ll build a Task Management app connected to SharePoint while improving performance with collections and mastering Patch, variables, and delegation-aware filtering.

download course pdf
Price: $595
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

Power Apps Intermediate Pathway 2: Power Automate + Power BI Integration Course Content

Expand All | Collapse All

SharePoint Integration & App Preparation

Check locale settings

Check SharePoint list settings

Import list data from Excel

Import the MSAPP file

Allow connections to be established

Add a SharePoint connection

Explore the app features, layout, and formulas

Create screens

Update SharePoint via Power Automate (Assign Users)

Create Instant Flow: Assign users to task

Add flow inputs

Split multiple emails into an array

Map emails into a Claims object (Person field format)

Update SharePoint items via Power Automate

Pass values from the trigger

Add multiple emails to one Person field

Respond to Power Apps with a text output message

Install the flow in the app and bind a button to run it

Power BI Integration

Create a Power BI report

Add a stacked column chart

Add a pie chart

Use a URL query filter

Embed a Power BI tile in Power Apps

Filter the report from the gallery (dynamic filtering)

Share the Power BI report with app users separately

Filter & Manage Data with Power Automate (Critical Tasks)

Create responsive screen layout

Add nested containers

Add a gallery and controls to a container

Customise gallery data

Create Instant Flow: Critical tasks

Use Filter Query

Sort records

Initialise integer and string variables

Build and format an HTML table

Reshape table data and use HTML codes for formatting

Send emails from Power Automate

Pass flow output parameters back to the app

Generate PDFs & Save to SharePoint

Create Instant Flow: Create PDF (file input)

Convert time zone from UTC to local

Create files in SharePoint via Power Automate

Enable the PDF function in app settings

Generate a PDF from the task container

Send the PDF to the flow

Set gallery size dynamically

UI & UX Enhancements (Components)

Intro to Components

Create a sidebar component

Enable app scope access

Set width and height

Add icons, user image, and labels

Create custom properties

Bind controls to custom properties

Add components to app screens

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)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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)
8
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 Intermediate (Building Smarter, Scalable Apps)

In this intermediate Power Apps pathway, you’ll build a Task Management app connected to SharePoint while improving performance with collections and mastering Patch, variables, and delegation-aware filtering.

download course pdf
Price: $595
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

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?

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals