Business Applications Category Banner Image

Microsoft Power Apps - Advanced

Length 1 day

Course overview

View dates &
book now

Why study this course

Microsoft's Power Apps is the go-to tool for mobile application development. Described as the “citizen application development platform”, it empowers everyone to solve problems and improve processes in the workplace with custom apps. The point-and-click approach means anyone can successfully make their own app, from the CEO to the factory floor worker, with minimal coding and without the need for an IT developer. Choose from templates and customise, or build your own app from a blank canvas, and simply publish to the web. Compatible with iOS, Android, and Windows. Our Power Apps training courses can help you make the most of this exciting application.

Learn about the advanced capabilities of Power Apps and dive deep into its core components, including the pivotal Common Data Service (CDS). Discover how Power Apps integrates with the Power Platform suite of tools to automate intricate workflows (with Power Automate), and analyse data (using Power BI). You'll deliver a case study solution leveraging the CDS to securely store and manage data that's used by your business applications. You'll set up entities, logic, and validation in CDS and explore building Model-Driven Apps and Portals.

Whether you're aiming to streamline operations, foster collaboration, or unlock new potentials in data analytics, this course will equip you with the knowledge and skills to transform your business aspirations into reality.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Book now!

Request Course Information

What you’ll learn

At the completion of this course you should be able to:

Understand the full depth of Power Apps capabilities
Create and modify the Common Data Service (CDS) to store your data
Connect Canvas and Model-driven apps to the CDS
Create Portal apps to allow external users to view data

Microsoft Apps at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. Join more than 5,000 students who attend our quality Microsoft courses every year.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is targeted at skilled end-users of Power Apps, harnessing the Common Data Service, and diving deeper into integration with other Power Platform tools.

Course subjects

Introduction to Power Platform

What is the Power Platform?
Components of the Power Platform
The Common Data Service (CDS) and the Power Platform

Licensing Requirements

Understanding different licensing
Understanding per app licensing
Understanding per user licensing
Understanding portal subscriptions

Case Study Introduction

The business problem
Planning a Power Platform solution

Common Data Service (CDS)

What is the Common Data Service?
What is the Common Data Model?
Understanding elements of the CDS

Creating a Solution

What is a solution?
When to use solutions
Creating a solution in CDS

Creating a Publisher

What is a publisher?
When to use publishers
Creating a publisher in CDS

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

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 within Power Apps
Adding images to records
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 CDS 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 Apps

What is a model-driven app?
Purpose of using a model-driven app
Relationship between app and data types

Creating Model-Driven Apps

Understanding a site map
Editing a site map
Using the App designer
Creating a new view in the app designer
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 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 Portal Apps

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 a Portal App

Connecting CDS to the portal
Displaying data in a portal

Security of Portal Apps

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

Prerequisites

Students should have completed our Power Apps Beginner and Intermediate courses.

The course content also requires users to have a Power Apps Premium Licence.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.