PL-200T00 Microsoft Power Platform Functional Consultant
5 Based on 213 reviews- 380,509 Learners
- 287 Courses
This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.
Request More InfoWho should attend PL-200T00 Microsoft Power Platform Functional Consultant Course
A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.
Prerequisites for PL-200T00 Microsoft Power Platform Functional Consultant Course
PL-200T00 Microsoft Power Platform Functional Consultant Course Outline
- 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
- Dynamics 365 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
Resources
FAQs on PL-200T00 Microsoft Power Platform Functional Consultant
This course teaches how to become a Microsoft Power Platform Functional Consultant, covering environment and Dataverse management, table creation and configuration, columns, choices, and building apps, automations, and solutions that bridge business requirements with technical implementation.
Participants should have experience as an IT professional or student, working knowledge of Microsoft Power Platform and its key components, and knowledge of Microsoft Dataverse (or general data modeling) and security concepts.
This course is designed for aspiring or current Power Platform Functional Consultants who create apps, automations, and solutions, gather requirements from stakeholders, and implement enhancements, integrations, data conversions, process automation, and visualizations.
You will learn to create and manage environments, build and manage custom tables, configure columns and choice sets, understand table relationships, security, auditing, and differentiate between dual-write and virtual tables.
Yes, PL-200T00 aligns with the skills measured in the Microsoft Certified: Power Platform Functional Consultant Associate certification exam (PL-200).