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)
Section 1: Introduction
Section 2: Microsoft Dataverse
Section 3: Power Apps
Section 4: Automation
Section 5: Power Virtual Agents
Section 6: Integrations

Enabling editable grids

Editable grids allow the user to edit a record in a list without having to open the form for the record. Editable grids are especially useful in subgrids when the user has to perform a set of updates to child records.

Editable grids have the following features:

  • Grouping: Group by a column.
  • Sorting: Sort by any column in the view.
  • Filtering: Users can filter the records in the view.
  • Support for business rules: Business rules can perform actions on the fields in the view.

You do not configure a view to be editable; you configure the component showing the view. You can configure the entity so that views are editable when the entity is selected in the site map, and you can configure subgrids in forms to be editable. You cannot currently configure editable grids in the maker portal. You need to switch to classic.

For an entity, you need to click on the Controls tab for the entity, click on Add Control..., and select Editable Grid, as shown in the following screenshot...