Skip to main content
PL-200T00: Microsoft Power Platform Functional Consultant
0%
Previous
Course data
Lesson 1: Get started using Dataverse
1.1.1 Environments in Microsoft Dataverse
1.1.2 Developer environments
1.1.3 Create and manage an environment
1.1.4 Create an instance of a Microsoft Dataverse database
1.1.5 Add users and roles within an environment
1.1.6 Manage settings in an environment
1.1.7 Environment operations
1.1.8 Summary
1.2.1 Introduction to Microsoft Dataverse
1.2.2 Table characteristics
1.2.3 Exercise - Create a Microsoft Dataverse table
1.2.4 Exercise - Import data into your Microsoft Dataverse database
1.2.5 Table relationships
1.2.6 Exercise - Create table relationships
1.2.7 Dataverse logic and security
1.2.8 Exercise - Create a custom table and import data
1.2.9 Dataverse auditing
1.2.10 Dual-write vs. virtual tables
1.2.11 Summary
1.3.1 Identify tables and table types in Dataverse
1.3.2 Create a custom table
1.3.3 Enable attachments within a table
1.3.4 Licensing requirements for each table type
1.3.5 Exercise - Create a new custom table and enable attachments
1.3.6 Summary
1.4.1 Define columns in Microsoft Dataverse
1.4.2 Column types in Microsoft Dataverse
1.4.3 Add a column to a table
1.4.4 Primary column
1.4.5 Restrictions that apply to columns in a table
1.4.6 Create an auto numbering column
1.4.7 Create an alternate key
1.4.8 Exercises
1.4.9 Summary
1.5.1 Define choice column
1.5.2 Choice columns
1.5.3 Standard choices column
1.5.4 Exercise - Create a new choice or modify an existing choice
1.5.5 Summary
1.6.1 View data in a table
1.6.2 Create or edit views of data in a table
1.6.3 Dataverse data import options
1.6.4 Load data into a table
1.6.5 Dataverse data export options
1.6.6 Export
1.6.7 Add, update, or delete data in a table by using Excel
1.6.8 Import data using Power Query
1.6.9 Summary
1.7.1 Overview of the different data sources
1.7.2 Work with action data
1.7.3 Power Automate is a companion to Power Apps
1.7.4 Summary
Lesson 2:Manage permissions and administration for Dataverse
2.1.1 Introduction
2.1.2 Role-based security
2.1.3 Business units
2.1.4 Hierarchy security
2.1.5 Table/record ownership
2.1.6 Column-level security to control access
2.1.7 Manage security across multiple environments
2.1.8 Summary
2.2.1 Introduction to environment roles
2.2.2 Understand environment roles
2.2.3 Adding or disabling an environment user
2.2.4 Understand user security roles and security role defaults
2.2.5 Exercise - Create a custom role
2.2.6 Check the roles that a user belongs to
2.2.7 Configure Dataverse teams for security
2.2.8 Configure Dataverse group teams for security
2.2.9 Summary
2.3.1 Introduction to Microsoft Power Platform Admin Center portal
2.3.2 Use Microsoft Power Platform Admin Center portal
2.3.3 Tenant storage capacity
2.3.4 Advanced Customization options in Power Apps Portal
2.3.5 Dataverse Search
2.3.6 Auditing
2.3.7 Duplicate detection
2.3.8 Bulk delete
2.3.9 Long term data retention
2.3.10 Summary
Lesson 3:Visualize, import, and export Microsoft Dataverse data
3.1.1 Introduction
3.1.2 Create and edit views in Power Apps maker portal
3.1.3 Exercise - Add columns to a view
3.1.4 Filter and sort data for Dataverse views
3.1.5 Exercise - List your accounts
3.1.6 Summary
3.2.1 Introduction
3.2.2 Import static data by using Power Query
3.2.3 Exercise – Add new accounts from a text file
3.2.4 Import dynamic data by using Power Query
3.2.5 Exercise – Transfer an attendee list to a contact table
3.2.6 Summary
3.3.1 Introduction
3.3.2 Create a dynamic Word template
3.3.3 Exercise – Create a work order template
3.3.4 Create a dynamic Excel template
3.3.5 Exercise – Create a sales forecasting template
3.3.6 Summary
3.4.1 Introduction
3.4.2 Export data to Excel
3.4.3 Exercise - Create an editable Excel file for bulk validation
3.4.4 Edit and update data in Excel
3.4.5 Exercise - Edit account information in Excel and visualize updates in Dataverse
3.4.6 Summary
3.5.1 Introduction
3.5.2 Use Dataverse community tools for data manipulation
3.5.3 Review Power BI integration with Dataverse
3.5.4 Summary
Lesson 4:Create relationships, business rules, calculations, and rollups in Dataverse
4.1.1 Relate one or more tables - Introduction
4.1.2 Relationship types that are available in Microsoft Dataverse
4.1.3 Create a one-to-many relationship between tables
4.1.4 Create a many-to-many relationship between tables
4.1.5 Edit or delete relationships
4.1.6 Exercise - Create two tables and relate them by using a one-to-many relationship
4.1.7 Summary
4.2.1 Define business rules - Introduction
4.2.2 Define the components of a business rule
4.2.3 Create a business rule
4.2.4 Exercise - Create a business rule
4.2.5 Summary
4.3.1 Introduction to roll up columns
4.3.2 Create a rollup column
4.3.3 Introduction to calculated columns
4.3.4 Create a calculation column
4.3.5 Exercise - Create a rollup column
4.3.6 Exercise - Create a calculated column
4.3.7 Introduction to Power Fx formula columns
4.3.8 Summary
Lesson 5: Advanced Model-Driven Apps with Power Apps: Configuration, Customization, and Deployment Techniques
5.1.1 Forms overview
5.1.2 Part 1 Form elements
5.1.2 Part 2 Form elements
5.1.3 Configure multiple forms
5.1.4 Use specialized form components
5.1.5 Configure views overview
5.1.6 Configure grids
5.1.7 Create and edit views
5.1.8 Configure charts overview
5.1.9 Use interactive streams and tiles
5.1.10 Summary
5.2.1 Introduction
5.2.2 Create business process flows
5.2.3 Exercise - Create a business process flow
5.2.4 Embed a canvas app in a model-driven form
5.2.5 Add a timeline in a model-driven form
5.2.6 Create a report in a model-driven form
5.2.7 Summary
5.3.1 Introduction
5.3.2 Power Platform reporting capabilities
5.3.3 Power BI overview
5.3.4 Data requirements
5.3.5 Power BI and Power Platform
5.3.6 Dataflows
5.3.7 AI
5.3.8 Summary
5.4.1 Introduction
5.4.2 Publish the app
5.4.3 Share the app
5.4.4 Use QR codes
5.4.5 Exercise - Embed your app into other Microsoft applications
5.4.6 Collect feedback and analyze telemetry
5.4.7 Summary
5.5.1 Introduction
5.5.2 Create or edit modern commands
5.5.3 Work with classic commands
5.5.4 Use Power Fx
5.5.5 Exercise - Customize the command bar
5.5.6 Summary
Lesson 6:Create a canvas app in Power Apps
6.1.1 Introduction to Power Apps
6.1.2 Start Power Apps
6.1.3 Part 1-Exercise - Create your first app in Power Apps
6.1.3 Part 2-Exercise - Create your first app in Power Apps
6.1.4 Power Apps data sources
6.1.5 Exercise - Create an app from Excel using Copilot
6.1.6 Use Power Apps with Power Automate and Power BI
6.1.7 Designing a Power Apps app
6.1.8 Summary
6.2.1 Improve your app by making basic customizations
6.2.2 Explore controls and screens in canvas apps
6.2.3 Exercise - Introduction to formulas in canvas apps
6.2.4 Exercise - Create basic screen navigation for a canvas app
6.2.5 Summary
6.3.1 Use themes to quickly change the appearance of your app
6.3.2 Brand a control
6.3.3 Icons
6.3.4 Images
6.3.5 Personalization
6.3.6 Build for phones or tablets
6.3.7 Exercise - Create and adjust UI for a new canvas app
6.3.8 Summary
6.4.1 Understanding navigation
6.4.2 The Navigate and Back functions
6.4.3 More ways to use the Navigate function
6.4.4 Exercise - App navigation practice
6.4.5 Summary
6.5.1 Introduction
6.5.2 Exercise - Manage app versions in Power Apps
6.5.3 Exercise - Share apps in Power Apps
6.5.4 Exercise - Understand environments in Power Apps
6.5.5 Review of managing Power Apps
6.5.6 Summary
6.6.1 Introduction
6.6.2 Learn about mobile-optimized apps
6.6.3 Identify components to make a canvas app mobile-optimized
6.6.4 Create a mobile-optimized app that uses responsive designs
6.6.5 Identify performance considerations for a mobile-optimized canvas app
6.6.6 Summary
Lesson 7:Use the UI and controls in a canvas app in Power Apps
7.1.1 Understanding navigation
7.1.2 The Navigate and Back functions
7.1.3 More ways to use the Navigate function
7.1.4 Exercise - App navigation practice
7.1.5 Summary
7.2.1 Use themes to quickly change the appearance of your app
7.2.2 Brand a control
7.2.3 Icons
7.2.4 Images
7.2.5 Personalization
7.2.6 Build for phones or tablets
7.2.7 Exercise - Create and adjust UI for a new canvas app
7.2.8 Summary
7.3.1 Introduction to controls
7.3.2 Core properties of controls
7.3.3 Entering and displaying data with text controls
7.3.4 Additional controls for enhancing your app's usability
7.3.5 Media
7.3.6 Modern controls
7.3.7 Work with component libraries
7.3.8 Exercise - Create a canvas app with unique controls
7.3.9 Exercise - Upload file to SharePoint document library
7.3.10 Summary
7.4.1 Create test plans
7.4.2 User interface testing
7.4.3 Performance optimization
7.4.4 Diagnostics and analytics
7.4.5 Documentation and the customer
7.4.6 Summary
Lesson 8:Use basic formulas to make better Power Apps canvas apps
8.1.1 Formulas overview
8.1.2 Use a formula to modify the format of controls
8.1.3 Use formulas to perform calculations
8.1.4 Use a control to modify the property of other controls
8.1.5 Conditional formatting
8.1.6 Functions for validating data
8.1.7 Summary
8.2.1 Formulas and functionality
8.2.2 Understanding true and false
8.2.3 Understanding control behaviors and actions
8.2.4 Performing multiple actions in a formula
8.2.5 Control the display mode through a formula
8.2.6 Use controls and functions to create a dynamic formula
8.2.7 Summary
8.3.1 Records and tables
8.3.2 Using the Table function
8.3.3 Store a table
8.3.4 Filter your table
8.3.5 Use the lookup function to return a record
8.3.6 Additional table functions
8.3.7 Exercise - Use collections and manipulate tables
8.3.8 Summary
Lesson 9:Advanced Canvas App Development in Power Apps: Mastering Formulas and Development Techniques
Podcast Lesson 9:Advanced Canvas App Development in Power Apps: Mastering Formulas and Development Techniques
9.1.1 Formulas that process multiple records
9.1.2 Math operations on tables
9.1.3 Combine and separate records
9.1.4 The ForAll function
9.1.5 Exercise- Using the ForAll function in a gallery
9.1.6 Summary
9.2.1 Imperative versus declarative development
9.2.2 The three types of variables in Power Apps
9.2.3 Global variables
9.2.4 Contextual variables
9.2.5 Collections
9.2.6 Additional variable concepts
9.2.7 Exercise - Using the variables and collections
9.2.8 Summary
Lesson 10:Work with Power Pages websites
Lesson 10:Work with Power Pages websites
10.1.1 Introduction to Power Pages design studio
10.1.2 Work with pages
10.1.3 Page components
10.1.4 Site styling and templates
10.1.5 Exercise - Edit pages
10.1.6 Summary
10.2.1 Introduction into Power Pages design studio data and security features
10.2.2 Data workspace in Power Pages design studio
10.2.3 Power Pages security features
10.2.4 Exercise - secure Dataverse data access
10.2.5 Summary
10.3.1 Introduction
10.3.2 Power Pages metadata
10.3.3 Webpages
10.3.4 Power Pages templates
10.3.5 Exercise - Build side navigation
10.3.6 Summary
10.4.1 Introduction to site templates in Power Pages
10.4.2 Site design templates
10.4.3 Scenario-based templates
10.4.4 Dynamics 365 Power Pages site templates
10.4.5 Summary
10.5.1 Introduction
10.5.2 Basic form configuration
10.5.3 Multistep form processes
10.5.4 Set up multistep forms
10.5.5 Extend lists and forms
10.5.6 Exercise - Extend forms with more actions
10.5.7 Summary
10.6.1 Introduction
10.6.2 Liquid basics
10.6.3 Access Dataverse data
10.6.4 Data security and Liquid
10.6.5 Summary
10.7.1 Introduction
10.7.2 Secure static content
10.7.3 Table permissions
10.7.4 Exercise - Apply table permissions
10.7.5 Summary
Lesson 11:Extend Power Pages
Lesson 11:Extend Power Pages
11.1.1 Introduction
11.1.2 Use lists to display multiple Dataverse records
11.1.3 Part 1 Use forms to interact with Dataverse data
11.1.3 Part 2 Use forms to interact with Dataverse data
11.1.4 Exercise - Use the list and form components
11.1.5 Summary
11.2.1 Introduction
11.2.2 Power Pages website life cycle management
11.2.3 Extend with scripts
11.2.4 Advanced CSS
11.2.5 Advanced client-side development
11.2.6 Exercise - Add advanced client-side functionality
11.2.7 Summary
Lesson 12: Administer Power Pages
Lesson 12: Administer Power Pages
12.1.1 Introduction
12.1.2 Power Pages administrative tools
12.1.3 Power Pages life cycle
12.1.4 Set up essential features of a Power Pages website
12.1.5 Summary
12.2.1 Introduction
12.2.2 Document management with SharePoint in Power Pages
12.2.3 Integration with Power BI in Power Pages
12.2.4 Model-driven charts in Power Pages
12.2.5 Summary
12.3.1 Introduction
12.3.2 Power Pages authentication settings
12.3.3 User registration in Power Pages
12.3.4 Authentication management for Power Pages users
12.3.5 Power Pages authentication providers
12.3.6 Exercise - Use an invitation to register users
12.3.7 Summary
12.4.1 Introduction
12.4.2 Power Pages website maintenance
12.4.3 Power Pages website troubleshooting
12.4.4 Exercise - Run the Portal Checker
12.4.5 Summary
Lesson 13:Work with Power Automate error handling and expressions
Podcast Lesson 13:Work with Power Automate error handling and expressions
13.1.1 Introduction
13.1.2 Configure run after option
13.1.3 Power Automate analytics
13.1.4 Summary
13.2.1 Introduction to expressions
13.2.2 Get started with expressions
13.2.3 Notes make things easier
13.2.4 Types of functions
13.2.5 Write complex expressions
13.2.6 Exercise - Creating a manual flow and using expressions
13.2.7 Summary
Lesson 14:Integrate Power Automate flows and Dataverse
Podcast Lesson 14:Integrate Power Automate flows and Dataverse
14.1.1 Introduction
14.1.2 Dataverse triggers
14.1.3 Query data
14.1.4 Create, update, delete, and relate actions
14.1.5 Exercise - Create a cloud flow with a Dataverse connector
14.1.6 Summary
14.2.1 Introduction
14.2.2 Work with files and images Part 1
14.2.2 Work with files and images Part 2
14.2.2 Work with files and images Part 2 (copy)
14.2.3 Perform operations Part 1
14.2.3 Perform operations Part 2
14.2.3 Perform operations Part 3
14.2.4 Search data
14.2.5 Changesets
14.2.6 Summary
Lesson 15:Power Platform Solution Management: Sharing, Customization, and Low-Code Development Essentials
Podcast Lesson 15:Power Platform Solution Management: Sharing, Customization, and Low-Code Development Essentials
15.1.1 Introduction
15.1.2 Share by using co-ownership
15.1.3 Share by using the run-only option
15.1.4 Use the Send a copy feature
15.1.5 Exercise - Send a copy
15.1.6 Solutions and sharing
15.1.7 Summary
15.2.1 Introduction
15.2.2 What is low code?
15.2.3 Understand Power Fx
15.2.4 Exercise - Create Your First Power Apps app as a Traditional Developer
15.2.5 Summary
15.3.1 Introduction
15.3.2 Add and remove apps, flows, and entities in a solution
15.3.3 Edit a solution-aware app, flow, and table
15.3.4 Exercise - Import and export solutions
15.3.5 Build and deploy a complex solution with flows, apps, and entities
15.3.6 Automate solution management
15.3.7 Summary
15.4.1 Introduction
15.4.2 Solution layering
15.4.3 Solution architecture tools and techniques
15.4.4 Use version control for solutions
15.4.5 Summary
Lesson 16:Validate your Power Platform Functional Consultant skills
Podcat Lesson 16:Validate your Power Platform Functional Consultant skills
16.1.1 Introduction to Microsoft Dataverse
16.1.2 Table characteristics
16.1.3 Exercise - Create a Microsoft Dataverse table
16.1.4 Exercise - Import data into your Microsoft Dataverse database
16.1.5 Table relationships
16.1.6 Exercise - Create table relationships
16.1.7 Dataverse logic and security
16.1.8 Exercise - Create a custom table and import data
16.1.9 Dataverse auditing
16.1.10 Dual-write vs. virtual tables
16.1.11 Summary
16.2.1 Introducing model-driven apps
16.2.2 Components of model-driven apps
16.2.3 Design model-driven apps
16.2.4 Exercise
16.2.5 Exercise - Control security when sharing model-driven apps
16.2.6 Incorporate business process flows
16.2.7 Exercise - Create a model-driven app
16.2.8 Summary
16.3.1 Introduction to Power Apps
16.3.2 Start Power Apps
16.3.3 Power Apps data sources
16.3.4 Use Power Apps with Power Automate and Power BI
16.3.5 Designing a Power Apps app
16.3.6 Summary
16.4.1 Introducing Power Automate
16.4.2 Create your first flow
16.4.3 Troubleshoot flows
16.4.4 Summary
16.5.1 Introduction
16.5.2 Prepare
16.5.3 Summary
Next
Side panel
Categories
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Search
Search
Search
Search
Close
Toggle search input
Log in
Categories
Collapse
Expand
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Course info
PL-200T00: Microsoft Power Platform Functional Consultant
Grade
Certificate
Certificate Download
Certificate Sharing
