Business Applications Category Banner Image

Microsoft Power Apps - Advanced

  • Length 1 day
  • Price  $595 inc GST
Course overview
View dates &
book now
Register interest

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.

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 Solutions Partner - Cloud - Training Services Logo

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level.  We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ. 


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

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


Request Course Information

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

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.




Offers

  • Power Platform 7 Course Program
    Become Microsoft Certified with the PL-900 exam Access 7 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Cost: $3,805.00 incl GST Duration: 7 days of courses, plus 2-3 hours per week Inclusions: 7 x courses, Unlimited support, Practice exam, Exam plus 1 resit
  • Power Platform 4 Course Program
    Become Microsoft Certified with the PL-900 exam Access 4 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Cost: $2,575.00 incl GST Duration: 4 days of courses, plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Exam plus 1 resit
  • Microsoft Word 3 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 3 Microsoft Word Training Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Cost: $1,380.00 incl. GST Duration: 3 days of courses Plus home practice Inclusions: 3 x courses + Practice exam
  • Microsoft Word 2 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 2 Microsoft Word Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Cost: $1,020.00 incl. GST Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • Digital Literacy Certification
    Earn your Digital Literacy Certification Access the Microsoft Office 365 Training Package. Elevate your core competencies from Word to PowerPoint, Excel and Power BI. Attend our instructor-led courses in-person or join remotely and learn from our team of experienced Microsoft Certified Trainers. Digital literacy training builds confidence across a range of areas. The courses provide foundational to intermediate knowledge of the most widely used applications in today’s workplace. Showcase your achievements and build your professional profile with this verifiable digital credential. Certification: Nexacu Digital Literacy Exam: Course Attendance Cost: $2,200.00 incl. GST Duration: 4 - 6 weeks Inclusions: 6 Instructor-led courses
  • PowerPoint 2 Course Program
    Become Microsoft PowerPoint certified and stand out from the crowd Validate your specialised skills with PowerPoint Level 1 and 2. Our two courses are jam-packed with tips and tricks that will revolutionise how you create presentations. The MO-300 exam and PowerPoint Associate certification will demonstration to employers your extensive knowledge of PowerPoint. We deliver great value by combining our two PowerPoint courses and the Microsoft certification into one package. In your certification package you will receive a Microsoft practice exam, the official exam, a free re-sit, and upon successfully passing the exam, the official Microsoft certification. Certification: Microsoft Certified: PowerPoint Associate Exam: MO-300 Cost: $995.00 incl. GST Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • Excel 2 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,135.00 incl. GST Duration: 2 days of courses Plus 2-3 hours per week Inclusions: 2 x courses + Practice exam
  • Excel 3 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,565.00 incl. GST Duration: 3 days of courses Plus 2-3 hours per week Inclusions: 3 x courses + Practice exam
  • Excel 4 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Beginner, Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,950.00 incl. GST Duration: 4 days of courses Plus 2-3 hours per week Inclusions: 4 x courses + Practice exam
  • Power BI 3 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2070.00 incl. GST Duration: 3 days of courses + Plus 2-3 hours per week Inclusions: 3 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 4 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Beginner, Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2395.00 incl. GST Duration: 4 days of courses + Plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 2 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit the Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $1,590.00 incl. GST Duration: 2 days of courses + Plus 2-3 hours per week Inclusions: 2 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only