• Create tables with Dataverse
• Import data into a Dataverse database

• Tables in Dataverse.
• Types of tables that are available in Dataverse.
• Creating a custom table.
• Enabling attachments within a table.
• Which licensing requirements to apply to use each type of table.

• Learn what a column is in Dataverse.
• Learn about the types of columns that are available in Dataverse.
• Add a column to a table.
• Learn what a primary name column is in Dataverse.
• Identify restrictions that are associated with columns.
• Create an auto-numbering column.
• Create an alternate key.

• Why you should segment data that is used by your solutions into many tables.
• Why you need to relate one table to another.
• How to build relationships between tables.
• How to select the proper relationship type when you’re building solutions with Dataverse.

• Learn about choices.
• Explore the standard choices.
• Create a new choice or modify an existing one.

• Learn about security roles and apply them to users in an environment.
• Learn how to add users to an environment.
• Understand security concepts in Dataverse
• Identify default security roles.
• Create a custom role.
• Create a custom security role and assign it to entities and users.
• Learn how to configure Dataverse teams for security
• Learn how to configure Dataverse group teams for security

• Administer Dataverse.
• Identify the different portals that are available for Dataverse.

• Manage role-based security
• Explore customization functionality and customize themes

• Access Microsoft Power Platform admin experiences.
• Create simple environment and tenant-wide DLP policies.
• Discover and identify the differences between the Business data group and the No-business data group.
• Learn about the differences between out-of-the-box Power Automate Admin experiences and Microsoft Power Platform Center of Excellence toolkit.

• Learn about model-driven app design
• Create a model-driven app

• Learn about form elements and controls
• Configure forms
• Use specialized form components
• Use editable grids
• Identify views and use public views
• Learn how to configure charts
• Learn how to configure dashboards

• Explore how Power Apps can make your business more efficient.
• Learn how to use different technologies to perform different tasks in Power Apps.
• Learn about the different ways to build an app in Power Apps.
• Create your first app from data in an Excel workbook.

• Understand and use action-based connectors
• Integrate user information and user-profile information into a canvas app
• Use Power Automate with Power Apps

• Understand the basics of building the UI through themes, icons, control customization, and images.
• Use personalization in a canvas app
• Understand the differences between the Tablet and Mobile form factors

• Learn how to view and restore app versions.
• Explore how to share an app, including permissions and notifications.
• Learn about what environments are, how to create them, and how to manage security.
• Find more information about Power Apps.

• Create an app by using the hero template.
• Customize and publish your app.
• Install templates.

• Identify the capabilities of Power Pages.
• Review the Power Pages site provisioning process.
• Learn about Power Pages core components and tools.
• Discover how to control user access to site content and Dataverse data.

• Identify the scenario-based templates to accelerate creating your site.
• Discover the features of the Dynamics 365 templates.
• Review the generic site design templates designed to solve unique business needs.
• Learn about blank template as a simple starting point to build a site to your exact specifications.

• Discover the portal components that are available to display and interact with Dataverse data on the portal.
• Identify the various features of the portal components.
• Display a list of data and an associated drill-down for details.
• Configure a table form to access individual records.
• Trigger classic Dataverse workflows from the portal.

• Explore common authentication tasks in a Power Apps portal deployment.
• Learn about portal contact extensions.
• Configure and register contacts as portal users.
• Align portal authentication settings with the business requirements.
• Identify authentication provider capabilities and steps that are involved in the registration.
• Select and configure identity providers.

• Apply strategies and techniques to troubleshoot portal issues.
• Learn about how the Portal Checker works and how to resolve potential portal issues.
• Perform the portal update process.

• Define business rules in Dataverse.
• Create and manage business rules in Dataverse.

• Create a flow that automatically saves email attachments
• Learn how to create a button flow to send yourself a reminder

• Learn about the Admin center
• Learn how to import and export flows
• Learn how to share flows

• Learn about the Dataverse triggers and actions in Power Automate.
• Discover the additional inputs that are available.

• Build flows with Dataverse.
• Integrate Dataverse with Microsoft Outlook.
• Integrate Dataverse with Microsoft To Do.

• Use one or more functions to create expressions.
• Use functions to retrieve data, change data, evaluate data, and more.

• Learn how to use Power Automate to create a new desktop flow.
• Record actions that are performed in a desktop-based application.
• Perform a test run of the new desktop flow.

• Run a basic desktop flow in unattended mode.
• Run a desktop flow and cloud flow scenario in unattended mode.
• Learn about best practices and setup for unattended desktop flows.

• Create your first recording.
• Edit recordings and group actions.
• Analyze recordings and interpret results.

• Create Power Virtual Agents bots.
• Test Power Virtual Agents bots.
• Analyze performance.

• Initiate Power Automate flows directly from topics in your bot.
• Configure bots to pass conversations to applications such as Omnichannel for Customer Service.
• Extract content from support pages and configure it into bot topics that you can use in conversations.

• Examine how to use topics to create and manage conversation paths in a bot.
• Work with topic triggers and conversation nodes.
• Add branching to a topic.
• Use system topics and create topics from content.
• Set up fall-back topics to handle unrecognized user input.

• Create and configure a new bot.
• Set permissions and security.
• Use topics and entities.
• Import and export bots.
• Authenticate users.

• Learn how Power BI services and applications work together.
• Explore how Power BI can make your business more efficient.
• Learn how to create compelling visuals and reports.

• Explore the data-centric features and tools of Power BI.
• Explore ways to find data.

• Create relationships between your data sources
• Create a new field with calculated columns
• Optimize data by hiding fields and sorting visualization data
• Create a measure to perform calculations on your data
• Use a calculated table to create a relationship between two tables
• Format time-based data so that you can drill down for more details

• Explore Power BI visuals
• Create visuals

• Upload reports
• Create dashboards
• Ask questions of your data

• Publish reports
• Print and export reports
• Build apps
• Integrate with OneDrive
• Publish to the web

• Package existing items into a solution.
• Create solutions.
• Edit existing solution-aware apps, flows in a solution.
• Import and export solutions.
• Deploy complex solutions with many components.
• Learn about component dependency on other components.

• View data within a table.
• Create or edit views of data in a table.
• Load data into a table.
• Export data from a table.
• Add, update, or delete data in a table by using Excel.
• Import data using Power Query in Maker Portal
• Generate a new dataflow from an Excel Template
• Learn about dataflows and Azure integration

• Explore how AI Builder can help improve your business performance.
• Learn how to use different AI technologies to enhance your processes.
• Create your first model.
• Learn how to use your models in Power Apps and Power Automate.

• Learn about the lifecycle of a model.
• Learn how to manage model versions.
• Explore how to share a model, including permissions.
• Get a better understanding of AI Builder.

• Explore how using AI Builder in Power Automate can save you time. 
• Learn how to use AI Builder actions in Power Automate.
• Discover advanced AI Builder usage in Power Automate.

• Learn the key responsibilities and skills of the functional consultant role on a project that involves Microsoft Power Platform.
• Learn about creating entity relationship diagrams, wireframes, and mockups for apps, documenting requirements and solution artifacts, and documenting details of data for migration and integration.
• Understand how functional consultants are expected to engage with stakeholders, perform quality assurance, and configure integrations on projects.

A: This PL-200 training covers a wide range of topics, including an introduction to the Power Platform, understanding business requirements, designing solutions, creating and managing Power Apps, configuring Power Automate workflows, working with Power BI for data visualization, and building chatbots with Power Virtual Agents.

A: PL 200 is designed for individuals who want to work as functional consultants or business analysts with the Microsoft Power Platform. It is suitable for professionals involved in solution envisioning, requirement gathering, solution design, and configuration of Power Platform components.

A: While there are no strict prerequisites, having a basic understanding of business processes, data structures, and the Microsoft Power Platform will be beneficial. Familiarity with Microsoft Office 365 and experience with Power Apps, Power Automate, or Power BI will also be advantageous.

A: By the end of this PL200 training, you will have the skills and knowledge to work as a functional consultant with the Microsoft Power Platform. You will learn how to analyze business requirements, design solutions, create and manage Power Apps, configure Power Automate workflows, visualize data with Power BI, and build chatbots using Power Virtual Agents.

A: Yes, PL 200 includes hands-on exercises and labs that provide practical experience in working with the Microsoft Power Platform. You will have the opportunity to apply the concepts learned in a simulated environment, gaining valuable hands-on skills.