Microsoft Power Platform Functional Consultant (PL-200T00)

1. Create and manage environments in Dataverse
   1. Environments in Microsoft Dataverse
   2. Developer environments
   3. Create and manage an environment
   4. Create a Microsoft Dataverse database
   5. Add users and roles within an environment
   6. Manage environment settings and operations
2. Create tables in Dataverse
   1. Table characteristics and relationships
   2. Dataverse logic, security, and auditing
   3. Dual-write versus virtual tables
3. Manage tables in Dataverse
   1. Identify tables and table types
   2. Create a custom table
   3. Enable table attachments
   4. Review licensing requirements for table types
4. Create and manage columns within a Dataverse table
   1. Define columns and column types
   2. Add a column and configure the primary column
   3. Understand column restrictions
   4. Create an autonumber column
   5. Create an alternate key
5. Work with choices in Dataverse
   1. Define choice columns
   2. Configure choice and standard choice columns
6. Load and export data and create Dataverse views
   1. View table data
   2. Create or edit data views
   3. Review data import and export options
   4. Load data into a table
   5. Add, update, or delete table data with Excel
   6. Import data with Power Query
7. Connect to other data in a Power Apps canvas app
   1. Review available data sources
   2. Work with action data
   3. Use Power Automate with Power Apps
8. Get started with security concepts in Dataverse
   1. Role-based security
   2. Business units and hierarchy security
   3. Table and record ownership
   4. Column-level security
   5. Security across multiple environments
9. Get started with security roles in Dataverse
   1. Understand environment roles
   2. Add or disable an environment user
   3. Understand user security roles and defaults
   4. Check a user's roles
   5. Configure Dataverse and group teams for security
10. Use administration options for Dataverse
    1. Use the Microsoft Power Platform admin center
    2. Manage tenant storage capacity
    3. Use advanced customization options
    4. Configure Dataverse search and auditing
    5. Manage duplicate detection and bulk deletion
    6. Review long-term data retention
11. Visualize data with Dataverse views
    1. Create and edit views in the Power Apps maker portal
    2. Filter and sort data for Dataverse views
12. Use Power Query to load data into Dataverse
    1. Import static data
    2. Import dynamic data
13. Use Microsoft Word and Excel templates with Dataverse
    1. Create a dynamic Word template
    2. Create a dynamic Excel template
14. Export Dataverse data and edit records with Microsoft Excel
    1. Export data to Excel
    2. Edit and update data in Excel
15. Use Azure and external tools to manipulate data
    1. Use Dataverse community tools for data manipulation
    2. Review Power BI integration with Dataverse
16. Create relationships between Dataverse tables
    1. Review available relationship types
    2. Create a one-to-many relationship
    3. Create a many-to-many relationship
    4. Edit or delete relationships
17. Define and create business rules in Dataverse
    1. Define business rules
    2. Identify the components of a business rule
    3. Create a business rule
18. Create calculation and rollup columns in Dataverse
    1. Create a rollup column
    2. Create a calculation column
19. Configure forms, charts, and dashboards in model-driven apps
    1. Forms and form elements
    2. Configure multiple and specialized forms
    3. Configure views and grids
    4. Create and edit views
    5. Configure charts and dashboards
    6. Use interactive streams and tiles
20. Use specialized components in a model-driven form
    1. Create business process flows
    2. Embed a canvas app
    3. Add a timeline
    4. Create a report
21. Evaluate Power Platform analytics and AI
    1. Power Platform reporting capabilities
    2. Power BI overview and data requirements
    3. Power BI and Power Platform
    4. Dataflows
    5. AI
22. Describe how to build applications with Microsoft Power Apps
    1. Describe Power Apps
    2. Explore canvas and model-driven applications
    3. Differentiate between canvas and model-driven apps
    4. Build basic canvas and model-driven apps
23. Deploy and refine an app
    1. Publish and share the app
    2. Use QR codes
    3. Collect feedback and analyze telemetry
24. Customize the command bar
    1. Create or edit modern commands
    2. Work with classic commands
    3. Use Power Fx
25. Get started with Power Apps canvas apps
    1. Start Power Apps
    2. Use Power Apps data sources
    3. Use Power Apps with Power Automate and Power BI
    4. Design a Power Apps app
26. Customize a canvas app in Power Apps
    1. Make basic app customizations
    2. Explore canvas-app controls and screens
27. Build a canvas-app user interface
    1. Use themes
    2. Brand controls
    3. Use icons and images
    4. Personalize the interface
    5. Build for phones or tablets
28. Configure navigation in a canvas app
    1. Understand navigation
    2. Use the Navigate and Back functions
    3. Explore additional uses of the Navigate function
29. Manage apps in Power Apps
    1. Review Power Apps
30. Build a mobile-optimized app with Power Apps
    1. Review mobile-optimized apps
    2. Identify mobile optimization components
    3. Create a responsive, mobile-optimized app
    4. Identify performance considerations
31. Configure navigation in a canvas app
    1. Understand navigation
    2. Use the Navigate and Back functions
    3. Explore additional uses of the Navigate function
32. Build a canvas-app user interface
    1. Use themes
    2. Brand controls
    3. Use icons and images
    4. Personalize the interface
    5. Build for phones or tablets
33. Use and understand controls in a canvas app
    1. Core control properties
    2. Enter and display data with text controls
    3. Use additional controls to improve usability
    4. Work with media and modern controls
    5. Work with component libraries
34. Document and test a Power Apps application
    1. Create test plans
    2. Perform user-interface testing
    3. Optimize performance
    4. Use diagnostics and analytics
    5. Create customer documentation
35. Create formulas that change canvas-app properties
    1. Formula overview
    2. Modify control formatting
    3. Perform calculations
    4. Modify the properties of other controls
    5. Apply conditional formatting
    6. Validate data with functions
36. Create formulas that change canvas-app behaviors
    1. Formulas and functionality
    2. True and false values
    3. Control behaviors and actions
    4. Perform multiple actions in a formula
    5. Control display mode with a formula
    6. Create dynamic formulas
37. Author basic formulas that use tables and records
    1. Records and tables
    2. Use the Table function
    3. Store and filter a table
    4. Use the lookup function to return a record
    5. Use additional table functions
38. Create formulas that use tables, records, and collections
    1. Process multiple records
    2. Perform mathematical operations on tables
    3. Combine and separate records
    4. Use the ForAll function
    5. Lab: Use the ForAll function in a gallery
39. Use imperative development techniques for canvas apps
    1. Imperative versus declarative development
    2. Understand Power Apps variable types
    3. Use global and contextual variables
    4. Use collections
    5. Explore additional variable concepts
40. Explore Power Pages design studio
    1. Work with pages
    2. Use page components
    3. Apply site styling and templates
41. Explore Power Pages design studio data and security features
    1. Use the data workspace
    2. Review Power Pages security features
42. Work with Power Pages metadata
    1. Power Pages metadata
    2. Webpages
    3. Power Pages templates
43. Integrate Power Pages websites with Dataverse
    1. Configure basic forms
    2. Review multistep form processes
    3. Set up multistep forms
    4. Extend lists and forms
44. Work with the Liquid template language in Power Pages
    1. Liquid basics
    2. Access Dataverse data
    3. Data security and Liquid
45. Set up Power Pages security
    1. Secure static content
    2. Configure table permissions
46. Build user experiences in Power Pages
    1. Create multilingual and reusable content
    2. Configure website structure and navigation
    3. Use portal themes
    4. Configure content search
    5. Review Power Pages compliance
47. Access Dataverse in Power Pages websites
    1. Use lists to display Dataverse records
    2. Use forms to interact with Dataverse data
48. Extend Power Pages websites
    1. Manage the website lifecycle
    2. Extend a website with scripts
    3. Use advanced CSS
    4. Perform advanced client-side development
49. Build custom Power Pages web templates
    1. Create web templates
    2. Use web templates as an API
50. Administer Power Pages
    1. Use Power Pages administrative tools
    2. Manage the Power Pages lifecycle
    3. Set up essential website features
51. Integrate Power Pages with web-based technologies
    1. Use SharePoint document management
    2. Integrate Power BI
    3. Use model-driven charts
52. Configure authentication and user management in Power Pages
    1. Configure authentication settings
    2. Manage user registration
    3. Manage Power Pages users
    4. Configure authentication providers
53. Maintain and troubleshoot Power Pages
    1. Maintain a Power Pages website
    2. Troubleshoot a Power Pages website
54. Explore Power Pages templates
    1. Site design templates
    2. Scenario-based templates
    3. Dynamics 365 Power Pages site templates
55. Apply error-handling best practices in Power Automate flows
    1. Configure the run-after option
    2. Use Power Automate analytics
56. Introduction to expressions in Power Automate
    1. Get started with expressions
    2. Use notes
    3. Review function types
    4. Write complex expressions
57. Use Dataverse triggers and actions in Power Automate
    1. Use Dataverse triggers
    2. Query data
    3. Create, update, delete, and relate records
58. Extend Dataverse with Power Automate
    1. Work with files and images
    2. Perform operations
    3. Search data
    4. Use changesets
59. Share a Power Automate cloud flow
    1. Share through co-ownership
    2. Share with the run-only option
    3. Use Send a copy
    4. Work with solutions and sharing
60. Understand low code as a traditional developer
    1. Define low code
    2. Understand Power Fx
61. Manage solutions in Power Apps and Power Automate
    1. Add and remove apps, flows, and tables in a solution
    2. Edit solution-aware apps, flows, and tables
    3. Build and deploy a complex solution
    4. Automate solution management
62. Introduction to Microsoft Power Platform solutions
    1. Solution layering
    2. Solution architecture tools and techniques
    3. Use version control for solutions
63. Create tables in Dataverse
    1. Table characteristics and relationships
    2. Dataverse logic, security, and auditing
    3. Dual-write versus virtual tables
64. Get started with model-driven apps in Power Apps
    1. Introduction to model-driven apps
    2. Model-driven app components
    3. Design model-driven apps
    4. Incorporate business process flows
65. Get started with Power Apps canvas apps
    1. Start Power Apps
    2. Use Power Apps data sources
    3. Use Power Apps with Power Automate and Power BI
    4. Design a Power Apps app
66. Get started with Power Automate
    1. Introduction to Power Automate
    2. Create a first flow
    3. Troubleshoot flows
67. Challenge project: Build applications and automation solutions
    1. Prepare for the challenge project

Each student receives a comprehensive set of materials, including course notes and all class examples.