Recent Searches
Category

Microsoft Power BI

Category

Microsoft Copilot Courses

Category

AI for Business

Category

Microsoft Windows 11 Courses

Category

Microsoft 365

Category

Microsoft Excel

Category

Excel Specialist

Category

Microsoft Project

Category

R Programming

Category

Python

Category

Power Apps

Category

SQL

Category

SharePoint

Category

Microsoft Teams

Category

Power Automate

Category

Microsoft Visio

Category

Microsoft PowerPoint

Category

Microsoft Word

Category

Microsoft Outlook

Category

Adobe InDesign Courses

Category

Adobe Photoshop Courses

Category

Adobe Illustrator Courses

Category

Adobe Premiere Pro Training

Category

Adobe After Effects Training

Category

Adobe Acrobat Courses

Category

Adobe Captivate Training

Category

Adobe Animate Training

Category

Canva Courses

Category

HTML Courses

Category

WordPress

Category

Professional Development

Category

Microsoft Access

Category

Webinars

Course

Power BI Beginner

Course

Copilot for M365

Course

Windows 11 End User Course

Course

Excel Beginner

Course

Financial Modelling

Course

Project Beginner

Course

R Programming Beginner

Course

Python Beginner

Course

Power Apps Beginner

Course

SQL Beginner

Course

SharePoint Beginner

Course

Teams Essentials

Course

Visio Essentials

Course

PowerPoint Level 1

Course

Word Beginner

Course

Word Advanced

Course

Word Intermediate

Course

Microsoft Outlook Beginner to Intermediate

Course

InDesign Lite

Course

Photoshop Lite

Course

Illustrator Training Intro

Course

Premiere Training Intro

Course

After Effects Training Intro

Course

Acrobat Essentials

Course

Captivate Training

Course

Animate Training Intro

Course

Canva AI

Course

HTML Training Intro

Course

Achieving Leadership & Success

Course

Microsoft Access Essentials

Course

Copilot for M365 On Demand

Course

Power BI Intermediate

Course

Copilot for Word

Course

ChatGPT Beginner

Course

Microsoft 365 Beginner

Course

Excel Intermediate

Course

Analysis and Dashboards

Course

Project Intermediate

Course

R Programming Intermediate

Course

Python Intermediate

Course

Power Apps Intermediate

Course

SQL Intermediate

Course

SharePoint Intermediate

Course

PowerPoint Level 2

Course

InDesign Training Intro

Course

Photoshop Training Intro

Course

Acrobat Forms

Course

Anger Management & Negotiation Skills

Course

Copilot for M365 Live Online

Course

Power BI Advanced

Course

Copilot for Excel

Course

AI Prompting Fundamentals

Course

Microsoft 365 Intermediate

Course

Excel Advanced

Course

Excel VBA

Course

Project Advanced

Course

R Programming Advanced

Course

Python Advanced

Course

Power Apps Intermediate | Power Automate + Power BI Integration

Course

SharePoint Advanced (Site Owner)

Course

InDesign Training Advanced

Course

Assertiveness & Confidence

Course

Microsoft Access Advanced

Course

Power BI DAX

Course

Copilot for PowerPoint

Course

Excel Expert

Course

Machine Learning in R

Course

Power Apps Advanced

Course

SharePoint Advanced (Document Governance)

Course

Building Resilience

Course

Copilot for Outlook and Teams

Course

Coaching and Mentoring

Course

Illustrator Training Advanced

Course

Premiere Basics Training

Course

Advanced After Effects Training

Course

Canva Beginners

Course

WordPress Essentials

Course

Communications

Course

AI for Business Leaders and Managers

Course

Photoshop Training Advanced

Course

Advanced Premiere Training

Course

Canva Intermediate

Course

Communications & Quality Client Service Training

Course

InDesign Interactivity Training

Course

Canva Advanced

Course

Critical Thinking and Problem Solving

Course

InDesign Accessibility Training

Course

Cultural Diversity in the Workplace

Course

Microsoft Outlook Advanced

Course

Embracing Change

Course

SQL Advanced

Course

Growing Emotional Intelligence

Course

Planner Premium

Course

Minute Taking

Course

Excel Tables and Pivot Tables

Course

Power Automate Beginner

Course

Performance Management

Course

Data Transformation with Power Query

Course

Excel Macro Mastery

Course

Power Automate Intermediate

Course

Persuasion and Negotiation Skills

Course

Power BI Desktop Advanced Reporting

Course

Presentation Skills and Public Speaking

Course

Data Visualisation with Power BI Desktop

Course

Practical Project Management

Course

Respect, Equity and Diversity (RED)

Course

Resumé Writing and Interview Skills

Course

Stress Management

Course

Team Leadership, Management and Development

Course

Time Management Intensive

Course

Train the Trainer

Course

Write Effective Business Documents

Course

Dealing with Difficult People

Course

Managing Difficult Conversations

Course

Managing the Virtual Workplace

Course

Customer Service Training

Course

Technical Writing

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
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 13 Mar 26
Fri
13
Mar
Power Apps Advanced
Remote East
Status: Scheduled
Scheduled
Tue 7 Apr 26
Tue
7
Apr
Power Apps Advanced
Remote East
Status: Scheduled
Scheduled
Brisbane

We are currently developing this course.

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

Sydney
Date
Course
City
Status
Tue 7 Apr 26
Tue
7
Apr
Power Apps Advanced
Sydney
Status: Scheduled
Scheduled
Melbourne

We are currently developing this course.

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

Canberra
Date
Course
City
Status
Fri 13 Mar 26
Fri
13
Mar
Power Apps Advanced
Canberra
Status: Scheduled
Scheduled
Adelaide

We are currently developing this course.

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

Perth
Date
Course
City
Status
Fri 5 Jun 26
Fri
5
Jun
Power Apps Advanced
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Fri 5 Jun 26
Fri
5
Jun
Power Apps Advanced
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 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 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

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