Microsoft Power Platform Developer PL400 - Canada

Microsoft Power Platform Developer PL400 Course Outline

Module 1: 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

Module 2: Get Started with Model-Driven Apps in Power Apps

• Introducing Model-Driven Apps
• Components of Model-Driven Apps
• Design Model-Driven Apps
• Exercise - Control Security When Sharing Model-Driven Apps
• Exercise - Create a Model-Driven App

Module 3: Manage Tables in Dataverse

• Identify Tables and Table Types in Dataverse
• Create a Custom Table
• Enable Attachments Within a Table
• Licensing Requirements for Each Table Type
• Lab - Create a New Custom Table and Enable Attachments

Module 4: 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
• Create a Primary Name Column
• Restrictions That Apply to Columns in a Table
• Create an Auto Numbering Column
• Create an Alternate Key
• Exercises

Module 5: Working with Choices in Dataverse

• Define Choice Column
• Standard Choices Column
• Lab - Create a New Choice or Modify an Existing Choice

Module 6: Create a Relationship Between Tables in Dataverse

• Relate One or More Tables - Introduction
• Relationship Types That Are Available in Microsoft Dataverse
• Create a One-to-Many Relationship Between Tables
• Create a Many-to-Many Relationship Between Tables
• Edit or Delete Relationships
• Exercise - Create Two Tables and Relate Them by Using a One-to-Many Relationship

Module 7: Define and Create Business Rules in Dataverse

• Define Business Rules - Introduction
• Define the Components of a Business Rule
• Create a Business Rule
• Exercise - Create a Business Rule

Module 8: Create and Define Calculation or Rollup Columns in Dataverse

• Introduction to Rollup Columns
• Create a Rollup Column
• Introduction to Calculation Columns
• Create a Calculation Column
• Exercise - Create a Rollup Column
• Exercise - Create a Calculation Column

Module 9: Get Started with Security Roles in Dataverse

• Introduction to Environment Roles
• Understand Environment Roles
• Adding or Disabling an Environment User
• Understand Security Concepts in Dataverse
• Understand User Security Roles and Security Role Defaults
• Exercise - Create a Custom Role
• Check the Roles That a User Belongs To
• Configure Dataverse Teams for Security
• Configure Dataverse Group Teams for Security

Module 10: Get Started with Power Apps Canvas Apps

• Introduction to Power Apps
• Power Apps Building Blocks
• Exercise - Create Your First App in Power Apps
• Ways to Build Power Apps
• Power Apps Related Technologies
• Additional Power Apps Related Technologies
• Designing a Power Apps App

Module 11: Customise a Canvas App in Power Apps

• Improve Apps by Making Basic Customisations in Power Apps
• Create a Navigation Model for Your Canvas App
• Explore Screens and Controls in Power Apps
• Exercise - Get Started with Functions in Power Apps

Module 12: 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

Module 13: Navigation in a Canvas App in Power Apps

• Understanding Navigation
• Navigation and Back Function
• Lab - Create Navigation Functions
• More Ways to Use the Navigation Function

Module 14: How to Build the UI in a Canvas App in Power Apps

• Use Themes to Quickly Change the Appearance of Your App
• Branding a Control
• Icons
• Images
• Personalisation
• Using the Tablet or Phone Form Factors
• Exercise - Create UI for a New Canvas App

Module 15: 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
• Lab - Create a Canvas App with Unique Controls

Module 16: Document and Test Your Power Apps Application

• Create Test Plans
• User Interface Testing
• Performance Optimisation
• Diagnostics and Analytics
• Documentation and the Customer

Module 17: Use Imperative Development Techniques for Canvas Apps in Power Apps

• Imperative Versus Declarative Development
• Three Types of Variables in Power Apps
• Global Variables
• Contextual Variables
• Collections
• Additional Variable Concepts
• Exercise - Using the Variables and Collections

Module 18: Create Formulas That Use Tables, Records, and Collections in a Canvas App in Power Apps

• Formulas That Process Multiple Records
• Math Operations on Tables
• Combine and Separate Records
• ForAll Function
• Lab - Using the ForAll Function in a Gallery

Module 19: Perform Custom Updates in a Power Apps Canvas App

• Sometimes You Need Something More Than Forms
• Using the Patch Function to Create and Edit Records
• Deleting Record(s) from Data Sources and Collections
• Using Patch Function to Update a Gallery

Module 20: Complete Testing and Performance Checks in a Power Apps Canvas App

• Importance of Thinking About Performance
• Improve Performance with Data Sources
• Testing and Troubleshooting Your App
• Exercise - Using the Concurrent Function to Test Performance

Module 21: Work with Relational Data in a Power Apps Canvas App

• What is Relational Data?
• Work with Relationships in Power Apps
• Exercise - Work with Relational Data
• Microsoft Dataverse for Apps Makes Relationships Even Easier

Module 22: Work with Data Source Limits (Delegation Limits) in a Power Apps Canvas App

• Delegation Overview
• Functions, Predicates, and Data Sources Combine to Determine Delegation
• Delegation Warnings, Limits, and Non-Delegable Functions

Module 23: Connect to Other Data in a Power Apps Canvas App

• Overview of Different Data Sources
• Work with Action-Based Data Sources
• Power Automate Is a Companion to Power Apps

Module 24: Use Custom Connectors in a Power Apps Canvas App

• Overview of Custom Connectors
• Overview of the Custom Connector Lifecycle
• Use Postman for Your Custom Connector

Module 25: Get Started with Power Automate

• Introducing Power Automate
• Exercise - Create Your First Flow
• Exercise - Create Recurring Flows
• Exercise - Monitor Incoming Emails
• Exercise - Share Flows
• Troubleshoot Flows

Module 26: Build Approval Flows with Power Automate

• Provide Solutions to Real-World Scenarios
• Exercise - Build an Approval Request
• Exercise - Build a Flow That Processes an Approval Request
• Exercise - Learn to Build a Flow That Runs at Recurring Time Intervals
• Exercise - Create a Business Process Flow
• Exercise - Create a Business Process Flow That Has Conditions

Module 27: Introduction to Expressions in Power Automate

• Introduction to Expressions
• Get Started with Expressions
• Notes Make Things Easier
• Types of Functions
• Write Complex Expressions
• Exercise - Creating a Manual Flow and Using Expressions

Module 28: Introduction to Microsoft Power Platform Developer Resources

• Introduction to Microsoft Power Platform for Developers
• Overview of Microsoft Dataverse and the Common Data Model
• Extending Power Platform with Azure

Module 29: Use Developer Tools to Extend Microsoft Power Platform

• Introduction to Developer Microsoft Power Platform Tooling
• Exercise - Install and Use Developer Tools
• Solutions Overview
• Deploy Apps with Package Deployer
• Exercise - Use the Power Apps CLI

Module 30: Introduction to Extending Microsoft Power Platform

• Introduction
• User Experience Extensibility
• Microsoft Dataverse Extensibility
• Exercise - Create a Custom API
• Determine When to Configure or When to Code

Module 31: Introduction to Dataverse for Developers

• Introduction to Developing with Microsoft Dataverse
• Microsoft Dataverse Extensibility Model
• Event Framework

Module 32: Extend Plug-ins

• Introduction to Plug-ins
• Plug-ins Usage Scenarios
• Custom Workflow Extensions
• Plug-in Execution Context
• Exercise - Write Your First Plug-in
• Exercise - Write a Custom Workflow Extension

Module 33: Performing Common Actions with Client Script

• Introduction to Client-Side Scripting
• Upload Scripts
• Event Handlers
• Context Objects
• Client Scripting Common Tasks
• Exercise - Use Client Script to Hide a Form Section

Module 34: Automate Business Process Flows with Client Script

• Conducting Global Operations with the Client API Xrm Object
• Client Scripting Best Practices
• Debugging Client Script
• Exercise - Use Table Data from Client Script

Module 35: Get Started with Power Apps Component Framework

• Introduction to Power Apps Component Framework
• Power Apps Component Framework Architecture
• Power Apps Component Tooling
• Demo of Power Apps Code Component

Module 36: Build a Power Apps Component

• Introduction to Creating a Code Component
• Create a Code Component Solution Package
• Test and Debug Code Components

Module 37: Use Advanced Features with Power Apps Component Framework

• Introduction to Using React Within a Power Apps Component
• Use the Formatting API in a Power Apps Component
• Use the Microsoft Dataverse Web API in a Power Apps Component
• Write a Pop-Up Power Apps Component

Module 38: Work with Dataverse Web API

• Introduction to the Microsoft Dataverse Web API
• Authenticate Against Microsoft Dataverse by Using OAuth
• Interact with Microsoft Dataverse Web API by Using Postman
• Use OData to Query Data
• Use FetchXML to Query Data
• Call Power Automate Actions from the Web API
• Use the Web API to Impersonate Another User
• Track Entity Data Changes with Change Tracking and the Web API

Module 39: Integrate Dataverse Azure Solutions

• Microsoft Dataverse Azure Solutions Overview
• Expose Microsoft Dataverse Data to Azure Service Bus
• Write a Service Bus Event Listener That Consumes Microsoft Dataverse Messages
• Publish Microsoft Dataverse Events with Webhooks
• Write an Azure Function That Processes Microsoft Dataverse Events