🎓 Authorised Pearson VUE and Prometric Test Centre · CIET Country Director for Syria · training in Mazzeh since 2010·Exams we deliver →
ENعربي
Enrol now
Home/Courses/Microsoft Power Platform/Microsoft Power Platform Functional Consultant (PL-200 Exam …
Microsoft Power Platform

Microsoft Power Platform Functional Consultant (PL-200 Exam Prep)

Configure Power Platform solutions that fit how a business really works.

5 daysIntermediate67 modulesPL-200Microsoft Certified: Power Platform Functional Consultant Associate
Enrol or enquire →Ask on WhatsApp
Overview

About this course

Configure Power Platform solutions that fit how a business really works. Across five days you will set up Dataverse environments, tables, columns and choices, import data with Power Query, design views and Word and Excel templates, and apply role-based, business unit and hierarchy security. The programme prepares you for the PL-200 exam and the Power Platform Functional Consultant Associate certification.

Curriculum

Curriculum

67 modules
  • Environments in Microsoft Dataverse
  • Developer environments
  • Create and manage an environment
  • Create an instance of a Microsoft Dataverse database
  • Add users and roles within an environment
  • Manage settings in an environment
  • Environment operations
  • Table characteristics
  • Table relationships
  • Dataverse logic and security
  • Dataverse auditing
  • Dual-write vs. virtual tables
  • Identify tables and table types in Dataverse
  • Create a custom table
  • Enable attachments within a table
  • Licensing requirements for each table type
  • Define columns in Microsoft Dataverse
  • Column types in Microsoft Dataverse
  • Add a column to a table
  • Primary column
  • Restrictions that apply to columns in a table
  • Create an auto numbering column
  • Create an alternate key
  • Define choice column
  • Choice columns
  • Standard choices column
  • View data in a table
  • Create or edit views of data in a table
  • Dataverse data import options
  • Load data into a table
  • Dataverse data export options
  • Export
  • Add, update, or delete data in a table by using Excel
  • Import data using Power Query
  • Overview of the different data sources
  • Work with action data
  • Power Automate is a companion to Power Apps
  • Role-based security
  • Business units
  • Hierarchy security
  • Table/record ownership
  • Column-level security to control access
  • Manage security across multiple environments
  • Understand environment roles
  • Adding or disabling an environment user
  • Understand user security roles and security role defaults
  • Check the roles that a user belongs to
  • Configure Dataverse teams for security
  • Configure Dataverse group teams for security
  • Use Microsoft Power Platform Admin Center portal
  • Tenant storage capacity
  • Advanced Customization options in Power Apps Portal
  • Dataverse Search
  • Auditing
  • Duplicate detection
  • Bulk delete
  • Long term data retention
  • Create and edit views in Power Apps maker portal
  • Filter and sort data for Dataverse views
  • Import static data by using Power Query
  • Import dynamic data by using Power Query
  • Create a dynamic Word template
  • Create a dynamic Excel template
  • Export data to Excel
  • Edit and update data in Excel
  • Use Dataverse community tools for data manipulation
  • Review Power BI integration with 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
  • Define business rules - Introduction
  • Define the components of a business rule
  • Create a business rule
  • Create a rollup column
  • Create a calculation column
  • Forms overview
  • Form elements
  • Configure multiple forms
  • Use specialized form components
  • Configure views overview
  • Configure grids
  • Create and edit views
  • Configure charts overview
  • Dashboards overview
  • Use interactive streams and tiles
  • Create business process flows
  • Embed a canvas app in a model-driven form
  • Add a timeline in a model-driven form
  • Create a report in a model-driven form
  • Power Platform reporting capabilities
  • Power BI overview
  • Data requirements
  • Power BI and Power Platform
  • Dataflows
  • AI
  • Describe Power Apps
  • Explore canvas applications
  • Explore model-driven applications
  • Differentiate between canvas apps and model-driven apps
  • Build a basic canvas app
  • Build a basic model-driven app
  • Publish the app
  • Share the app
  • Use QR codes
  • Collect feedback and analyze telemetry
  • Create or edit modern commands
  • Work with classic commands
  • Use Power Fx
  • Start Power Apps
  • Power Apps data sources
  • Use Power Apps with Power Automate and Power BI
  • Designing a Power Apps app
  • Improve your app by making basic customizations
  • Explore controls and screens in canvas apps
  • Use themes to quickly change the appearance of your app
  • Brand a control
  • Icons
  • Images
  • Personalization
  • Build for phones or tablets
  • Understanding navigation
  • The Navigate and Back functions
  • More ways to use the Navigate function
  • Power Apps review
  • Learn about mobile-optimized apps
  • Identify components to make a canvas app mobile-optimized
  • Create a mobile-optimized app that uses responsive designs
  • Identify performance considerations for a mobile-optimized canvas app
  • Understanding navigation
  • The Navigate and Back functions
  • More ways to use the Navigate function
  • Use themes to quickly change the appearance of your app
  • Brand a control
  • Icons
  • Images
  • Personalization
  • Build for phones or tablets
  • Core properties of controls
  • Entering and displaying data with text controls
  • Additional controls for enhancing your app's usability
  • Media
  • Modern controls
  • Work with component libraries
  • Create test plans
  • User interface testing
  • Performance optimization
  • Diagnostics and analytics
  • Documentation and the customer
  • Formulas overview
  • Use a formula to modify the format of controls
  • Use formulas to perform calculations
  • Use a control to modify the property of other controls
  • Conditional formatting
  • Functions for validating data
  • Formulas and functionality
  • Understanding true and false
  • Understanding control behaviors and actions
  • Performing multiple actions in a formula
  • Control the display mode through a formula
  • Use controls and functions to create a dynamic formula
  • Records and tables
  • Using the Table function
  • Store a table
  • Filter your table
  • Use the lookup function to return a record
  • Additional table functions
  • Formulas that process multiple records
  • Math operations on tables
  • Combine and separate records
  • The ForAll function
  • Lab - Using the ForAll function in a gallery
  • Imperative versus declarative development
  • The three types of variables in Power Apps
  • Global variables
  • Contextual variables
  • Collections
  • Additional variable concepts
  • Work with pages
  • Page components
  • Site styling and templates
  • Data workspace in Power Pages design studio
  • Power Pages security features
  • Power Pages metadata
  • Webpages
  • Power Pages templates
  • Basic form configuration
  • Multistep form processes
  • Set up multistep forms
  • Extend lists and forms
  • Liquid basics
  • Access Dataverse data
  • Data security and Liquid
  • Secure static content
  • Table permissions
  • Multilingual content
  • Reusable content in Power Pages
  • Power Pages website structure and navigation
  • Portal themes
  • Content search
  • Compliance in Power Pages
  • Use lists to display multiple Dataverse records
  • Use forms to interact with Dataverse data
  • Power Pages website life cycle management
  • Extend with scripts
  • Advanced CSS
  • Advanced client-side development
  • Create web templates
  • Web templates as API
  • Power Pages administrative tools
  • Power Pages life cycle
  • Set up essential features of a Power Pages website
  • Document management with SharePoint in Power Pages
  • Integration with Power BI in Power Pages
  • Model-driven charts in Power Pages
  • Power Pages authentication settings
  • User registration in Power Pages
  • Authentication management for Power Pages users
  • Power Pages authentication providers
  • Power Pages website maintenance
  • Power Pages website troubleshooting
  • Site design templates
  • Scenario-based templates
  • Power Pages site templates
  • Configure run after option
  • Power Automate analytics
  • Get started with expressions
  • Notes make things easier
  • Types of functions
  • Write complex expressions
  • Dataverse triggers
  • Query data
  • Create, update, delete, and relate actions
  • Work with files and images
  • Perform operations
  • Search data
  • Changesets
  • Share by using co-ownership
  • Share by using the run-only option
  • Use the Send a copy feature
  • Solutions and sharing
  • What is low code?
  • Understand Power Fx
  • Add and remove apps, flows, and entities in a solution
  • Edit a solution-aware app, flow, and table
  • Build and deploy a complex solution with flows, apps, and entities
  • Automate solution management
  • Solution layering
  • Solution architecture tools and techniques
  • Use version control for solutions
  • Table characteristics
  • Table relationships
  • Dataverse logic and security
  • Dataverse auditing
  • Dual-write vs. virtual tables
  • Introducing model-driven apps
  • Components of model-driven apps
  • Design model-driven apps
  • Incorporate business process flows
  • Start Power Apps
  • Power Apps data sources
  • Use Power Apps with Power Automate and Power BI
  • Designing a Power Apps app
  • Introducing Power Automate
  • Create your first flow
  • Troubleshoot flows
  • Prepare
Who it's for

Who it's for

Functional consultants and IT professionals who turn business requirements into Power Platform configurations.

Before you start

  • Experience as an IT professional or student
  • Working knowledge of Microsoft Power Platform and its key components
  • Knowledge of Microsoft Dataverse (or general data modeling) and security concepts
Certification

Prepares for

Microsoft Power Platform

Microsoft Certified: Power Platform Functional Consultant Associate

PL-200

1 course

View certification →

Related courses

More in Microsoft Power Platform →
IntermediatePL-400T00

Microsoft Power Platform Developer (PL-400T00)

Microsoft Power Platform

5 days
View course →
IntermediatePL-300

PL-300T00 Design and Manage Analytics Solutions Using Power BI (PL-300 Exam Prep)

Microsoft Data & Power BI

3 days
View course →
Intermediate

55268 Microsoft Power Automate for End Users

Microsoft Power Platform

1 day
View course →
IntermediatePL-500/PL-500T00

Microsoft Power Automate RPA Developer (PL-500/PL-500T00)

Microsoft Power Platform

5 days
View course →
FoundationPL-900T00

Microsoft Power Platform Fundamentals (PL-900T00)

Microsoft Power Platform

2 days
View course →
Intermediate55265

Microsoft PowerApps (55265)

Microsoft Power Platform

2 days
View course →

Let's plan your next step together.

Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.

Talk to an advisor →WhatsApp