PL-900: Microsoft Power Platform Fundamentals - Comprehensive Fact Sheet¶
Exam Overview¶
PL-900 validates foundational knowledge of Microsoft Power Platform capabilities and business value. This exam is designed for candidates who aspire to improve productivity by understanding Power Platform capabilities, creating simple solutions, and connecting services.
Exam Details: - Duration: 60 minutes - Questions: 40-60 questions - Passing Score: 700/1000 - Cost: $99 USD - Format: Multiple choice, drag-and-drop, case studies - Languages: English, Japanese, Chinese (Simplified), Korean, German, French, Spanish, Portuguese (Brazil), Arabic (Saudi Arabia), Russian, Indonesian (Indonesia), Italian
Core Exam Domains¶
- Describe the business value of Power Platform (15-20%)
- Identify foundational components of Power Platform (15-20%)
- Demonstrate capabilities of Power BI (15-20%)
- Demonstrate capabilities of Power Apps (15-20%)
- Demonstrate capabilities of Power Automate (15-20%)
- Demonstrate capabilities of Power Virtual Agents (10-15%)
1. Power Platform Overview & Business Value¶
What is Microsoft Power Platform?¶
📖 Power Platform Overview - Comprehensive introduction to the Power Platform ecosystem and its components.
📖 Power Platform Architecture - Detailed documentation on platform architecture and administration.
📖 Business Value of Power Platform - Understanding ROI and business transformation through Power Platform.
Key Components¶
- Power BI - Business analytics and visualization
- Power Apps - Low-code application development
- Power Automate - Workflow automation and process automation
- Power Virtual Agents - No-code chatbot creation
- Power Pages - Low-code websites and portals
- Dataverse - Unified data storage and management
📖 Power Platform Components - Getting started with all Power Platform components.
Business Value & ROI¶
📖 Digital Transformation - Adoption methodology for organizational transformation.
📖 Citizen Development - Empowering business users to create solutions.
📖 Center of Excellence (CoE) - Establishing governance and best practices.
📖 Power Platform Licensing - Understanding licensing models and costs.
📖 Security and Governance - Security architecture and governance framework.
2. Microsoft Dataverse¶
Core Concepts¶
📖 Dataverse Overview - Introduction to the unified data platform for Power Platform.
📖 Tables in Dataverse - Understanding tables (formerly entities) and data structure.
📖 Standard vs Custom Tables - Differences between standard and custom tables.
📖 Columns and Data Types - Column types and their usage in Dataverse.
📖 Relationships - Creating and managing table relationships (1:N, N:1, N:N).
Data Management¶
📖 Business Rules - Implementing validation logic without code.
📖 Calculated and Rollup Columns - Automating calculations within Dataverse.
📖 Data Import - Importing data into Dataverse from various sources.
📖 Dataverse Security - Security roles, field-level security, and record-level security.
📖 Environments - Managing development, test, and production environments.
3. Power Apps¶
Canvas Apps¶
📖 Canvas Apps Overview - Introduction to creating pixel-perfect canvas applications.
📖 Canvas App Controls - Complete reference for all canvas app controls.
📖 Formulas in Canvas Apps - Power Fx formula language reference guide.
📖 Data Sources in Canvas Apps - Connecting to hundreds of data sources.
📖 Galleries and Forms - Displaying and editing data in canvas apps.
📖 Canvas App Templates - Starting with pre-built app templates.
Model-Driven Apps¶
📖 Model-Driven Apps Overview - Building data-driven applications with responsive design.
📖 App Designer - Using the modern app designer for model-driven apps.
📖 Forms in Model-Driven Apps - Creating and customizing data entry forms.
📖 Views - Defining how data is displayed in lists.
📖 Charts and Dashboards - Visualizing data within model-driven apps.
📖 Business Process Flows - Guiding users through standardized business processes.
Mobile Apps¶
📖 Power Apps Mobile - Running Power Apps on iOS and Android devices.
📖 Offline Capabilities - Working with apps without internet connectivity.
App Sharing & Distribution¶
📖 Sharing Canvas Apps - Distributing apps to users and managing permissions.
📖 Sharing Model-Driven Apps - Security roles and app access management.
4. Power Automate¶
Cloud Flows¶
📖 Power Automate Overview - Introduction to workflow automation platform.
📖 Automated Cloud Flows - Creating flows triggered by events.
📖 Instant Cloud Flows - Manual trigger flows activated on-demand.
📖 Scheduled Cloud Flows - Time-based recurring workflow automation.
📖 Flow Types Comparison - Understanding different flow types and when to use them.
Flow Actions & Connectors¶
📖 Connectors Overview - Complete list of 900+ connectors available.
📖 Standard vs Premium Connectors - Understanding connector licensing tiers.
📖 Actions and Triggers - Building multi-step flows with conditions and loops.
📖 Expressions - Using dynamic expressions in flows.
📖 Approvals - Building approval workflows for business processes.
Desktop Flows (RPA)¶
📖 Power Automate Desktop - Robotic Process Automation for desktop applications.
📖 Recording Actions - Recording UI interactions for automation.
📖 Attended vs Unattended - Understanding attended and unattended RPA execution.
Process Advisor¶
📖 Process Advisor - Analyzing and visualizing business processes for optimization.
📖 Process Mining - Discovering automation opportunities through process analytics.
5. Power BI¶
Core Concepts¶
📖 Power BI Overview - Introduction to business intelligence and analytics platform.
📖 Power BI Service - Cloud-based analytics service for sharing and collaboration.
📖 Power BI Desktop - Desktop application for creating reports and visualizations.
📖 Power BI Mobile - Accessing reports and dashboards on mobile devices.
Data Connectivity¶
📖 Data Sources - Connecting to various data sources and services.
📖 Dataflows - Self-service data preparation and reusable data logic.
📖 Import vs DirectQuery - Understanding data connectivity modes.
📖 Gateways - Connecting cloud services to on-premises data sources.
Reports & Visualizations¶
📖 Creating Reports - Building interactive reports in Power BI Desktop.
📖 Visualizations - Complete guide to all visualization types.
📖 Custom Visuals - Using and creating custom visualization components.
📖 Slicers and Filters - Adding interactivity with filters and slicers.
📖 Bookmarks - Creating navigation and storytelling experiences.
Dashboards¶
📖 Creating Dashboards - Building executive-level dashboard views.
📖 Dashboard Tiles - Pinning visualizations to dashboards.
📖 Real-time Dashboards - Creating dashboards with streaming data.
Sharing & Collaboration¶
📖 Workspaces - Organizing and collaborating on Power BI content.
📖 Sharing Reports - Distributing reports and dashboards to users.
📖 Power BI Apps - Publishing collections of reports and dashboards.
📖 Publish to Web - Embedding Power BI content in public websites.
6. Power Virtual Agents¶
Chatbot Basics¶
📖 Power Virtual Agents Overview - Introduction to no-code chatbot creation platform.
📖 Creating Bots - Building your first chatbot step-by-step.
📖 Topics - Creating conversation topics and dialogue flows.
📖 Entities - Extracting and using information from user messages.
Bot Capabilities¶
📖 AI Capabilities - Leveraging AI for natural language understanding.
📖 Question Nodes - Gathering information from users in conversations.
📖 Conditions and Branching - Creating dynamic conversation paths.
📖 Variables - Storing and using data throughout conversations.
Integration & Deployment¶
📖 Power Automate Integration - Calling flows from chatbots for complex actions.
📖 Bot Analytics - Monitoring bot performance and user satisfaction.
📖 Publishing Bots - Deploying bots to websites, Teams, and other channels.
📖 Bot Authentication - Implementing user authentication in chatbots.
7. AI Builder¶
AI Capabilities¶
📖 AI Builder Overview - Adding AI capabilities to Power Platform solutions.
📖 Prebuilt AI Models - Using ready-made AI models for common scenarios.
📖 Custom AI Models - Training custom AI models for specific business needs.
📖 Form Processing - Extracting information from documents automatically.
📖 Object Detection - Identifying and counting objects in images.
📖 Text Recognition (OCR) - Extracting text from images and documents.
📖 Sentiment Analysis - Analyzing sentiment in text data.
📖 Business Card Reader - Extracting contact information from business cards.
8. Connectors & Integration¶
Standard Connectors¶
📖 Connector Documentation - Complete connector reference documentation.
📖 Office 365 Outlook - Email, calendar, and contact integration.
📖 SharePoint - Document management and list integration.
📖 OneDrive for Business - File storage and sharing integration.
📖 Microsoft Teams - Collaboration and messaging integration.
📖 Excel Online - Spreadsheet data integration.
Premium Connectors¶
📖 SQL Server - Database connectivity for enterprise data.
📖 Salesforce - CRM integration for customer data.
📖 Dynamics 365 - Enterprise resource planning integration.
📖 SAP - ERP system integration for business processes.
Custom Connectors¶
📖 Custom Connectors Overview - Creating connectors for proprietary systems.
📖 Building Custom Connectors - Step-by-step guide to custom connector creation.
9. Administration & Governance¶
Environment Management¶
📖 Environment Strategy - Planning development, test, and production environments.
📖 Data Loss Prevention (DLP) - Policies to control data flow between connectors.
📖 Admin Center - Central management for Power Platform resources.
📖 Tenant Settings - Configuring organization-wide settings and policies.
Security¶
📖 Security Roles - Role-based access control for Power Platform.
📖 Azure AD Integration - Identity and access management integration.
📖 Auditing - Monitoring and logging user activities.
Monitoring & Analytics¶
📖 Power Platform Analytics - Usage analytics for apps and flows.
📖 CoE Starter Kit - Governance toolkit for enterprise adoption.
10. Power Fx & Formulas¶
Formula Language¶
📖 Power Fx Overview - Introduction to the low-code formula language.
📖 Formula Reference - Complete function reference for Power Fx.
📖 Common Functions - Most frequently used formulas in Power Apps.
📖 Collections - Working with in-memory data tables.
11. Exam Preparation Resources¶
Official Microsoft Resources¶
📖 Exam PL-900 Page - Official exam details and registration.
📖 Study Guide - Official study guide with exam objectives.
📖 Learning Paths - Microsoft Learn training modules for PL-900.
📖 Practice Assessment - Official practice questions for exam preparation.
📖 Certification Dashboard - Managing your Microsoft certifications.
Community Resources¶
📖 Power Platform Community - Community forums and discussions.
📖 Power Platform Blog - Latest updates and announcements.
12. Key Concepts Summary¶
When to Use Each Tool¶
Power Apps: - Building custom business applications - Mobile workforce solutions - Data collection and management - Replacing spreadsheets and manual processes
Power Automate: - Automating repetitive tasks - Integrating multiple systems - Approval workflows - Notifications and alerts - Desktop automation (RPA)
Power BI: - Data visualization and reporting - Business intelligence dashboards - Self-service analytics - Real-time monitoring - Data-driven decision making
Power Virtual Agents: - Customer service automation - FAQ bots - Internal help desk - Lead qualification - Employee onboarding assistance
Dataverse: - Unified data platform - Common data model - Secure and scalable data storage - Relational database for Power Platform - Integration hub for business data
Licensing Essentials¶
📖 Power Platform Licensing - Comprehensive licensing guide.
Key Points: - Per-user vs per-app licensing - Premium connector requirements - Dataverse capacity - Power Automate flow runs - AI Builder credits - Trial vs production licensing
Best Practices¶
📖 Solution Architecture - Real-world architecture patterns.
📖 ALM (Application Lifecycle Management) - Managing solutions across environments.
📖 Performance Optimization - Tips for building performant applications.
13. Common Scenarios & Use Cases¶
Business Process Automation¶
- Expense approval workflows
- Leave request management
- Invoice processing
- Document approval chains
- Employee onboarding
Data Collection & Management¶
- Field service data capture
- Inspection checklists
- Inventory management
- Customer feedback forms
- Site visit reporting
Reporting & Analytics¶
- Sales performance dashboards
- Financial reporting
- Operational metrics
- Customer analytics
- Supply chain visibility
Customer Engagement¶
- Customer service chatbots
- Product information bots
- Support ticket automation
- Lead qualification
- Appointment scheduling
14. Exam Tips¶
Preparation Strategy¶
- Complete all Microsoft Learn modules for PL-900
- Hands-on practice with each Power Platform component
- Create sample apps, flows, reports, and bots
- Understand licensing and connector types
- Review official practice assessments
- Focus on business scenarios and use cases
- Understand when to use each tool
Key Focus Areas¶
- Differences between canvas and model-driven apps
- Flow types: automated, instant, scheduled, desktop
- Standard vs premium connectors
- Dataverse tables, columns, and relationships
- Power BI components: Desktop, Service, Mobile
- Bot topics and entities
- AI Builder prebuilt models
- Security roles and DLP policies
- Environment strategy
During the Exam¶
- Read questions carefully
- Look for keywords indicating specific tools
- Eliminate obviously wrong answers
- Consider business scenarios
- Don't spend too long on difficult questions
- Review flagged questions if time permits
- Check for negative questions ("NOT", "EXCEPT")
15. Additional Resources¶
📖 Power Platform YouTube - Official Microsoft video tutorials.
📖 Power Apps Community Forums - Community support and discussions.
📖 Power Automate Community - Flow automation community.
📖 Power BI Community - BI and analytics discussions.
📖 Power Platform Release Plans - Upcoming features and enhancements.
Quick Reference Checklist¶
Before the Exam: - [ ] Completed all Microsoft Learn PL-900 modules - [ ] Created at least one canvas app - [ ] Created at least one model-driven app - [ ] Built automated, instant, and scheduled flows - [ ] Created a Power BI report with multiple visualizations - [ ] Built a simple chatbot with multiple topics - [ ] Understand Dataverse tables and relationships - [ ] Know the difference between standard and premium connectors - [ ] Familiar with AI Builder prebuilt models - [ ] Understand licensing basics - [ ] Reviewed official practice assessment - [ ] Understand environment and security concepts
Exam Day: - [ ] Valid government-issued ID - [ ] Stable internet connection (online exam) - [ ] Quiet testing environment - [ ] Arrive early (in-person exam) - [ ] Read all questions carefully - [ ] Manage time effectively (60 minutes)
Conclusion¶
The PL-900: Microsoft Power Platform Fundamentals certification validates your foundational understanding of Power Platform capabilities and how to leverage them to improve business productivity. Focus on understanding the business value, when to use each tool, and hands-on experience with creating basic solutions.
Key Success Factors: - Practical hands-on experience with all components - Understanding business scenarios and use cases - Knowledge of connectors and integration capabilities - Familiarity with licensing models - Awareness of security and governance features
Good luck with your exam preparation!
Document Version: 1.0 Last Updated: 2025-10-13 Total Documentation Links: 80+ embedded links to official Microsoft documentation