Microsoft Power Platform Functional Consultant

Microsoft Power Platform PL-200 training course for Functional Consultants who want to simplify, automate and empower business processes using Power Apps Power Automate and Microsoft Dataverse. Learn to design, configure and implement apps, automations and solutions while performing discovery, capturing requirements, engaging stakeholders and mapping business needs to platform features.

This Microsoft Power Platform course prepares learners for the PL-200 certification and the role of a Microsoft Power Platform Functional Consultant. The course teaches how to use Microsoft Power Platform solutions to simplify, automate and empower business processes using Power Apps, Power Automate and Microsoft Dataverse.

A Microsoft Power Platform Functional Consultant creates and configures apps, automations and solutions and acts as the liaison between users and the implementation team. Learners develop Power Platform fundamentals by performing discovery, engaging stakeholders and subject matter experts, capturing requirements and mapping those requirements to platform features. The Functional Consultant promotes adoption and effective use of Power Platform solutions.

The course focuses on designing configuring and implementing solutions using Microsoft Power Apps training, Power Automate certification concepts and Dataverse. Solution implementation includes application enhancements, custom user experiences, system integrations, data conversions, custom process automation and simple visualisations. This training aligns with Microsoft Learn Power Platform content and supports ongoing Power Platform learning.

This PL-200 training course may contain a 1-day Applied Workshop where delegates can build their own model-driven app from scratch. The workshop is included in the course delivery if time allows and participants are also welcome to explore it independently afterwards. Learners practise Functional Consultant skills by creating an end-to-end solution using a Microsoft Dataverse database, Power Apps app and Power Automate flows.

While no formal prerequisites are enforced learners are expected to have foundational Microsoft Power Platform fundamentals knowledge and general business or IT experience. This course supports Microsoft Power Platform certification, PL-200 training and further Power Apps training courses and Power Automate Microsoft certification learning paths.

Discover more

Download Outline ➤ MS-PL200T00 Microsoft Power Platform Functional Consultant

Watch an informative video ➤  What is Power BI

ASSOCIATED CERTIFICATIONS & EXAM

This course will prepare delegates to write the PL-200 Power Platform Functional Consultant Exam.

COURSE CONTENT

Module 1: Getting started using Dataverse

Do you want to learn how to build solutions that can use a standardised data structure and work with other solutions sharing the same data model? Do you want to extend the standard model to support custom solutions? This learning path explains the concepts behind and the benefits of Dataverse. Creating an environment, entities, fields, and option sets are also discussed in this learning path.

Module 2: Manage permissions and administration for Dataverse

Do you need to manage user access rights? In this learning path, you will learn how to manage permissions associated with environments and entities. You will also learn about different administrative portals and how to access each.

Module 3: Visualise, import, and export Microsoft Dataverse data

This learning path will show you how to use various Dataverse views, explore how Power Query can load data into Dataverse tables, and how to use Dataverse with third-party tools.

Module 4: Create relationships, business rules, calculations, and rollups in Dataverse

Do you need to create data relationships, business rules, calculations, and rollups in Dataverse? These modules help you use Dataverse to build powerful business solutions to transform your operations, processes, and your entire organisation. The learning path Get started with Dataverse introduces you to Dataverse and many of the key concepts, which include environment, entities, fields and option sets. This learning path continues and expands the exploration of Dataverse with an overview of how to form relationships between entities, how to build business rules to perform logic based upon your organisation’s needs, and how to add calculations and rollup fields.

Module 5: Advanced Model-Driven Apps with Power Apps: Configuration, Customisation, and Deployment Techniques

This learning path covers creating and customising model-driven apps in Microsoft Power Platform, including using forms, views, and dashboards, deploying and evolving apps, and leveraging reporting, analytics, and command customisation.

Module 6: Create a canvas app in Power Apps

Do you want to create apps to help make your business more efficient? Then this path is for you. It introduces you to Power Apps, helps you create and customise an app, and then manage and distribute it.

Module 7: Use the UI and controls in a canvas app in Power Apps

The app user experience often defines the success of your app. This learning path will focus on how to provide the best app navigation and build the best UI using themes, icons, images, personalisation, different form factors and controls.

Module 8: Use basic formulas to make better Power Apps canvas apps

Do you want to use formulas to improve functionality and change a behaviour in your Power Apps canvas app? This learning path can help you accomplish your goal.

Module 9: Advanced Canvas App Development in Power Apps: Mastering Formulas and Development Techniques

This learning path teaches how to write complex formulas and apply imperative development techniques in Power Apps, including understanding various development methods and utilising different types of variables.

Module 10: Work with Power Pages websites

Power Pages websites are designed for interaction with the internal and external audiences. There are additional requirements for content management and design, as well as the need to secure the content. This learning path describes how Power Pages components work within the context of Dataverse to deliver the content and data to external and internal audiences. We’ll cover the topics of user authentication and how to secure access to different parts of the website content based on the target audience and relationship to the content.

Module 11: Extend Power Pages

The ability to easily surface and interact with Microsoft Dataverse data on an externally facing website is the core benefit of implementing a Power Pages website. This learning path describes how to transform a content website into a complete web app interacting with Dataverse. We will also cover the options available to customizers and developers to extend the website functionality and integrate with Office 365, Microsoft Power Platform, and Azure components.

Module 12: Administer Power Pages

Administrators need to understand how to configure various features and add-ons to ensure Power Pages site runs securely and efficiently. Power Pages provide additional features and functionality, including integration with other Microsoft technologies such as SharePoint document libraries and Power BI reports. This learning path describes tools and techniques available for administrators to configure and maintain Power Pages sites, as well as efficiently troubleshoot issues.

Module 13: Work with Power Automate error handling and expressions

This learning path covers how to use your Power Automate skills to master error handling and expressions. Learn best practices for identifying and resolving flow failures efficiently using the flow actions and built-in error reports. Then, take your automation to the next level by leveraging expressions to manipulate and optimise your data.

Module 14: Integrate Power Automate flows and Dataverse

Work with triggers and actions to extend Power Automate and Dataverse. This Learning Path looks at how to use these features with your flows.

Module 15: Power Platform Solution Management: Sharing, Customisation, and Low-Code Development Essentials

This learning path covers sharing Power Automate cloud flows, using Power Apps for app creation, managing solutions in Power Automate, and transporting and customising apps within Microsoft Power Platform.

Module 16: Validate your Power Platform Functional Consultant skills

This learning path prepares you to complete the Microsoft Power Platform Functional Consultant challenge project and validate your skills. You should have already completed the following modules as part of the PL-200: Microsoft Power Platform Functional Consultant course. If you haven’t, it’s recommended that you take some time to complete these modules before beginning the challenge project.