PL-200:Microsoft Power Platform Functional Consultant Part 1

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Welcome to Udemy

Lecture 3: How to get the best out of your Udemy course

Lecture 4: Do you want auto-translated subtitles in more languages?

Lecture 5: Curriculum

Lecture 6: Resources

Lecture 7: Introduction to the Power Platform

Chapter 2: Installing Power Apps and Environments

Lecture 1: Licensing for Power Apps

Lecture 2: Power Automate using the Power Apps Developer plan

Lecture 3: Signing up for Power Apps per user plan

Lecture 4: Signing up for Power Apps Developer Plan

Lecture 5: Getting a free work email address for India

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

Lecture 7: 7. Different types of environments, and creation options

Lecture 8: Create a Dataverse database, and sample data

Chapter 3: Creating a canvas app from a template, and creating one from scratch

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

Lecture 2: Saving my Power App

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

Lecture 4: 41, 43. Build canvas apps screens – Inserting a Gallery

Lecture 5: 44. Formatting the label component

Lecture 6: Practice Activity Number 1

Lecture 7: Practice Activity Number 1 – The Solution

Chapter 4: Expanding our canvas app

Lecture 1: 43. Inserting a new screen and a card component

Lecture 2: 45. Using formulas in non-English locales

Lecture 3: 45. Using the Navigate and Back functions in the OnSelect event

Lecture 4: 43, 45. Building an edit screen

Lecture 5: 41. Adding rectangles and Adding New Items

Lecture 6: Sorting and refreshing our gallery, and Deleting Items

Lecture 7: Practice Activity Number 2

Lecture 8: Practice Activity Number 2 – The Solution

Chapter 5: Designing data model

Lecture 1: 10. Create a high-level design

Lecture 2: 10. Design data models

Lecture 3: 10. Create Dataverse tables based on a data model

Lecture 4: 10. Adding columns to our Dataverse table

Lecture 5: 10. Updating our Primary Name Column, and Keys

Lecture 6: 11. Link entities by using Dataverse entity relationships

Lecture 7: 10. Adding Calculated Columns

Lecture 8: 10. Adding Rollup Columns

Lecture 9: Practice Activity Number 3

Lecture 10: Practice Activity Number 3 – The Solution

Chapter 6: Other ways to create tables, and importing and exporting data

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

Lecture 2: If you have problems importing data

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

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

Lecture 5: 16. Edit and export data by using Microsoft Excel

Chapter 7: Adding Expenses to our app

Lecture 1: 41. Adding Expenses screens into our Accounts apps

Lecture 2: Practice Activity Number 4

Lecture 3: Practice Activity Number 4 – The Solution

Lecture 4: 45. The Filter function – linking the Expenses and Accounts screens together

Lecture 5: 44. Default and DefaultSelectedItems

Lecture 6: Practice Activity Number 5

Lecture 7: Practice Activity Number 5 – The Solution

Chapter 8: Expanding our canvas app further, including using variables

Lecture 1: 41. Add Pictures and Image controls

Lecture 2: 46. Global variables – seeing one account's expenses, or all expenses

Lecture 3: 46. Context variables – adding a Sort icon

Lecture 4: 45. The Search function – Searching for text

Lecture 5: Practice Activity Number 6

Lecture 6: Practice Activity Number 6 – The Solution

Chapter 9: Canvas Apps components

Lecture 1: Creating a basic calculator

Lecture 2: 41. Converting the calculator to a component

Lecture 3: 41. Communicating with the component

Lecture 4: 41. Exporting and Importing components

Lecture 5: Practice Activity Number 7

Lecture 6: Practice Activity Number 7 – The Solution

Chapter 10: Other controls and other canvas apps topics

Lecture 1: 41, 43. Adding other media assets to screens

Lecture 2: 43. Other controls

Lecture 3: 45. Other formulas

Lecture 4: 37. Design choices and app performance, and App Checker results

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

Lecture 6: 42. Describe modern controls and themes

Lecture 7: 43. Containers

Lecture 8: 6. Using Microsoft Copilot when editing canvas Power Apps

Chapter 11: Collections

Lecture 1: 46. The Collect function – Adding records to a collection

Lecture 2: 46. The Clear and ClearCollect functions

Lecture 3: 46. The SaveData and LoadData functions

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

Lecture 5: Practice Activity Number 8

Lecture 6: Practice Activity Number 8 – The Solution

Chapter 12: Create model-driven apps – App designer and main forms

Lecture 1: 30. Create model-driven apps