PL-900 prep: Microsoft Power Platform Fundamentals

Compare canvas apps and model-driven apps, distinguish portal apps and data-first Dataverse designs, and explore forms, views, dashboards, and integration in Power Apps.

Sign up for Power Apps by starting a free account with a work email, verify your identity, and explore the Power Platform and its connectors.

Explain why sign-in requires a work email for Power Platform and show how to obtain a free work email via a Microsoft 365 business trial, with verification tips.

Create a new Power Apps environment with a Dataverse database and sample data, then build a canvas app from the accounts table with browse, detail, and edit screens.

Explore environments in the Power Platform using the admin center to create databases, apps, flows, and Power Pages, and learn how regions and governance shape production and development work.

Discover how the Dataverse, the Power Platform’s database, powers apps, Power Automate workflows, and reports by enabling canvas apps from data tables like contacts and integrating with Power BI.

Discover Dataverse tables, formerly entities, with their rows and columns, including standard, custom, activity, and complex types. Understand ownership and security, and how organisation, user, or team permissions govern access.

Explore how entities describe people, places, and things with rows, columns, and fields of various data types, and how one-to-many, many-to-one, and many-to-many relationships connect them.

Compare Dataverse to an ordinary database, noting similarities in tables and rows, with its cloud, secure management, and integration with Power Apps, Dynamics 365, and Power BI.

Explore how solutions package and transport apps and components across environments. Learn about unmanaged and managed solutions, export/import processes, and the role of the default and Dataverse components.

Explore how business rules enforce data integrity at data layer in Dataverse, applying logic across Power Apps and Power Automate to validate data, set field values, and show error messages.

Explore real-time workflows and actions in the Power Platform, attaching workflows to tables, and using actions to emit messages linked to external plugins with input/output variables for immediate results.

Build a basic canvas app using templates and multiple data sources, and learn to access templates via the apps section, choosing blank canvas or prebuilt templates to accelerate development.

Learn to connect data to your canvas app using standard and premium connectors, and understand licensing: Office 365 versus Power Apps subscriptions.

Create a data-centered canvas app from the Dataverse Contacts table, then explore design, preview, and navigation across browse, detail, and edit screens with a gallery, controls, and properties.

Design the user experience by adding screens and controls, adjusting themes, fonts, and alignment, and organizing elements. Preview, save, publish, and manage components with collections, data, and media.

Create and reuse components that package multiple controls, export and import them across apps, and manage updates and libraries, including Power Apps component framework (PCF) for advanced use.

Explore how formulas power the Power Platform to retrieve information, modify control properties, and perform calculations with Excel-like functions and conditional logic.

Publish and share your canvas app by saving, naming, configuring settings, and publishing, then invite users with defined permissions and data access controls to collaborate securely.

Learn how Copilot and generative AI in Power Apps generate tables, canvas apps, and Dataverse structures from plans, using requirements, data, and solution agents to build a comprehensive solution.

Learn to build responsive pages in Power Platform by using drag-and-drop containers and conditional visibility to adapt layouts for phones and tablets.

Learn how model-driven apps use Dataverse data first, with views, forms, dashboards, and charts, and how to modify views by adding columns and sorting tables.

Explore the four form types—main, quick create, quick view, and card—and learn how they enable user interaction with data in Power Platform forms, including canvas apps and Power BI integration.

Explore charts and dashboards in a model-driven app, using standard charts and streams (views) to compose dashboards, such as contacts by account and active contacts.

Create a model-driven app from the contacts table, add an accounts area with a view and form, and organize navigation with groups and areas, then save and publish.

Learn how to import and export Dataverse data with a model-driven app, export to Excel as static or dynamic worksheets and pivot tables, and re-upload edited data.

Publish and share a model-driven app, assign security roles such as system administrator, system customizer, and environment maker, and distribute access via a web url after configuring forms and views.

Explore alternative methods to import and export Dataverse data, including Excel imports, data sources, and creating data flows with Power Query to transform and load data into tables.

Explore Power Automate templates and flow types—instant, automated, and scheduled—using triggers and connectors, with Power Apps integration and examples like saving attachments to OneDrive and sending reminders.

Discover practical Power Automate use cases that connect Microsoft Teams, Outlook, SharePoint, and Forms, from auto emails for team messages to SharePoint item workflows and form submissions.

Create an instant button flow to send reminders and connect to notifications. Edit delays, add parallel branches, and use dynamic content to trigger emails or push alerts.

learn to share a cloud flow with co-owners and run-only users, grant co-owners view history and manage access, and send copies via web or mobile apps.

Create an automated cloud flow in Power Automate that triggers on new email arrival, checks if the body contains 'reminder', and sends an email with the original body.

Schedule a Power Automate flow that runs at intervals, fetches the last 20 emails, appends subjects into a string via apply to each, and emails the results.

Explore flow controls and loops in Power Platform flows, using apply to each, increment variables, and switch versus do until to manage email subject lists and comma placement.

Learn how to create, secure, define, describe, test, and publish a custom connector for Power Apps, starting from GitHub OpenAPI, Postman, or blank, with optional Microsoft certification for public use.

Create an automated cloud flow that triggers on new Dataverse contact and waits for approval. Create a business process flow in the default solution with data and approval stages.

Describe how to use the Power Automate portal and mobile app to create, edit, and monitor flows, explore templates and connectors, and view push notifications on iPhone, iPad, and Android.

Launches and explains Power Automate Desktop, enabling attended and unattended desktop flows on Windows 10 and 11, with recorder to automate apps like Excel, Outlook, SharePoint, websites, and PDFs.

Explore process mining and task mining in Power Automate to map workflows, reveal bottlenecks, and reduce rework. See how Copilot Studio and desktop flows optimize refunds and service delivery.

Use Copilot in Power Automate to generate cloud flows from prompts, creating triggers and actions across Office 365 apps like Outlook and Teams. Modify flows and test notifications.

Provision your first Power Pages portal using templates or blank, choose starter layouts, customize pages and navigation, and preview the site with sign-in and Copilot AI guidance.

Explore Dynamics 365 templates for Power Pages, including customer self-service, employee self-service, partner, and community portals, and see how authentication and features like forums and knowledge management shape user experiences.

Customize a Power Pages portal with the design studio, adding sections, multi-step forms, and a dataverse contact form, while configuring permissions for site visitors, attachments, and previewing the live portal.

Navigate the left pane to manage Power Pages: create and organize pages and subpages with Copilot, adjust themes and permissions, and configure data tables, site visibility, and workflows.

Explore how Copilot in Power Pages creates and refines sites using AI. Generate pages, forms, sections, and color themes, rewrite text, and tailor sites from simple suggestions.

Explore Copilot Studio (formerly Power Virtual Agents) to unlock knowledge from 1500+ data connectors and turn conversations into actions, publishing chatbots across Microsoft 365 apps.

Create and test a Copilot Studio agent in the power platform, configuring name, instructions, and knowledge, and explore prebuilt use cases like safe travels and IT help desk.

Explore AI Builder models in the AI Hub for Power Apps and Power Automate, enabling no-code AI via form processing, object detection, text classification, and more.

Describe document processing in Power Automate using AI Builder's form model to extract fields from invoices and publish the results for use in apps, flows, and dataverse.

Power Platform security centers on role-based access in Dataverse, using security roles to manage users and data loss prevention within environments. It covers Azure Active Directory authentication and single sign-on.

Explore how Azure Active Directory provides authentication and authorization for the Power Platform, using multifactor authentication, conditional access, and role-based access control (RBAC) via IAM.

Manage apps and users and perform admin tasks across the Power Platform, including sharing, security roles, licenses, and environment settings in the Power Platform and Microsoft 365 admin center.

Power Platform DLP policies prevent data loss by classifying connectors as business or non-business, blocking sensitive data from sharing across connectors, and applying rules at environment or tenant level.

Explore how the Power Platform enforces privacy and accessibility guidelines by implementing GDPR protections and TLS security, and using the app checker to improve accessible labels, captions, and input methods.

Learn how Power Platform governance ensures IT compliance with environments, data silos, and access controls, including data loss prevention and conditional access and Dataverse security roles.

Explore how Dynamics 365 apps accelerate Power Platform solutions with Dataverse data storage, while noting the deprecated Dynamics 365 connector and the fin and ops connector for finance and operations.

Explore how the Power Platform connects with Microsoft 365 through data connectors to files, databases, and online services, and integrates with Teams and Automate for application publishing and workflows.

See how Dataverse enables Power Apps, Power Automate, and Power BI to work together, with canvas and model-driven apps embedding visuals and AI Builder.