Book Image

Microsoft Power Platform Functional Consultant: PL-200 Exam Guide

By : Julian Sharp
Book Image

Microsoft Power Platform Functional Consultant: PL-200 Exam Guide

By: Julian Sharp

Overview of this book

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.
Table of Contents (34 chapters)
1
Section 1: Introduction
3
Section 2: Microsoft Dataverse
11
Section 3: Power Apps
15
Section 4: Automation
19
Section 5: Power Virtual Agents
22
Section 6: Integrations

Understanding integration with SharePoint

Handling documents is a common requirement when creating solutions with the Power Platform. You can add documents directly to the Common Data Service or you can use SharePoint as your document store. 

Model-driven apps can upload and attach files to records using Notes. There are some issues with using Notes for document management:

  • Files are stored in the Common Data Service and use precious storage capacity.
  • There is no capability to open an attached file, edit it, and save it back to the app – you must save it locally and upload it again.
  • There are no features such as check-out/check-in.
  • There is no version control.

Microsoft provides the ability to integrate the Common Data Service with SharePoint. With SharePoint integration, a document library is created for each record where the entity is enabled for Document Management.

Using SharePoint for managing documents in model-driven apps provides the following benefits:

  • Enables...