Microsoft Power Platform Functional Consultant (PL-200)

Explore Power Apps licensing, compare per user, per app, and pay-as-you-go plans; learn how developer and standalone licenses enable development and testing with connectors.

Sign up for the Power Apps developer plan to access a development and testing environment with Power Apps, Power Automate, and Dataverse, and share apps with teammates.

Explore how environments in the Power Platform store and share data, apps, and flows, and learn to create and manage them in the admin center with various types and licensing.

Install a Dataverse database for your environment—cloud-based open data model (formerly CDS)—with secure role and field-level controls, and set up sample data via the portal or admin center.

Create a canvas app from a template and from a blank canvas using the accounts table in Dataverse. Build three screens (browse, detail, edit) and add controls.

Build a canvas app from blank by selecting a phone-size canvas and adding data sources and connectors. Connect accounts data from Microsoft Dataverse and prepare to populate the first screen.

Insert and configure a gallery in a phone canvas app to display data from a data source, and customize layout with title, subtitle, body, and images.

Explore formatting the label component in a gallery, including literal text and item-based formulas, referencing account name, and adjusting font, color, alignment, and visibility with replicated item behavior.

Create second screen with a single-record form from accounts data source, arrange fields such as address, country, email, and phone, and navigate between browse and detail screens via dot selected.

Learn how Power Apps formulas differ by locale, covering navigate function and how dot, comma, semicolon, and two semicolons delimit arguments across English and non-English settings.

Create an edit screen linked to the browse screen, using an edit form to modify account fields, submit or reset the form, and navigate back on success.

Expand the accounts app by adding an expenses table linked to accounts, define entities, fields, and relationships, and design a high-level data model and user experience for managing expenses.

Design the data model by defining the accounts table with id, primary name column, city; in Dataverse, add an expenses table to model one-to-many relationships with a lookup.

Create a Dataverse table from the data model, exploring standard, custom, activity, and virtual or complex tables, with ownership, display name, id, and offline options.

Learn to extend a Dataverse table by adding diverse columns, including text, text area, email, url, phone, currency, date, and image types, with choice-based approvals and security options.

Configure the expense table with an auto number ID using a string prefix and leading zeros for unique, sortable identifiers, and establish single or compound keys to ensure uniqueness.

Link accounts and expenses with Dataverse relationships, choosing one-to-many or many-to-one, and configure cascade or restrict rules to avoid orphaned lookup; explore advanced options and the solution explorer.

Create calculated columns that derive dates and values from this and related tables using add, subtract, diff, concat, and trim formulas, with updates on save and a five-level chaining limit.

Configure roll-up columns to summarize related data across tables, such as total expenses by account using a currency type and sum aggregation. Understand scheduled and incremental roll-up calculations and filters.

Learn to import Excel data into a new Dataverse table, handling multiple spreadsheets, supported file types (xlsx, xls, xlsb, csv), and asynchronous loading to load thousands of rows.

Import additional Excel data into an existing table by uploading the file, mapping columns, and resolving mapping errors, using Power Query to load into a new or existing table.

Explore two editing options, edit in place and edit in Excel via the Power Apps add-in, and exporting options, static CSV export and interactive Excel export that publishes to Dataverse.

Add expenses screens to the accounts app by duplicating the browse, detail, and edit screens and connecting them to a new expenses data source.

Build and connect a device gallery and edit form in PowerApps, enabling adding, editing, and viewing device name, type, status, and serial.

Link the expenses and accounts screens using the filter function to display only expenses for the selected account, enabling navigation from the account browse screen to the expense browse screen.

Link user screens to device screens by adding navigation, selecting the user from the gallery, and updating forms to attach a user field to new devices, enabling focused device views.

Add a menu screen with buttons to view accounts or expenses. Use the set function to implement a global variable that toggles between a single account view and all expenses.

Add a sort icon using update context to toggle ascending and descending on a single screen, and understand how context updates differ from global set operations.

Demonstrates adding a picture control linked to the device image column, building a main menu with see all users and see all devices, and configuring a variable to toggle views.

Create a basic running total calculator on a new screen with a text input and add button. Use a context variable to update the total and reset on visible.

Create a reusable calculator component in Power Apps, turning controls into a standalone component and using on reset events to manage total while the component remains a black box.

Explore how to feed data into and retrieve results from a component using input and output custom properties, set an initial value, handle on reset, and observe instance-scoped totals.

Add images, audio, and video to canvas Power Apps, then configure controls, auto start, loop, and start time. Switch media with a variable and support mp3 and wav formats.

Explore the wide range of Power Apps controls, including text, input, media, and charts. Learn how gallery, data table, forms, and geospatial features powered by TomTom enable interactive, data-driven apps.

Explore canvas app formulas essential for the PL100 exam in the Power Apps landscape, covering navigate, update context, collections, and key functions such as count, if, patch.

Explore how design choices impact canvas app performance and interpret App Checker results, including errors, warnings, and suggestions, to optimize loading, delegation, and data handling.

Save edits to preserve changes, then publish to make the latest version live for all users. Manage versions in Power Apps by saving, restoring as a new version, and publishing.