Power Platform

Preparing for PL-200 Microsoft Power Platform Functional Consultant

In my previous blog post I shared some experience from taking Microsoft certifications. In that blog post I mentioned that for some time ago an opportunity came up to do a review of a new book written by MVP Julian Sharp. This is the book: Microsoft Power Platform Functional Consultant: PL-200 Exam Guide: Learn how to customize and configure Microsoft Power Platform and prepare for the PL-200 exam. Since I like to learn by reading (in combination with trying out new things myself) and since I had in my plan to take the PL-200 exam, I thought why not take this opportunity, review the book and schedule for the exam. So I did and I passed the exam. In this blog post I will let you in on how this exam was for me.

About PL-200

In order to become a Silver Partner or Gold Partner with Microsoft within the category Cloud Business Applications a company needs (at the time of this writing) at least 5 individuals to have passed the MB-200 exam OR the PL-200 exam (and 15 individuals for Gold Partnership). MB-200 is valid until the 31st of December 2021, but PL-200 is the one to take from now on. For Silver/Gold partnership the individuals needs to take other exams too and there are also other measurements, but PL-200 is like the base exam that you need to take. Might be good to know, this exam is a good start. Talk to your employer about what certifications exams might be good for you to take, which also helps the employer and the partnership with Microsoft.

Here is the PL-200 exam page in Microsoft Docs: https://docs.microsoft.com/en-us/learn/certifications/exams/pl-200. Make sure you are familiar with the concepts and have work experience from the different parts or have gone through labs. Every exam is not completely the same. There are 40 questions in total during one exam and you will get 40 questions from a bank of more questions. Here follows examples of the type of knowledge that the exam questions in my exam required. Please note that below are just topics as examples and not real questions. See it as topics you need to understand when you take this exam.

PL-200 badge!

Power Automate

Power Virtual Agents

Microsoft Dataverse (formerly CDS)

  • Configuring custom tables (entities) including knowledge about creating/modifying views and forms.
  • Knowledge about the types of views and types of forms as well as when to use what type.
  • Virtual entities (tables) and when to use that – e.g. display data from other systems.
  • Entity relationship, types of relationships and configuring cascading behavior.
  • Dataverse security management. Adding users to AD groups, adding security roles.
  • How it works with security roles. E.g. if you have several roles, what will you be authorized to.
  • Quick find in views. How to Configure search columns.

    Dataverse in MS Docs: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/

Power Apps

  • Building Canvas Apps, type of controls and formulas. Galleries,collections, variables.
  • How it works with version history with Canvas apps. Remember that you need to publish the app before users can see the latest version.
  • How to create a model-driven app and how the sitemap is built up.

    Power Apps in MS Docs: https://docs.microsoft.com/en-us/powerapps/

Power BI

AI Builder


Case Study

Some questions are related to a case study. First a lot of text and then several questions related to it. The format was like ”these are the requirements, how to create the solution for X Y Z. It was related to different parts of Power Platform (obviously) e.g. PVA, Power Apps portals etc.

For me, the parts about UI Flows and Power BI were the trickiest since those are the parts of Power Platform that I have the least experience from working with. Also remember that it is OK to guess and try your best. Always answer ALL questions!

Read more

Here follows other people’s guides to learning about PL-200 preparations.

PL-200 Microsoft Power Platform Functional Consultant article by MVP EY Kalman.

PL-200 – Power Platform Functional Consultant Carl Cookson article by MVP Carl Cookson.

Mind Map created by MVP Carl Cookson.

As a complement to having work experience and/or exploring it all by yourself, an excellent way to prepare for this exam is to read the book written by Julian Sharp. The book is so much more than just a preparation book and there is lots to learn, both for beginners as well as for people with much experience. In my next blog post I will tell you a bit about Julian’s book. I really recommend it for anyone who is looking for taking the PL-200 certification exam as well as for anyone new to the Power Platform and who wants to learn more about the main concepts from a low-code perspective. Did you notice that there is currently a code to be used until the end of May, giving you a better price if you want to buy the book, have a look here.

3 thoughts on “Preparing for PL-200 Microsoft Power Platform Functional Consultant”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s