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

Learn about the advanced capabilities of Power Apps when combined with the Common Data Service (CDS) in this low-code course. You will deliver a case study solution leveraging the CDS to securely store and manage data that's used by your business applications. You will set up entities, logic and validation in CDS and explore building Model-Driven Apps and Portals.

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

  • Understand the full capabilities of Power Apps
  • Create and modify Microsoft Dataverse (formerly CDS) to store data
  • Connect canvas and model-driven apps to Dataverse
  • Build Portal apps for external users to view data

Prerequisite:

Participants should have completed Power Apps Beginner and Intermediate courses. A Power Apps Premium licence is required, and the course is designed for skilled end-users.

Course Details

Download Course PDF
Price
$595 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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 22 Aug 25
Fri
22
Aug
Power Apps Advanced
Remote East
Status: Few Seats
Few Seats
Thu 25 Sep 25
Thu
25
Sep
Power Apps Advanced
Remote East
Status: Confirmed
Confirmed
Fri 24 Oct 25
Fri
24
Oct
Power Apps Advanced
Remote East
Status: Confirmed
Confirmed
Tue 2 Dec 25
Tue
2
Dec
Power Apps Advanced
Remote East
Status: Confirmed
Confirmed
Brisbane
Date
Course
City
Status
Mon 18 Aug 25
Mon
18
Aug
Power Apps Advanced
Brisbane
Status: Sold Out
Sold Out
Sydney
Date
Course
City
Status
Fri 22 Aug 25
Fri
22
Aug
Power Apps Advanced
Sydney
Status: Few Seats
Few Seats
Fri 24 Oct 25
Fri
24
Oct
Power Apps Advanced
Sydney
Status: Scheduled
Scheduled
Tue 2 Dec 25
Tue
2
Dec
Power Apps Advanced
Sydney
Status: Scheduled
Scheduled
Melbourne
Date
Course
City
Status
Fri 24 Oct 25
Fri
24
Oct
Power Apps Advanced
Melbourne
Status: Few Seats
Few Seats
Tue 2 Dec 25
Tue
2
Dec
Power Apps Advanced
Melbourne
Status: Scheduled
Scheduled
Canberra

We are currently developing this course.

Dates to be announced soon. Contact us to register your interest.

Adelaide
Date
Course
City
Status
Thu 25 Sep 25
Thu
25
Sep
Power Apps Advanced
Adelaide
Status: Confirmed
Confirmed
Perth
Date
Course
City
Status
Wed 20 Aug 25
Wed
20
Aug
Power Apps Advanced
Perth
Status: Few Seats
Few Seats
Thu 16 Oct 25
Thu
16
Oct
Power Apps Advanced
Perth
Status: Scheduled
Scheduled
Tue 2 Dec 25
Tue
2
Dec
Power Apps Advanced
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Thu 16 Oct 25
Thu
16
Oct
Power Apps Advanced
Remote West
Status: Confirmed
Confirmed
Tue 2 Dec 25
Tue
2
Dec
Power Apps Advanced
Remote West
Status: Confirmed
Confirmed
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 $490
Course Icon Power Apps Intermediate

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

download course pdf
Price: $595 $660

PowerApps Advanced Course Content

Expand All | Collapse All

Introduction to Power Platform

What is the Power Platform

Components of the Power Platform

The Common Data Service (CDS) and the Power Platform

Licencing requirements

Understanding different licencing

Understanding per app licencing

Understanding per user licencing

Understanding portal subscriptions

Case study introduction

The business problem

Planning a Power Platform solution

Common data service

What is the Common Data Service

What is the Common data model

Understanding elements of the Common Data Service

Creating a solution

What is a solution

When to use solutions

Create a solution in Common Data Service

Creating a publisher

What is a publisher

When to use publishers

Create a publisher in Common Data Service

Entities

What is an entity

Exploring standard entities

Creating an entity

Exploring custom entities

Fields

What is a field

What is a primary field

Exploring standard fields in an entity

Creating date fields

Creating option set fields

Fields (cont'd)

Creating a new Option set

Creating currency fields

Creating text fields

Creating calculated fields

Creating image fields

Saving your entity

Understand when to save your entity

Adding data to an Entity

How to add data via Excel

Add data within Power Apps

Add images to records

Using views

Understanding what views are

Using views to see data

Editing existing views

Creating new views

Using forms

Understanding what forms are

Using forms to see records

Editing existing forms

Creating new forms

Entity relationships

Exploring standard relationships

Understanding different types of relationships

Creating a relationship between entities

Business Rules

What are business rules

When to use business rules

Creating a business rule

Setting a field value

Hiding a field

Validating, saving and activating business rules

Adding data to an entity

Different ways of adding data

Adding data using Excel

Adding data through a form

Editing forms

Canvas Apps

Uploading a pre-built canvas app

Displaying the app version in the app

Connecting Canvas app to entity

Connecting to Common Data Service entities

Connecting CDS data source to a gallery

Setting up the Canvas App

Adding a form

Editing fields

Using a gallery to select records

Understanding look up fields in canvas apps

Entering data via the Canvas App

Searching entity data

Using a barcode to find data

Sharing canvas apps

Model-driven app

What is a model-driven app

Purpose of using a model-driven app

Relationship between app and data types

Creating Model-driven app

Creating a model-driven app

Understanding a site map

Editing a site map

Using the App designer

Creating a new view in the app designer

Creating Model-driven app (cont'd)

Using related fields in views

Playing the app

Editing a form in the app designer

Publishing all customisations

Sharing model-driven apps

Changing data with the model-driven app

Business process flows

Understanding business process flows

Creating a new business process flows

Adding stages

Adding data steps

Adding conditions

Connecting steps

Portal App

Understanding Common Data Service connectors in Power Automate

Creating a flow in a solution

Understanding CDS triggers

Using CDS actions to retrieve data

Portal Apps

What is a Portal app

Purpose of using a portal app

Creating a portal app

Administering Portal Apps

Understanding different options of administering a portal

Exploring the portal admin centre

Understanding the model-driven management app

Exploring the portal management app

Exploring the portal designer

Content management of a Portal App

Updating website content with click and type

Updating website content with code

Updating website content through model-driven app

Adding pages to a portal site

Connecting CDS to Portal App

Connecting CDS to the portal

Displaying data in a portal

Security of a Portal App

Understanding portal security and permissions

Creating web page access control rules

Applying permissions to a page

How to authenticate a user

Viewing a restricted page

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 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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 $660
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

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

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 $490
Course Icon Power Apps Intermediate

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

download course pdf
Price: $595 $660

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