Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Microsoft Power Platform Functional Consultant: PL-200 Exam Guide
Microsoft Power Platform Functional Consultant: PL-200 Exam Guide

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

eBook
€8.99 €34.99
Paperback
€43.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Microsoft Power Platform Functional Consultant: PL-200 Exam Guide

PL-200 Exam

The Power Platform is a set of tools, including Power BI, Power Apps, Power Automate, and Power Virtual Agents, for building business solutions without the need to write code. Using the Power Platform, anyone can create an app. The Power Platform is not just for citizen developers; the capabilities of the Power Platform can be used by IT professionals and can be extended by developers.

In this chapter, you will be introduced to the exam contents, the purpose of the exam, the skills measured, and who the exam is aimed at. We will discuss role-based certifications and how the PL-200 exam fits in with the Dynamics 365 and Power Platform role-based certifications.

The topics covered in this chapter are as follows:

  • Understanding role-based certifications
  • Introducing Dynamics 365 and Power Platform roles
  • Exploring the PL-200 exam and objectives
  • Reviewing the skills measured
  • Related exams

By the end of this chapter, you will understand the scope of the PL-200 exam and its structure. You will also have an idea about who the exam is aimed at and be familiar with the exam paper before you sit the exam.

Understanding role-based certifications

In response to customer expectations and feedback on certification, Microsoft has changed the way candidates for certifications are examined in order to provide candidates and employers with more relevant certifications for their jobs.

Certifications have evolved to focus on the core skills aligned to specific job roles, moving toward teaching you how to use the technology to help you develop the skills you need to fulfill a specific job role.

The value of certifications has been reevaluated at Microsoft, with many Microsoft staff now having to gain certifications themselves. This has led to a greater focus on certifications and an increase in the quality of courses and the relevance of certifications.

The PL-200 exam is a good example of the new type of certification testing for certain job roles. The following sections explain the roles and their impacts on the questions in the certification exams.

Job roles

Previously, questions in Microsoft exams were about the features of the Microsoft product that a given exam covers. This often meant that you had to learn about functionalities or capabilities that you never used, and would never use, just to pass the exam.

Microsoft has changed to certifications that revolve around the day-to-day tasks of certain job roles. Microsoft consulted widely to define several job roles and the certifications around those roles across the following core solutions areas: Cloud, Modern Workplace, Data and AI, and Business Applications.

You can see the full list of job roles at http://aka.ms/TrainCertPoster.

There are certifications for each role, with each role certification requiring one or, sometimes, two exams.

Questions in the role-based exams are written to test your day-to-day skills instead of testing your memory.

Exam questions

The migration from product-based to role-based certifications has affected the way exam questions are written. The following diagram represents the levels of complexity in learning. These exams used to concentrate on remembering and understanding. They now focus on evaluating, analyzing, and applying knowledge:

Figure 1.1 Bloom's taxonomy representing the complexity levels in learning

An effective way to understand these changes is that questions are now about the why and the how, not the what; that is, a question may test you on how to implement a feature, and not on what needs to be implemented.

You'll find some tips and tricks to help you toward the end of the book, in the Tips and Tricks section. This will provide you with tips for taking the exam, as well as two sets of practice test questions to help you prepare.

To find out more about role-based certification, you can visit http://aka.ms/rolebasedcerts.

Question types

Along with the change to role-based certification, the exams themselves have evolved; there are many new question types. If you have taken older Microsoft exams, you may have just experienced multiple-choice questions.

In role-based exams, you can expect to see question types that are more interactive, such as the following, for example:

  • Active screen
  • Build list
  • Case study
  • Drag and drop
  • Graphic interpretation
  • Multi-source reasoning

The introduction of these exam item types has made exams both easier and harder at the same time. Easier, because you no longer need to remember arcane facts, or learn about things you will never use. Harder, because you can't just read and remember; you must be familiar with the Power Platform and have performed the actions that the questions refer to.

Don't worry, we have relevant exercises to help you.

To learn more about the different question types in use, watch the videos at https://docs.microsoft.com/learn/certifications/certification-exams#exam-formats-and-question-types.

Performance-based testing

Performance-Based Testing (PBT) is being introduced to some exams. In this form of testing, you are presented with a system in a controlled browser lab-type environment and are given a set of tasks to perform.

PBT makes it even more important for you to be familiar with and comfortable using the Power Platform.

I have written more about PBT at https://community.dynamics.com/365/b/dynamicscrmukmct/posts/performance-based-testing. You can get some more information on PBT there.

Now that we have outlined the changes to role-based certification, we will now look at the roles relevant to the PL-200 exam.

Introducing Power Platform and Dynamics 365 roles

With the emergence of the Power Platform, Microsoft has sought to distinguish between the functionality of the Dynamics 365 apps and the underlying features of the Power Platform.

There are several roles covering both Dynamics 365 and the Power Platform. The PL-200 exam contributes to several of the Dynamics 365 roles.

Dynamics 365 and Power Platform roles

This section will explore the roles for Dynamics 365 model-driven apps that are relevant to the PL-200 exam, and the impact of these roles on candidates. 

The Dynamics 365 and Power Platform roles are as follows:

  • Power Platform App Maker
  • Power Platform Functional Consultant
  • Power Platform Developer 
  • Data Analyst Associate
  • Dynamics 365 Functional Consultant
  • Dynamics 365 + Power Platform Solutions Architect

For each of these roles, one or more exams have been created.

The PL-200 exam is required for the Power Platform Functional Consultant role and is one of the two exams that is required for the Dynamics 365 Functional Consultant role. The PL-200 exam is required for the Solutions Architect role, but the true focus for the exam is the Functional Consultant rolewhich we will talk about next. We will cover more on the PL-200 exam later in this chapter, in the Exploring the PL-200 exam and its objectives section.

The Functional Consultant role

The Functional Consultant role covers many job titles including business analyst, application specialist, and applications consultant. The key denominator here is the gathering of requirements from users and turning those requirements into solutions based on Dynamics 365 or the Power Platform. A functional consultant leverages Microsoft Dynamics 365 and the Power Platform to meet customer needs.

A functional consultant is not a developer; instead, they use the out-of-the-box tools and customization capabilities provided by Microsoft to deliver solutions. Microsoft refers to such capabilities as low code/no code.

Let's start with the definition of a functional consultant.

Role definition

A Power Platform Functional Consultant is responsible for capturing and documenting user requirements and turning those requirements into a working system. The Functional Consultant role implements a solution using the out-of-the-box capabilities provided by Microsoft. 

The key activities for the Functional Consultant role are listed next.

Key role activities

The role of a Dynamics 365/Power Platform Functional Consultant is to do the following:

  • Gather and document requirements from users.
  • Identify where and how Dynamics 365 and Power Platform can be used to meet those requirements.
  • Design the solution, in collaboration with the solutions architect.
  • Implement the design.
  • Follow standards.
  • Ensure that the solution meets both functional and non-functional requirements.
  • Perform testing of any configured artifacts.
  • Collaborate with the quality assurance team to ensure that the system operates correctly.
  • Package artifacts for deployment.
  • Provide training to Dynamics 365/Power Platform administrators.

A functional consultant will have experience in delivering systems based on Dynamics 365 and/or the Power Platform. 

Required experience 

The experience expectations for a Dynamics 365/Power Platform Functional Consultant are as follows:

  • Must have experience of the full life cycle of Dynamics 365/Power Platform systems from requirements, through design and implementation, to ongoing support and upgrades
  • Must understand the features and capabilities of each of the Dynamics 365 apps
  • Must have a broad knowledge of the Power Platform, understanding its capabilities, boundaries, and constraints
  • Must be able to customize and configure Dynamics 365 and the Power Platform
  • Must be able to apply their knowledge of customization and configuration to meet customer needs
  • Should have a basic understanding of solutions architecture and quality assurance
  • Should understand the extensibility capabilities of Dynamics 365 and the Power Platform 
  • Must have experience in configuring entities, fields, and relationships; customizing forms and views; customizing charts and dashboards; configuring the security model; configuring processes; managing solutions and instances; and configuring for mobile devices
  • Must have experience of integrating with other applications and services
  • Must effectively communicate with members of the delivery team, stakeholders, and customers

There is not a single functional consultant role, but separate roles for each of the main Dynamics 365 apps, and also for the Power Platform.

Functional Consultant roles

Microsoft has created Functional Consultant job roles for each of the main Dynamics 365 model-driven first-party apps. There are five functional consultant roles:

  • Power Platform Functional Consultant Associate
  • Dynamics 365 Sales Functional Consultant Associate
  • Dynamics 365 Customer Service Functional Consultant Associate
  • Dynamics 365 Field Service Functional Consultant Associate
  • Dynamics 365 Marketing Functional Consultant Associate

The PL-200 exam is a prerequisite for each of these role certifications, and for other role-based certifications. 

Exploring the PL-200 exam and its objectives

PL-200 is the base exam required for any functional consultant, and it demonstrates their ability to configure, customize, and deploy solutions to meet customer requirements. As such, PL-200 is at the core of a functional consultant's day-to-day job.

While PL-200 is aimed at functional consultants, others involved in Dynamics 365 and Power Platform systems, such as testers, support staff, developers, administrators, and solutions architects, should consider taking the PL-200 exam as it covers many of their core day-to-day skills.

For PL-200, although you need to be aware of the first-party apps (Sales, Customer Service, Field Service, and Marketing), you don't need to have detailed knowledge about the features and functionality of each of the apps. The exam is more about the underlying platform for Dynamics 365, that is, the Power Platform and the Common Data Service.

This exam covers the skills around configuring, customizing, and deploying the platform to meet user needs and completing design tasks that relate to implementing new features and functionalities.

The following sections explore these tasks and the skills required. 

At the time of publishing, Microsoft Dataverse (formerly known as the Common Data Service) was undergoing a branding change. Along with the name change, there are several changes to terminology such as tables (formerly entities), columns (formerly fields), rows (formerly records), choices (formerly option sets), and yes/no (formerly two options). These changes have not yet been applied to the exam. You should be prepared to see the former terms in the exam.

Skills measured

The exam tests a series of skills. These skills are referred to as the exam's objective domain.

Being familiar with the objective domain is important to candidates for the exam. You won't see questions on all the skills listed, as the questions in a given exam are randomized from a pool of questions, and you might see questions that aren't listed as some of the skills are vague and/or could be interpreted in different ways. However, making sure you have covered everything in the objective domain will give you a much better chance of passing the exam.

The objective domain is broad, with a lot of separate topics listed. If you have taken older product-orientated exams, this might seem daunting. But for these role-based exams, you don't need to learn all the facts about each item as you had to do previously.

The way the questions are written for PL-200 provides a good test of your skills. If you use the Power Platform on a day-to-day basis, you should, by following this guide, be much better placed to pass the exam.

There are various skills measured in the objective domain for PL-200. We will discuss them in the following sections.

You should always check the exam page (https://docs.microsoft.com/learn/certifications/exams/pl-200before taking the exam in case Microsoft has made any changes to the objective domain.

Configure the Common Data Service (25–30%)

This part of the exam is all about the Common Data Service, extending the data model, and moving data into and out of the database:

  • Manage an existing data model: These are the core skills around data modeling, which is the starting point for any Power Platform app; that is, entities, fields, and relationships.
  • Create and manage processes: Processes are a major part of any system based on model-driven apps and the skills in this section are about understanding, configuring, and applying each of these types of processes: business rules, business process flows, and classic workflows.
  • Configure Common Data Service settings: Several items must be configured when creating environments, such as using audit and search. This section is about a set of administration topics and you need to know how to enable and configure these settings.
  • Configure security settings: You must have an understanding of the security features in the Common Data Service and how to configure and apply them.

Create apps by using Power Apps (20–25%)

This part of the exam is all about creating Power Apps on the Common Data Service:

  • Create model-driven apps: This section of the exam covers customizing the user interface in the Common Data Service and creating model-driven apps.
  • Create canvas apps: This section of the exam is all about creating and managing canvas apps.
  • Create portal apps: You need to know about portal apps; specifically, how to deploy and configure portal apps.

Create and manage Power Automate (15–20%)

This part of the exam is focused on the capabilities of Power Automate:

  • Create flows: You will need to understand the components that make up a flow and how to create flows for the Common Data Service.
  • Create and manage business process flows: This section of the exam is about creating and editing business process flows and using business process flows with other forms of automation.
  • Build UI flows: This set of skills involves building web and desktop robotic process automation flows.

Implement Power Virtual Agents chatbots (10–15%)

This part of the exam is about creating chatbots with Power Virtual Agents:

  • Create a chatbot: This covers the set of skills necessary for creating chatbots and deploying the chatbots to channels.
  • Configure topics: You need to understand how topics are used in chatbots and how to add greetings and conversation triggers.
  • Configure entities: You need to understand the built-in entities and how to create custom entities for use in chatbots.

Integrate Power Apps with other apps and services (15–20%)

This part of the exam is about using the apps you build with other components in the Power Platform and with Microsoft Teams:

  • Integrate Power BI with Power Apps: This covers the skills required to create Power BI reports and dashboards, and then embed Power BI tiles in Power Apps and embed Power Apps in Power BI dashboards.
  • Implement AI Builder: You need to understand the capabilities of AI Builder and be able to create an AI model that you can use with Power Apps and Power Automate flows.
  • Integrate Power Apps with Microsoft 365: This set of skills requires understanding the different capabilities of Word, Excel, and Outlook templates, and how to create each of these templates. You need to be able to add a power app to Microsoft Teams.

This last set of skills brings us to the end of this objective domain.

Before we conclude the chapter, let's also have a look at other exams that might interest you.

Related exams

There are several exams for Dynamics 365 and the Power Platform. Let's discuss them briefly:

  • MB-901: Dynamics 365 Fundamentals: If you are new to Dynamics 365, you should take this exam before you attempt PL-200. This exam introduces you to some of the concepts in Dynamics 365. PL-200 assumes some familiarity with Dynamics 365 model-driven apps.
  • PL-900: Power Platform Fundamentals: If you are new to the Power Platform, you should take this exam before you attempt PL-200. This is for many reasons—it introduces you to the components of the Power Platform; and PL-200 assumes a certain level of knowledge. This exam gives you vital exam experience so that when you come to take PL-200, you will know how the questions work.
  • PL-100: Power Platform App Maker: This exam covers many of the same topics as PL-200 but is aimed more at the citizen developer, that is, a person who creates apps for themselves or their colleagues as part of their job. PL-200 is aimed more at the IT professional whose job is to build solutions with the Power Platform. If you have only built a couple of apps, the PL-100 exam is a more appropriate exam.
  • MB-210: Dynamics 365 Sales: PL-200 and MB-210 complement each other, the former focusing on out-of-the-box application functionality and the other on customizing and deploying the apps.
  • MB-220: Dynamics 365 Marketing: The Marketing exam focuses on using, configuring, and administering the Marketing application. Marketing is a complex application built for B2B marketing and is often implemented alongside the Sales app.
  • MB-230: Dynamics 365 Customer Service: The Customer Service exam focuses on using, configuring, and administering the Customer Service application. PL-200 and MB-230 complement each other, with the former focusing on out-of-the-box application functionality and the other on customizing and deploying the app.
  • MB-240: Dynamics 365 Field Service: The Field Service exam focuses on configuring and administering the Field Service application. Field Service is a complex application that requires significant domain-level knowledge. Field Service can be implemented on its own or along with the Sales or Customer Service apps.
  • PL-400: Power Platform Developer: The PL-400 exam is aimed at the developer role and is for candidates who are extending the Power Platform. The PL-400 exam is not a prerequisite for the developer certification but there are many areas in PL-200 that a developer needs to know. There are overlaps in the topics covered by these two exams; for example, creating entities, fields, and relationships; security; and processes. I believe a good developer should have many of the skills tested in PL-200 and should attempt PL-200 before taking PL-400.
  • MB-600: Power Apps + Dynamics 365 Solutions Architect: The MB-600 is aimed at the Solutions Architect role. A solutions architect is responsible for leading implementations, addressing the broader business and technical needs of the organization. The PL-200 exam is a prerequisite for the Solutions Architect Expert certification.

You can find more about each respective exam at the following URLs:

As you can see, each of these exams relates to the PL-200 exam.

Summary

In this chapter, we learned about role-based certifications, the Functional Consultant role, and the purpose and content of the PL-200 exam. The exam is aimed to cover the day-to-day tasks and skills of someone who creates systems based on the Power Platform from the start of a project to its completion.

You now understand the scope of the exam and the knowledge and skills that will be tested in the PL-200 exam.

The next chapter is a high-level overview of the Power Platform. This is a piece of important and fundamental knowledge for the remainder of this book and the exam.

Questions

After reading this chapter, test your knowledge with these questions. You will find the answers to these questions in the Assessments chapter at the end of the book:

      1. The role of a Dynamics 365 Functional Consultant is restricted to customizing Dynamics 365 apps. True or false?

      A) True
      B) False

      1. The role of a Power Platform Functional Consultant includes extending the Power Platform. True or false?

      A) True
      B) False

      1. The PL-200 exam contains only multiple-choice questions. True or false?

      A) True
      B) False

      1. The PL-200 exam is required for which of the following roles? (Choose two)

      A) Dynamics 365 Functional Consultant
      B) Power Platform Developer
      C) Power Platform and Dynamics 365 Solutions Architect
      D) Data Analyst
      E) App Maker

      1. At what level of complexity are the questions in the MB-200 exam?

      A) Understanding
      B) Remembering
      C) Applying
      D) Creating

      Further reading

      Left arrow icon Right arrow icon

      Key benefits

      • Learn effectively with the help of self-assessment questions, mock tests, and detailed explanations in this up-to-date study guide
      • Address the challenges faced by a functional consultant in day-to-day activities
      • Understand how to configure, customize, and implement solutions based on Power Platform

      Description

      The Power Platform Functional Consultant Associate (PL-200) exam tests and validates the practical skills of Power Platform users who are proficient in developing solutions by combining the tools in Power Platform and the Microsoft 365 ecosystem based on business needs. This certification guide offers complete, up-to-date coverage of the PL-200 exam so you can prepare effectively for the exam. Written in a clear, succinct way with self-assessment questions, exam tips, and mock exams with detailed explanations of solutions, this book covers common day-to-day activities involved in configuring Power Platform, such as managing entities, creating apps, implementing security, and managing system change. You'll also explore the role of a functional consultant in creating a data model in the Microsoft Dataverse (formerly Common Data Service). Moving ahead, you'll learn how to design the user experience and even build model-driven and canvas apps. As you progress, the book will show you how to manage automation and create chatbots. Finally, you'll understand how to display your data with Power BI and integrate Power Platform with Microsoft 365 and Microsoft Teams. By the end of this book, you'll be well-versed with the essential concepts and techniques required to prepare for the PL-200 certification exam.

      Who is this book for?

      This book is for functional consultants and business analysts who are involved in implementing solutions based on Power Platform or Dynamics 365. As the PL-200 exam is a pre-requisite for other role-based certifications in Power Platform and Microsoft Dynamics 365, individuals pursuing their careers in these domains will also find this book helpful. Basic knowledge of Power Platform and access to a Power Platform environment are required to get started with this book.

      What you will learn

      • Understand how to build apps that meet customer needs
      • Extend the schema for Dataverse with entities, fields, and relationships
      • Create and configure automations to simplify user activities
      • Explore various security features in Power Platform and learn how to implement them
      • Use multiple data sources to create task- or role-based web and mobile applications for users
      • Automate business processes and enhance the user experience with Power Automate and UI Flows
      • Integrate various applications within the Microsoft ecosystem with Power Platform
      Estimated delivery fee Deliver to Malta

      Premium delivery 7 - 10 business days

      €32.95
      (Includes tracking information)

      Product Details

      Country selected
      Publication date, Length, Edition, Language, ISBN-13
      Publication date : Dec 04, 2020
      Length: 648 pages
      Edition : 1st
      Language : English
      ISBN-13 : 9781838985684
      Vendor :
      Microsoft

      What do you get with Print?

      Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
      Product feature icon Paperback book shipped to your preferred address
      Product feature icon Download this book in EPUB and PDF formats
      Product feature icon Access this title in our online reader with advanced features
      Product feature icon DRM FREE - Read whenever, wherever and however you want
      Product feature icon AI Assistant (beta) to help accelerate your learning
      OR
      Modal Close icon
      Payment Processing...
      tick Completed

      Shipping Address

      Billing Address

      Shipping Methods
      Estimated delivery fee Deliver to Malta

      Premium delivery 7 - 10 business days

      €32.95
      (Includes tracking information)

      Product Details

      Publication date : Dec 04, 2020
      Length: 648 pages
      Edition : 1st
      Language : English
      ISBN-13 : 9781838985684
      Vendor :
      Microsoft

      Packt Subscriptions

      See our plans and pricing
      Modal Close icon
      €18.99 billed monthly
      Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
      Feature tick icon Constantly refreshed with 50+ new titles a month
      Feature tick icon Exclusive Early access to books as they're written
      Feature tick icon Solve problems while you work with advanced search and reference features
      Feature tick icon Offline reading on the mobile app
      Feature tick icon Simple pricing, no contract
      €189.99 billed annually
      Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
      Feature tick icon Constantly refreshed with 50+ new titles a month
      Feature tick icon Exclusive Early access to books as they're written
      Feature tick icon Solve problems while you work with advanced search and reference features
      Feature tick icon Offline reading on the mobile app
      Feature tick icon Choose a DRM-free eBook or Video every month to keep
      Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
      Feature tick icon Exclusive print discounts
      €264.99 billed in 18 months
      Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
      Feature tick icon Constantly refreshed with 50+ new titles a month
      Feature tick icon Exclusive Early access to books as they're written
      Feature tick icon Solve problems while you work with advanced search and reference features
      Feature tick icon Offline reading on the mobile app
      Feature tick icon Choose a DRM-free eBook or Video every month to keep
      Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
      Feature tick icon Exclusive print discounts

      Frequently bought together


      Stars icon
      Total 145.97
      Microsoft Power Platform Functional Consultant: PL-200 Exam Guide
      €43.99
      Microsoft Power Platform Enterprise Architecture
      €59.99
      Workflow Automation with Microsoft Power Automate
      €41.99
      Total 145.97 Stars icon
      Banner background image

      Table of Contents

      33 Chapters
      Section 1: Introduction Chevron down icon Chevron up icon
      PL-200 Exam Chevron down icon Chevron up icon
      Section 2: Microsoft Dataverse Chevron down icon Chevron up icon
      Power Platform Chevron down icon Chevron up icon
      Data Modeling Chevron down icon Chevron up icon
      Business Rules Chevron down icon Chevron up icon
      Classic Workflows Chevron down icon Chevron up icon
      Managing Data Chevron down icon Chevron up icon
      Dataverse Settings Chevron down icon Chevron up icon
      Security Chevron down icon Chevron up icon
      Section 3: Power Apps Chevron down icon Chevron up icon
      Model-Driven Apps Chevron down icon Chevron up icon
      Canvas Apps Chevron down icon Chevron up icon
      Portal Apps Chevron down icon Chevron up icon
      Section 4: Automation Chevron down icon Chevron up icon
      Power Automate Flows Chevron down icon Chevron up icon
      Business Process Flows Chevron down icon Chevron up icon
      UI Flows Chevron down icon Chevron up icon
      Section 5: Power Virtual Agents Chevron down icon Chevron up icon
      Creating Chatbots Chevron down icon Chevron up icon
      Configuring Chatbots Chevron down icon Chevron up icon
      Section 6: Integrations Chevron down icon Chevron up icon
      Power BI Chevron down icon Chevron up icon
      AI Builder Chevron down icon Chevron up icon
      Microsoft 365 Integration Chevron down icon Chevron up icon
      Application Life Cycle Management Chevron down icon Chevron up icon
      Tips and Tricks Chevron down icon Chevron up icon
      Practice Test 1 Chevron down icon Chevron up icon
      Answers to Practice Test 1 Chevron down icon Chevron up icon
      Practice Test 2 Chevron down icon Chevron up icon
      Answers to Practice Test 2 Chevron down icon Chevron up icon
      Assessments Chevron down icon Chevron up icon
      Other Books You May Enjoy Chevron down icon Chevron up icon

      Customer reviews

      Top Reviews
      Rating distribution
      Full star icon Full star icon Full star icon Full star icon Half star icon 4.6
      (16 Ratings)
      5 star 75%
      4 star 12.5%
      3 star 6.3%
      2 star 6.3%
      1 star 0%
      Filter icon Filter
      Top Reviews

      Filter reviews by




      JRW May 31, 2021
      Full star icon Full star icon Full star icon Full star icon Full star icon 5
      First off, it is a monster of a book at 611 pages. Julian Sharp has done a masterful job of providing a broad overview and dive into the topic areas and the skills you need to know to be able to sum up the courage to take the PL-200 Exam. Understand no one book or a reading of one book is going to get you a passing grade on a Microsoft exam. It takes time, energy and effort to become sufficiently proficient to pass the exam. But what this book will do for you is to identify all the topic areas, provide you with a good foundation of the core information you need on the topic and give you some exercises to practice. From there you will be able to work on building your skills, experimenting with the features so that you can become thoroughly experienced to answer the broad range of questions on the exam.In the book Julian not only explains where to click, he explains why and what happens next and alternative approaches.I found the text surprisingly easy to read and the examples straight forward to apply.
      Amazon Verified review Amazon
      Thomas Rice Oct 18, 2021
      Full star icon Full star icon Full star icon Full star icon Full star icon 5
      This is one of the best book purchases I have made, I have passed 9 Microsoft exams. This book alone helped me prepare and pass PL-200. This is more than just an exam prep book, this is essentially the cookbook for Microsoft Power Platform so I have referred back to it a couple of times already. If you want to pass PL-200, this is the book to have in your personal library.
      Amazon Verified review Amazon
      James M. Novak Mar 24, 2021
      Full star icon Full star icon Full star icon Full star icon Full star icon 5
      This is an exam guide and it provides excellent content for those preparing for their certification. But this book also provides learning content for those who are relatively new to the platform. Each chapter provides an overview into Power Platform tools and capabilities and chapter end questions do a great job testing your understanding
      Amazon Verified review Amazon
      G Jul 09, 2021
      Full star icon Full star icon Full star icon Full star icon Full star icon 5
      Great book for studying PL 200
      Amazon Verified review Amazon
      Mark D. Slosberg Apr 05, 2021
      Full star icon Full star icon Full star icon Full star icon Full star icon 5
      As a “self-taught”, practicing, professional Power Platform developer who now fashions himself as a bit of an expert, particularly in Power Apps Canvas apps and Automate, this volume is a very nice addition to my library. It is quite comprehensive, and given the rapid evolution of the platform, surprisingly up to date.Given that I don’t actually plan on taking the exam it prepares you for, the breadth and depth of the content is excellent. I wish that I had had this volume available while I was “self-teaching” myself as it frames up the, for example, different approaches to UI/UX development (Model-driven vs. Canvas vs. Portal) and Classic Workflows vs Power Automate nicely although I would have like a little more discussion about when to use which approach.While I don’t expect to get heavily involved in Model-driven apps, I would like to, at least, be able to build simple ones or know how to evaluate the work of someone I might hire. And for Portal apps, I am on the verge of building a few for a customer, and will try to use the content to help me get at it quicker. I am sorry that there isn’t more of the “hard-knocks” (meaning of course, all of the undocumented weirdness that comes with this evolving Microsoft platform) learning that I am sure is in front of me based on my extensive Canvas App and Cloud Flow experience.If I have any gripes about the book, I excuse them because it is a book that “teaches to the test”. As we all know in real life education, this approach does not fully prepare you for the kinds of problems you will actually encounter when you try to use the material in the book in a real situation. It focuses on things that might be outdated like Classic Workflows (and to some extent Model-driven Apps) that you are likely to encounter if you are part of a Dynamics365 implementation but probably won’t spend too much time on if the client doesn’t have those products. Surprisingly, it doesn’t do much of anything around PowerApps as a replacement for InfoPath in SharePoint where I have found the current online communities “overfocused” so I don’t miss it but it is a notable omission.It has the best review of Dataverse/CDS including the underlying Security Model that I have encountered so far. Again very good if you are working with D365 and in my case developing something new where I don’t want to be spending too much time developing using either the simplistic Excel data backends, SharePoint Lists, or the heavy and more complex SQL backends. At the same time, I do feel it is very light on connecting to existing SQL backend data stores, that “heavy or not”, you are very likely to find as your most common backend data store. I think a stronger emphasis on tying together CDS, SQL and web service backend data using JSON into an integrated, practical but mite complex data environment would have been valuable however, as I said “since that isn’t in the test, why teach it”.Similarly, while the Security Model coverage is excellent, in my case, for instance, since my primary client hasn’t implemented it and doesn’t seem motivated to adopt it, in real-life you must adapt and innovate to use what you can, work around what you can’t and still deliver a secure solution. Again, not on the test.My final thought is that, it presents a lot of material as if the products are real, complete and mature which they are not. UI Flows, Power Virtual Agents, AI Builder and Solutions are the best examples. Again you will be learning what you need to “pass a test” and not actually what you need to be able to use these rapidly changing and evolving functions, features and tools. My experience over the past 18 months is that these things are constantly changing under your feet. Menus and operations can literally change from day to day with little or no warning, and this volume does not do enough to warn you about the differences between “passing the test” and using the products to “deliver solutions to your clients”.All in all though, I highly recommend it as a base textbook if you are preparing yourself or a team to “pass the test”.
      Amazon Verified review Amazon
      Get free access to Packt library with over 7500+ books and video courses for 7 days!
      Start Free Trial

      FAQs

      What is the delivery time and cost of print book? Chevron down icon Chevron up icon

      Shipping Details

      USA:

      '

      Economy: Delivery to most addresses in the US within 10-15 business days

      Premium: Trackable Delivery to most addresses in the US within 3-8 business days

      UK:

      Economy: Delivery to most addresses in the U.K. within 7-9 business days.
      Shipments are not trackable

      Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
      Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

      EU:

      Premium: Trackable delivery to most EU destinations within 4-9 business days.

      Australia:

      Economy: Can deliver to P. O. Boxes and private residences.
      Trackable service with delivery to addresses in Australia only.
      Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
      Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

      Premium: Delivery to addresses in Australia only
      Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

      India:

      Premium: Delivery to most Indian addresses within 5-6 business days

      Rest of the World:

      Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

      Asia:

      Premium: Delivery to most Asian addresses within 5-9 business days

      Disclaimer:
      All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


      Unfortunately, due to several restrictions, we are unable to ship to the following countries:

      1. Afghanistan
      2. American Samoa
      3. Belarus
      4. Brunei Darussalam
      5. Central African Republic
      6. The Democratic Republic of Congo
      7. Eritrea
      8. Guinea-bissau
      9. Iran
      10. Lebanon
      11. Libiya Arab Jamahriya
      12. Somalia
      13. Sudan
      14. Russian Federation
      15. Syrian Arab Republic
      16. Ukraine
      17. Venezuela
      What is custom duty/charge? Chevron down icon Chevron up icon

      Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

      Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

      The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

      List of EU27 countries: www.gov.uk/eu-eea:

      A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

      How do I know my custom duty charges? Chevron down icon Chevron up icon

      The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

      For example:

      • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
      • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
      How can I cancel my order? Chevron down icon Chevron up icon

      Cancellation Policy for Published Printed Books:

      You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

      Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

      What is your returns and refunds policy? Chevron down icon Chevron up icon

      Return Policy:

      We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

      1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
      2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
      3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
      4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
      5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
      6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

      On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

      What tax is charged? Chevron down icon Chevron up icon

      Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

      What payment methods can I use? Chevron down icon Chevron up icon

      You can pay with the following card types:

      1. Visa Debit
      2. Visa Credit
      3. MasterCard
      4. PayPal
      What is the delivery time and cost of print books? Chevron down icon Chevron up icon

      Shipping Details

      USA:

      '

      Economy: Delivery to most addresses in the US within 10-15 business days

      Premium: Trackable Delivery to most addresses in the US within 3-8 business days

      UK:

      Economy: Delivery to most addresses in the U.K. within 7-9 business days.
      Shipments are not trackable

      Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
      Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

      EU:

      Premium: Trackable delivery to most EU destinations within 4-9 business days.

      Australia:

      Economy: Can deliver to P. O. Boxes and private residences.
      Trackable service with delivery to addresses in Australia only.
      Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
      Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

      Premium: Delivery to addresses in Australia only
      Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

      India:

      Premium: Delivery to most Indian addresses within 5-6 business days

      Rest of the World:

      Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

      Asia:

      Premium: Delivery to most Asian addresses within 5-9 business days

      Disclaimer:
      All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


      Unfortunately, due to several restrictions, we are unable to ship to the following countries:

      1. Afghanistan
      2. American Samoa
      3. Belarus
      4. Brunei Darussalam
      5. Central African Republic
      6. The Democratic Republic of Congo
      7. Eritrea
      8. Guinea-bissau
      9. Iran
      10. Lebanon
      11. Libiya Arab Jamahriya
      12. Somalia
      13. Sudan
      14. Russian Federation
      15. Syrian Arab Republic
      16. Ukraine
      17. Venezuela