← Back PL-900 — Session 1 — Platform Overview & Business Value Exam weight: 15–20%

Microsoft Power Platform — Study Guide

Based on the course transcript by Barbara Andrews, Lead Microsoft Technical Trainer

0 of 5 sections visited
What is Microsoft Power Platform?
A suite of low-code tools that helps organizations build apps, automate processes, analyze data, and create digital experiences. Built on a modular architecture — each layer adds capability to the next.

Click each layer to expand details ↓

🤖 AI Layer — Copilot
Natural language · Intelligent suggestions · Cross-platform AI
Copilot sits at the top because it enhances every part of the platform. It's not a standalone tool — it's embedded across Power Apps, Power Automate, Power BI, Power Pages, and Dataverse to help users build faster through natural language.
⚙️ Application & Automation Layer
Power Apps · Power Automate · Power BI · Power Pages
The four core tools of the platform. Power Apps builds custom apps, Power Automate handles workflow automation, Power BI transforms data into dashboards, and Power Pages creates external-facing websites — all low-code.
🧠 Intelligence & Extensibility Layer
AI Builder · Copilot Studio · Power Fx · Connectors (1,400+)
Extends the platform with AI and integration. AI Builder adds predictive capabilities without code. Copilot Studio builds conversational AI agents. Power Fx is the low-code Excel-like language. Connectors bridge apps to 1,400+ external services.
🗄️ Data Foundation — Microsoft Dataverse
Secure · Scalable · Unified data model · Cross-platform
The backbone of Power Platform. Dataverse stores and manages data used by all components with a common data model, ensuring consistency, security, and seamless integration. It enables all tools to work together reliably.
🔒 Governance & Environment Layer
Managed environments · Compliance · Access control · Deployment
Managed environments provide isolated, controlled spaces for building, testing, and deploying solutions. Gives organizations oversight and control over data, resources, and compliance.
Why Power Platform? — The Business Case

Workforce Shift

  • Millennials & Gen Z = majority of workforce
  • Demand personalized, digital, collaborative tools
  • Power Platform delivers custom experiences

Cost Reduction

  • Traditional dev is expensive & slow
  • Low-code lets business users build their own apps
  • Reduces costly custom dev cycles

Speed & Agility

  • Old cycles: months to deploy, weeks for minor changes
  • Power Platform: rapid build, test, iterate
  • Keeps pace with business needs

Citizen Developers

  • Business users with domain expertise build apps
  • Pro devs extend with advanced features
  • Hybrid teams = scalable & user-centered

Click a tool to see details and examples ↓

📱
Power Apps
Low-code app builder
⚡
Power Automate
Workflow automation
📊
Power BI
Analytics & dashboards
🌐
Power Pages
Business websites
🤖
Copilot Studio
AI agent builder
𝑓𝑥
Power Fx
Low-code language

Example use case
Connectors — The Bridges 1,400+
Pre-built integrations that connect apps, data, and services. They come with predefined actions so users can build workflows without writing custom code.
Feature Standard Connectors Premium Connectors
License required Microsoft 365 (included) Power Apps / Automate Premium
Examples SharePoint, OneDrive, Outlook, GitHub, Power BI Salesforce, DocuSign, SQL Server, Dynamics 365, SurveyMonkey
Identifier — Premium stamp shown in interface
Best for Everyday M365 workflows Enterprise / mission-critical systems
Custom connectors Can be created when no standard/premium connector covers a proprietary system
Microsoft Dataverse
The unified, secure data backbone for all Power Platform components. Provides a common data model so Power Apps, Automate, and BI work together seamlessly.
Unified data model
Standardized structure ensuring consistency across apps, with built-in business logic, security, and integration.
Integration
Connects with Dynamics 365, Microsoft 365, Azure, and third-party data via industry partners.
Power Fx in Dataverse
Creates calculated columns for real-time data calculations. Example: auto-calculate employee tenure from hire date.
Table management
Users can create tables, import data, edit properties, and configure security directly via Power Apps interface.
Power Fx — The Low-Code Language

An Excel-like, declarative language used across Power Apps, Dataverse, and Copilot Studio. Human-readable syntax — no deep coding expertise needed.

In Power Apps
Controls app behavior with formulas. Example: If(IsBlank(PropertyName.Text), false, true) — shows/hides UI elements based on input.
In Dataverse
Creates calculated columns. Example: auto-calculate employee tenure by subtracting hire date from today.
In Copilot Studio
Sets variables, conditional logic, validates user input. Example: only accept restaurant bookings within a 14-day window.
Microsoft 365 Integration
Approval flows
Route documents to stakeholders automatically. Example: campaign materials routed to legal and branding before publication.
Invoice automation
Detect incoming emails with attachments → extract invoice data → validate → route for approval → store in SharePoint → update ERP.
Email attachments
Automatically save email attachments to the correct SharePoint folder using Power Automate flows.
Routine task automation
Send reminders, update spreadsheets, route requests — freeing employees for strategic work.
Microsoft Teams Integration
Copilot agents in Teams
Deploy AI agents to answer employee questions (e.g., HR policies/benefits) directly in Teams.
Power BI tab
Collaborate on live dashboards inside Teams meetings without switching apps.
Power Apps in Teams
Build and publish apps directly in Teams channels (e.g., incident reporting app). Templates: Issue Report, Employee Ideas, Inspection.
Virtual Assistants
Open-source template for building branded conversational solutions; can be integrated into Teams.
On-Premises Data Gateway

Acts as a secure bridge between cloud-based Power Platform services and local/on-premises data sources. Essential for hybrid environments.

No data migration
Cloud services access on-premises data without moving it to the cloud — key for data residency/compliance requirements.
Multi-service support
A single gateway supports Power Automate, Power Apps, and Power BI simultaneously.
Gateway clusters
Multiple gateways installed in a cluster provide failover support and load balancing for continuous availability.
Admin center
IT manages gateway clusters, user access, and performance via the Power Platform admin center.
How it works
Cloud service → Gateway Cloud Service (encrypts query) → On-premises gateway (decrypts credentials) → Local data source (SQL Server, file shares, etc.).
Copilot Studio — AI Agent Builder
Data sources
Connects to 1,500+ pre-built data sources for accurate, real-time responses.
Automated workflows
Define agent behavior using Power Automate. Example: "if customer asks about a product, send an email with details."
Multi-channel
Deploy one agent to websites, mobile apps, social media, and Teams simultaneously.
Security
Built-in tools to protect sensitive data and maintain control over agent operations.
Key Terms Flash Reference
Dataverse
Secure, scalable data platform that stores and manages data across all Power Platform components using a common data model.
Power Fx
Excel-like, low-code programming language used across Power Apps, Dataverse, and Copilot Studio.
Standard connector
Included with M365 subscription. Examples: SharePoint, OneDrive, Outlook, GitHub.
Premium connector
Requires Power Apps/Automate premium license. Examples: Salesforce, DocuSign, SQL Server, Dynamics 365.
Managed environment
Isolated, controlled space for building, testing, and deploying Power Platform apps with governance and compliance.
Citizen developer
Business user with domain expertise who builds apps using low-code tools without deep programming knowledge.
On-premises gateway
Secure bridge connecting cloud Power Platform services to local data sources without migrating that data to the cloud.
AI Builder
Adds AI/predictive capabilities to apps and workflows without writing code.

Click questions to reveal answers ↓

What are the four core tools in the Application & Automation layer?▼
Power Apps (custom app builder), Power Automate (workflow automation), Power BI (analytics and dashboards), and Power Pages (external-facing business websites).
What is the role of Copilot in Power Platform?▼
Copilot is the AI layer embedded across all tools — not a standalone product. It enhances productivity through natural language interactions, intelligent suggestions, and automation across Power Apps, Power Automate, Power BI, Power Pages, and Dataverse.
What is the difference between standard and premium connectors?▼
Standard connectors are included with a Microsoft 365 subscription and cover common services (SharePoint, Outlook, OneDrive). Premium connectors require a Power Apps or Power Automate premium license and connect to enterprise systems like Salesforce, DocuSign, SQL Server, and Dynamics 365. They're identified by a premium stamp in the interface.
Why is Microsoft Dataverse described as the "backbone" of Power Platform?▼
Dataverse provides a unified, secure data foundation that all Power Platform tools (Power Apps, Automate, BI) draw from. It enforces a common data model, business rules, and security settings — ensuring consistency, governance, and seamless integration across the entire platform.
What problem does the on-premises data gateway solve?▼
In hybrid environments where some data lives on-premises (not in the cloud), the gateway lets cloud-based Power Platform services securely access that local data without migrating it. It encrypts queries, routes them to on-premises systems, and returns results — maintaining data residency and compliance requirements.
How does Power Platform address the "traditional development is too slow" problem?▼
Traditional cycles take months to deploy solutions. Power Platform uses low-code tools so business users (citizen developers) can build and maintain their own apps, reducing dependence on IT. Combined with professional developers who can add advanced features, organizations get a scalable hybrid team model that builds and iterates much faster.
What does Copilot Studio enable organizations to build?▼
Copilot Studio is a low-code platform for building intelligent AI agents (chatbots/virtual assistants). These agents connect to 1,500+ data sources, use Power Automate for workflows, can be deployed across multiple channels (website, Teams, mobile, social media), and include security and governance controls. Example: a university deploying an enrollment assistant on its website and in Teams.
Name three ways Power Automate integrates with Microsoft Teams.▼
(1) Managers can approve purchase requests directly from a Teams notification, speeding up procurement. (2) AI agents deployed in Teams answer employee HR questions. (3) Workflows can trigger notifications inside Teams, reducing context-switching for users.