PL-100: Microsoft Power Platform Apps Maker from Udemy

This course covers the content required for the PL-100 certification exam, current as per the PL-100 exam update of 19 January 2024.

What do people like you say about this course?

James says: "Another awesome course from Philip. This course goes though all the major topics on the PL-100 exam in great detail and step-by-step, I followed along on my own trial tenant which I highly recommend. Take your time and go through it all. "

Will says: "This whole series has been fantastic; the best I have seen on this topic. "

Nikhil says: "Awesome course for PL100 Exam preparation. Updated: After completing the course I got the confidence to go ahead and attempt the exam. I m proud to announce that I passed on first attempt."

Stephen says: "I didn't even know what I didn't know until I took your course. You dragged me through topics I never knew I needed. The exposure helped me to guess correctly on the test (the second time). Your course was the most thorough coverage I could have received. Your coverage was so extensive, that I have to go back and review segments. It says 16 hoursbut I'm sure I spend over 120 hours on the material. Part of the time I tried to duplicate your magic. Again, Thanks 6 stars."

This course teaches the requirements for the Microsoft Certificate PL-100 "Power Platform App Maker Associate", and focuses on the various apps which make up the Power Platform, together with how they can be used by other programs, apps and services.

We'll start off by looking at canvas Power Apps. We'll get a free Developer edition and/or free trial of Power Apps, and get some sample data using the Dataverse (previously known as the Common Data Service). We'll then create a canvas Power App through a template and then, starting from scratch, we will replicate it and expand the functionality. This also includes creating a new table in the Dataverse. We will also look at Global and Context variables, components and collections.

We'll then look at model-driven Power Apps using the Dataverse. We'll look at the constituent parts of a model-driven Power Apps: site maps, forms, views, charts and dashboards. We'll also restrict the type of data which can be inserted into our Dataverse by using business rules.

Next up is Power Automate. Using our free Developer edition or the paid-for version, we'll create several automated flows, and the different triggers and actions you can use. We'll look at various triggers and actions, together with looking how we can enter data in sections using the business process flows.

We'll then go back to the Power Platform more generally, looking at solutions, security, and importing and exporting data.

We'll start off with looking at Power BI. If you have a PC, we'll look at the Power BI Service (available through any modern web browser), creating reports and dashboards, and sharing dashboards. We'll also look at adding existing Power BI tiles or dashboards into our model-driven and canvas Power Apps.

We will have a brief look at the AI Builder, and models such as the business card reader, object detection model, form processing model and prediction model. We'll then look at practical examples of using models inside Power Apps and Power Automate, and finish with some other topics.

No prior knowledge is required - we'll even see how to get a free Power Platform trial.

There are regular quizzes to help you remember the information, so you can be sure that you are learning.

Once you have completed this course, you will have a good knowledge of how to make Power Apps and Power Automate flows, together with how to use them in Microsoft Teams. And with some practice, you could even go for the official Microsoft certification PL-100 - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.

So, without any further ado, let's have a look at how you can use Udemy interface, and then we'll have a look at the objectives for the exam and therefore the syllabus for this course.

What's inside

Learning objectives

Create canvas and model-driven apps
Create power automate flows
Configure and manage microsoft dataverse

Create and consume microsoft power bi dashboards
Describe ai builder models

Create canvas and model-driven apps
Create power automate flows
Configure and manage microsoft dataverse
Create and consume microsoft power bi dashboards
Describe ai builder models

Syllabus

Introduction

Welcome to Udemy

How to get the best out of your Udemy course

Do you want auto-translated subtitles in more languages?

Curriculum

Resources

Introduction to the Power Platform

Installing Power Apps and Environments

Licensing for Power Apps

Power Automate using the Power Apps Developer plan

https://docs.microsoft.com/en-us/powerapps/maker/dev-community-plan

Signing up for Power Apps Developer Plan

Getting a free work email address for India

Why do I need a Work email address? And how can I get one, if I don't have it?

7. Different types of environments, and creation options

Create a Dataverse database, and sample data

Creating a canvas app from a template, and creating one from scratch

43, 44. Creating a canvas app using a template; start to build the app

Saving my Power App

36, 43, 44. Connect to data sources in canvas apps

41, 43. Build canvas apps screens - Inserting a Gallery

44. Formatting the label component

Practice Activity Number 1

Practice Activity Number 1 - The Solution

Creating canvas apps

Expanding our canvas app

43. Inserting a new screen and a card component

45. Using formulas in non-English locales

45. Using the Navigate and Back functions in the OnSelect event

43, 45. Building an edit screen

41. Adding rectangles and Adding New Items

Sorting and refreshing our gallery, and Deleting Items

Practice Activity Number 2

Practice Activity Number 2 - The Solution

Creating a basic canvas app

Designing data model

10. Create a high-level design

10. Design data models

10. Create Dataverse tables based on a data model

10. Adding columns to our Dataverse table

10. Updating our Primary Name Column, and Keys

11. Link entities by using Dataverse entity relationships

10. Adding Calculated Columns

10. Adding Rollup Columns

Practice Activity Number 3

Practice Activity Number 3 - The Solution

Other ways to create tables, and importing and exporting data

15. Create tables and table columns by using Copilot in Dataverse

16. Import data into a new table by using Microsoft Excel

16. Import data into an existing table by using Microsoft Excel

16. Edit and export data by using Microsoft Excel

Adding Expenses to our app

41. Adding Expenses screens into our Accounts apps

Practice Activity Number 4

Practice Activity Number 4 - The Solution

45. The Filter function - linking the Expenses and Accounts screens together

44. Default and DefaultSelectedItems

This time let's the quiz before the Practice Activity. The questions will help you with the Practice Activity.

Practice Activity Number 5

Practice Activity Number 5 - The Solution

Expanding our canvas app further, including using variables

41. Add Pictures and Image controls

46. Global variables - seeing one account's expenses, or all expenses

46. Context variables - adding a Sort icon

45. The Search function - Searching for text

Practice Activity Number 6

Practice Activity Number 6 - The Solution

Variables

Canvas Apps components

Creating a basic calculator

41. Converting the calculator to a component

41. Communicating with the component

41. Exporting and Importing components

Practice Activity Number 7

Practice Activity Number 7 - The Solution

Other controls and other canvas apps topics

41, 43. Adding other media assets to screens

43. Other controls

45. Other formulas

37. Design choices and app performance, and App Checker results

38, 39. Create+publish new versions, restore a previous version of an app

42. Describe modern controls and themes

43. Containers

6. Using Microsoft Copilot when editing canvas Power Apps

Collections

46. The Collect function - Adding records to a collection

46. The Clear and ClearCollect functions

46. The SaveData and LoadData functions

4. Describe standard, premium, custom connectors; Configure a connection

Practice Activity Number 8

Practice Activity Number 8 - The Solution

Create model-driven apps - App designer and main forms

30. Create model-driven apps

31. Create Dataverse table forms

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Develops marketable skills for the professional services market

Taught by Phillip Burton and I Do Data Limited, who are respected in the field

Covers skills, knowledge, and tools that are core to the Microsoft certification PL-100

Provides a strong foundation for model-driven app development by including use of the Dataverse and Power Automate

Examines Power BI and AI Builder to give learners exposure to additional valuable tools

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in PL-100: Microsoft Power Platform Apps Maker with these activities:

Organize and review course materials

Show steps

Enhance understanding and retention by整理和审阅课程材料

Show steps

Gather and整理 notes, assignments, and other course materials.
Review the materials regularly.

Review data modeling concepts

Show steps

Reinforce foundational data modeling knowledge to better prepare for the course.

Browse courses on Data Models

Show steps

Review notes or textbooks on data modeling.
Practice creating data models for sample scenarios.

Follow online tutorials on Power Platform topics

Show steps

Expand knowledge and gain additional perspectives by exploring expert-led tutorials.

Show steps

Search for and select relevant tutorials.
Follow the instructions and guidance provided in the tutorial.

Six other activities

Expand to see all activities and additional details

Show all nine activities

Complete Power Apps and Power Automate practice exercises

Show steps

Strengthen foundational skills and gain fluency in Power Apps and Power Automate.

Show steps

Access online or offline practice exercises.
Follow instructions to complete the exercises.

Build a simple Power App

Show steps

Apply course concepts to a practical project, enhancing understanding and retention.

Show steps

Identify a problem or task that can be solved with a Power App.
Design the app's interface and functionality.
Create the app using Power Apps.
Test and refine the app.

Attend Power Platform community meetups or conferences

Show steps

Connect with other professionals, learn about industry trends, and expand understanding beyond the course.

Show steps

Search for and register for relevant meetups or conferences.
Attend the event and engage with other attendees.
Follow up with new connections.

Create a blog post or article on a Power Platform topic

Show steps

Solidify knowledge and improve understanding by explaining concepts to others.

Show steps

Choose a specific aspect of the Power Platform to focus on.
Research and gather information from reliable sources.
Write and edit the blog post or article, explaining the topic clearly and concisely.

Contribute to open-source Power Platform projects

Show steps

Gain practical experience, contribute to the community, and deepen knowledge by collaborating on real-world projects.

Show steps

Identify open-source Power Platform projects.
Reach out to the project maintainers and express interest in contributing.
Work with the team to contribute code, documentation, or other support.

Develop a Power Automate flow to automate a business process

Show steps

Enhance practical skills and demonstrate proficiency in Power Automate by creating a real-world solution.

Show steps

Identify a repetitive or manual business process.
Design the flow using the Power Automate interface.
Set up triggers, actions, and conditions within the flow.
Test and refine the flow to ensure it functions as intended.

Career center

Learners who complete PL-100: Microsoft Power Platform Apps Maker will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts make sense of raw data. They help organizations understand the data they collect, which can lead to better products, services, and decision-making. This course may be useful for a Data Analyst because it teaches how to use Power BI to create reports and dashboards, which are essential tools for data analysis. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Data Analysts to focus on more complex tasks.

See salaries and explore the career path for Data Analyst

Data Engineer

Data Engineers design, build, and maintain the systems that store and process data. They are responsible for ensuring that data is available, reliable, and secure. This course may be useful for a Data Engineer because it teaches how to use the Power Platform to create apps that can access and process data. Additionally, the course covers how to use Power BI to create reports and dashboards, which can help Data Engineers to visualize and analyze data.

See salaries and explore the career path for Data Engineer

Business Analyst

Business Analysts help organizations improve their performance by identifying and solving problems. They use data analysis, modeling, and other techniques to understand the needs of the business and recommend solutions. This course may be useful for a Business Analyst because it teaches how to use the Power Platform to create apps that can automate processes and improve efficiency. Additionally, the course covers how to use Power BI to create reports and dashboards, which can help Business Analysts to visualize and analyze data.

See salaries and explore the career path for Business Analyst

Software Engineer

Software Engineers design, develop, and maintain software applications. They use a variety of programming languages and tools to create software that meets the needs of users. This course may be useful for a Software Engineer because it teaches how to use the Power Platform to create apps that can automate processes and improve efficiency. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Software Engineers to focus on more complex tasks.

See salaries and explore the career path for Software Engineer

Project Manager

Project Managers plan, execute, and close projects. They are responsible for ensuring that projects are completed on time, within budget, and to the required quality. This course may be useful for a Project Manager because it teaches how to use the Power Platform to create apps that can track progress, manage resources, and communicate with stakeholders. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Project Managers to focus on more complex tasks.

See salaries and explore the career path for Project Manager

IT Manager

IT Managers plan, implement, and manage the IT systems of an organization. They are responsible for ensuring that IT systems are reliable, secure, and meet the needs of the business. This course may be useful for an IT Manager because it teaches how to use the Power Platform to create apps that can automate processes and improve efficiency. Additionally, the course covers how to use Power BI to create reports and dashboards, which can help IT Managers to visualize and analyze data.

See salaries and explore the career path for IT Manager

BI Developer

BI Developers design, develop, and maintain business intelligence (BI) systems. They use a variety of tools and technologies to create BI solutions that help organizations make better decisions. This course may be useful for a BI Developer because it teaches how to use the Power Platform to create BI apps. Additionally, the course covers how to use Power BI to create reports and dashboards, which are essential tools for BI Developers.

See salaries and explore the career path for BI Developer

Data Scientist

Data Scientists use data analysis, modeling, and machine learning to solve business problems. They work with a variety of data sources to extract insights and make predictions. This course may be useful for a Data Scientist because it teaches how to use the Power Platform to create apps that can access and process data. Additionally, the course covers how to use Power BI to create reports and dashboards, which can help Data Scientists to visualize and analyze data.

See salaries and explore the career path for Data Scientist

UX Designer

UX Designers design the user experience for websites, apps, and other digital products. They focus on making products that are easy to use, aesthetically pleasing, and engaging. This course may be useful for a UX Designer because it teaches how to use the Power Platform to create apps. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up UX Designers to focus on more complex tasks.

See salaries and explore the career path for UX Designer

Web Developer

Web Developers design, develop, and maintain websites. They use a variety of programming languages and tools to create websites that meet the needs of users. This course may be useful for a Web Developer because it teaches how to use the Power Platform to create apps. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Web Developers to focus on more complex tasks.

See salaries and explore the career path for Web Developer

Mobile Developer

Mobile Developers design, develop, and maintain mobile apps. They use a variety of programming languages and tools to create apps that meet the needs of users. This course may be useful for a Mobile Developer because it teaches how to use the Power Platform to create apps. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Mobile Developers to focus on more complex tasks.

See salaries and explore the career path for Mobile Developer

Database Administrator

Database Administrators design, implement, and maintain databases. They are responsible for ensuring that databases are reliable, secure, and meet the needs of the business. This course may be useful for a Database Administrator because it teaches how to use the Power Platform to create apps that can access and process data.

See salaries and explore the career path for Database Administrator

Cloud Engineer

Cloud Engineers design, build, and maintain cloud computing systems. They are responsible for ensuring that cloud systems are reliable, secure, and meet the needs of the business. This course may be useful for a Cloud Engineer because it teaches how to use the Power Platform to create apps that can access and process data in the cloud.

See salaries and explore the career path for Cloud Engineer

Network Administrator

Network Administrators design, implement, and maintain computer networks. They are responsible for ensuring that networks are reliable, secure, and meet the needs of the business. This course may be useful for a Network Administrator because it teaches how to use the Power Platform to create apps that can monitor and manage networks. Additionally, the course covers how to use Power Automate to create automated workflows, which can free up Network Administrators to focus on more complex tasks.

See salaries and explore the career path for Network Administrator

System Administrator

System Administrators design, implement, and maintain computer systems. They are responsible for ensuring that systems are reliable, secure, and meet the needs of the business. This course may be useful for a System Administrator because it teaches how to use the Power Platform to create apps that can automate processes and improve efficiency. Additionally, the course covers how to use Power BI to create reports and dashboards, which can help System Administrators to visualize and analyze data.

See salaries and explore the career path for System Administrator