PL-100 Microsoft Power Platform App Maker
ENQUIRE NOW!
Course Code:
Open
Duration:
4 Days
Delivery Mode:
Classroom
Start Date:
26-11-24
End Date:
29-11-24
Fees:
$3052.00

This course will teach you how to build apps with low-code techniques to simplify,
automate, and transform business tasks and processes using Microsoft Power Platform.
This course may contain a 1-day Applied Workshop that is in preview. This workshop will
allow you to practice your App Maker skills by creating an end-to-end solution to solve
a problem for a fictitious company. The solution will include a Microsoft Dataverse
database, Power Apps canvas app, and Power Automate flows.

Course dates and course fee may be subjected to changes.

Course Outline

Lesson 1: Get started with Microsoft Power Platform for app makers
  • Identify components
  • Create apps
  • Get started with Microsoft Dataverse
  • Introduction to environments
  • Work with Copilot in Microsoft Power Platform
Lesson 2: Create tables in Dataverse
  • Introduction to Microsoft Dataverse
  • Table characteristics
  • Exercise – Create a Microsoft Dataverse table
  • Exercise – Import data into your Microsoft Dataverse database
  • Table relationships
  • Exercise – Create table relationships
  • Dataverse logic and security
  • Exercise – Create a custom table and import data
  • Dataverse auditing
  • Dual-write vs. virtual tables
Lesson 3: Create and manage columns within a table in Dataverse
  • Define columns in Microsoft Dataverse
  • Column types in Microsoft Dataverse
  • Add a column to a table
  • Primary name column
  • Restrictions that apply to columns in a table
  • Create an auto numbering column
  • Create an alternate key
  • Exercises
Lesson 4: Load/export data and create data views in Dataverse
  • View data in a table
  • Create or edit views of data in a table
  • Dataverse data import options
  • Load data into a table
  • Dataverse data export options
  • Export
  • Add, update, or delete data in a table by using Excel
  • Import data using Power Query
Lesson 5: Export data from Dataverse and use Microsoft Excel to edit records
  • Export data to Excel
  • Exercise – Create an editable Excel file for bulk validation
  • Edit and update data in Excel
  • Exercise – Edit account information in Excel and visualize updates in Dataverse
Lesson 6: Get started with Microsoft Dataverse for Teams
  • Dataverse for Teams vs Dataverse
  • Provision your first Dataverse environment
  • Create your first table to store data
Lesson 7: Build your first app with Power Apps and Dataverse for Teams
  • Create your first app with the hero template
  • Customize your app with Power Apps Studio
  • Publish your app
  • Install template apps
Lesson 8: Build your first workflow with Power Automate and Dataverse for Teams
  • Types of workflows that Power Automate can build in Dataverse
  • Exercise – Create a workflow that triggers when a new message is created
  • Exercise – Add a flow to your Power Apps app
  • Schedule a flow
Lesson 9: Create reports with Power BI and Dataverse for Teams
  • Connect to and transform Dataverse for Teams data from Power BI
  • Create a Power BI report
  • Publish the report
  • Share the data
Lesson 10: Get started building with Power BI
  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service
Lesson 11: Explore what Power BI can do for you
  • What can I do with the Power BI service as a consumer?
  • View content in the Power BI service
  • Explore Power BI using dashboards, reports, and apps
  • Collaborate and share in Power BI
  • Find and view dashboards and reports
Lesson 12: Manage workspaces and datasets in Power BI
  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection
Lesson 13: Create dashboards in Power BI
  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Review Quick insights
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Set mobile view
  • Exercise – Create a Power BI dashboard
Lesson 14: Secure, publish, and share data in Power BI
  • Share and use reports in Power BI
  • Row-level security
  • Publish a report to a Power BI workspace
  • Share reports and user experience
  • Protect data in Power BI
  • Data refresh and alerts
Lesson 15: Embed Power BI content
  • Embed Power BI reports
  • Embed other Power BI content types
  • Optimize the embedding experience
Lesson 16: How to build your first model-driven app with Dataverse
  • Introduction to Dataverse
  • Introduction to model-driven apps
  • Model-driven apps, powered by Microsoft Dataverse
  • Explore sample apps
Lesson 17: Get started with model-driven apps in Power Apps
  • Introducing model-driven apps
  • Components of model-driven app
  • Design model-driven apps
  • Exercise
  • Exercise – Control security when sharing model-driven apps
  • Incorporate business process flows
  • Exercise – Create a model-driven app
Lesson 18: Configure forms, charts, and dashboards in model-driven apps
  • Forms overview
  • Form elements
  • Configure multiple forms
  • Use specialized form components
  • Configure views overview
  • Configure grids
  • Create and edit views
  • Configure charts overview
  • Dashboards overview
  • Use interactive streams and tiles
Lesson 19: Manage Dynamics 365 model-driven app settings and security
  • Configure role-based security
  • Manage teams and business units
  • Explore settings and customizations
  • Knowledge check
  • Exercise – Create a new security role
Lesson 20: Use specialized components in a model-driven form
  • Create business process flows
  • Exercise – Create a business process flow
  • Embed a canvas app in a model-driven form
  • Add a timeline in a model-driven form
  • Create a report in a model-driven form
Lesson 21: Create a canvas app in Power Apps
  • Introduction to Power Apps
  • Start Power Apps
  • Exercise – Create your first app in Power Apps
  • Power Apps data sources
  • Exercise – Create an app from Excel using Copilot
  • Use Power Apps with Power Automate and Power BI
  • Designing a Power Apps app
Lesson 22: Use and understand Controls in a canvas app in Power Apps
  • Introduction to controls
  • Core properties of controls
  • Entering and displaying data with text controls
  • Additional controls for enhancing your app’s usability
  • Media
  • Modern controls
  • Work with component libraries
  • Lab – Create a canvas app with unique controls
  • Exercise – Upload file to SharePoint document library
Lesson 23: Create formulas to change properties in a Power Apps canvas app
  • Formulas overview
  • Use a formula to modify the format of controls
  • Use formulas to perform calculations
  • Use a control to modify the property of other controls
  • Conditional formatting
  • Functions for validating data
Lesson 24: Use imperative development techniques for canvas apps in Power Apps
  • Imperative versus declarative development
  • The three types of variables in Power Apps
  • Global variables
  • Contextual variables
  • Collections
  • Additional variable concepts
  • Exercise – Using the variables and collections
Lesson 25: Manage apps in Power Apps
  • Exercise – Manage app versions in Power Apps
  • Exercise – Share apps in Power Apps
  • Exercise – Understand environments in Power Apps
  • Power Apps review
Lesson 26: Use basic formulas to make better Power Apps canvas apps
  • Formulas overview
  • Use a formula to modify the format of controls
  • Use formulas to perform calculations
  • Use a control to modify the property of other controls
  • Conditional formatting
  • Functions for validating data
Lesson 27: Build a canvas app for a real estate solution with Copilot in Power Apps
  • Exercise – Create a canvas app with Copilot in Power Apps
Lesson 28: Automate a business process using Power Automate
  • Introducing Power Automate
  • Create your first flow
  • Exercise – Create recurring flow
  • Exercise – Monitor incoming emails
  • Exercise – Share flows
  • Troubleshoot flows
Lesson 29: Optimize your business process with process advisor
  • Get familiar with process advisor
  • Create your first recording
  • Edit recordings and group actions
  • Analyze recordings and interpret results
  • Automation recommendations
Lesson 30: Build flows for a real estate solution using Copilot in Power Automate
  • Exercise – Create an approval flow with Copilot in Power Automate
  • When to use Copilot in Power Automate
Lesson 31: Use Dataverse triggers and actions in Power Automate
  • Dataverse triggers
  • Query data
  • Create, update, delete, and relate actions
  • Exercise – Create a cloud flow with a Dataverse connector
Lesson 32: Validate your app maker skills
  • Introduction to Microsoft Dataverse
  • Table characteristics
  • Exercise – Create a Microsoft Dataverse table
  • Exercise – Import data into your Microsoft Dataverse database
  • Table relationships
  • Exercise – Create table relationships
  • Dataverse logic and security
  • Exercise – Create a custom table and import data
  • Dataverse auditing
  • Dual-write vs. virtual tables

Course Fee (inclusive of 9% GST)

$3052.00 *Funding not available
Course Prerequisite
  • Basic data modelling, user experience design, requirements analysis, and process analysis skills.
  • A personal growth mindset and are comfortable using technology to solve business problems.
  • An understanding of the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.
Important Notes
All Trainees must take note of the following:
  1. Must attend at least 75% of the course before being eligible to take the assessments.
  2. Dynamic QR Code Attendance Taking: a. Scan the QR Code that will be displayed by the Trainer on each session. Use your SingPass App to scan and submit your attendance. If you fail to do so, you will be deemed absent from that session. b. The QR Code is only accessible on: • Morning Session: between 9.00 am to 1.00 pm. • Afternoon Session: between 2.00 pm to 6.00 pm. c. Please take the attendance one at a time as the system can only register you one by one.
  3. Sign daily on the Attendance Sheet as a backup if any technical glitch happens.
  4. Submit Course Evaluation by the end of each module to help us improve the course and your future learning experience with us.
The course completion requirements for this course as follow:
  1. Attended at least 75% of the course.
  2. Declared as competent during the assessments.
Who Should Attend?
The App Maker builds solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain. They have basic data modeling, user experience design, requirements analysis, and process analysis skills. The App Maker creates and enforces business processes, structures digital collection of information, improves efficiency of repeatable tasks, and automates business processes. The App Maker uses the Maker tools of Power Platform to solve business problems. They may use advanced features of Microsoft apps and third-party productivity tools. The App Maker is aware of the capabilities and limitations of available tools and understands how to apply them. The App Maker is self-directed, and solution focused. They may not have formal IT training but are comfortable using technology to solve business problems with a personal growth dset. They understand the operational need and have a vision of the desired outcome. They approach problems with phased and iterative strategies.

Why ITEL?

  • Diverse Range of IT Courses

    We offer a diverse range of IT courses tailored to student needs. Our curriculum covers foundational to advanced topics, ensuring comprehensive learning. We stay updated with industry trends to deliver relevant courses.

  • Skilled & Experienced Instructors

    We are proud to have a team of highly skilled and experienced instructors. Our instructors are industry professionals with in-depth knowledge and expertise across various IT domains.

  • Practical & Hands-on Exercises

    Our courses feature hands-on exercises, projects, and simulations to build practical skills. Students gain confidence by applying knowledge to real-world scenarios.

ITELLogoBW


ITEL Learning Systems (S) Pte Ltd.
UEN/CPE Registration No.: 200106514H
Validity Period: 24 Apr 2024 to 23 Apr 2026

Menu

COURSES

Contact

Address: 1 Maritime Square, HarbourFront Centre #10-24/25 (Lobby B) Singapore 099253

How to Get to ITEL?

Phone: 6822 8282

Email: enquiry@itel.com.sg

Facebook Youtube Linkedin Instagram X-twitter
Copyright 2024 ITEL Learning Systems (S) Pte Ltd
Privacy Policy
Course Enquiry for PL-100 Microsoft Power Platform App Maker

"*" indicates required fields

I want to find out more about:
Consent*
Newsletter Subscription
This field is for validation purposes and should be left unchanged.