
In Module 1: Power Platform Overview, we will explore the fundamental components of the platform, their unique features, and how they can be leveraged to create innovative and effective solutions. Whether you’re a beginner or someone with experience, this module is crafted to equip you with the foundational knowledge and confidence to start using Microsoft Power Platform effectively.
Walid Moheyeldin, a Technical Consultant and Solution Architect, and thrilled to guide you through this journey with Microsoft Power Platform.
Introduction to Microsoft Power Platform
A high-level overview of the platform and its core capabilities.
Power Platform Business Value
Insights into how this platform boosts efficiency and productivity in business operations.
Connectors and Dataverse
Understanding how to use connectors and Dataverse for seamless data and application integration.
Utilizing Artificial Intelligence
Exploring how AI can enhance productivity and save time.
Power FX
An introduction to the low-code programming language that powers the platform.
Integration with Microsoft 365
Learning how to efficiently integrate Power Platform solutions with Microsoft 365.
App Interactions
Discovering the mechanisms for interaction between different applications within the platform.
Using Azure Services
Understanding how to leverage Azure services to enhance Power Platform solutions.
The session begins by emphasizing the growing importance of data in modern businesses. Data has become an integral part of day-to-day operations, from routine tasks like logging timesheets to making critical decisions based on analytical insights. While traditional methods often involve repetitive and time-consuming manual processes, technology offers a transformative solution: automation and enhanced user interaction with data.
This is where Low-Code and No-Code platforms emerge as game changers. These tools empower individuals, regardless of their technical expertise, to create effective solutions seamlessly. At the forefront of this innovation is Microsoft Power Platform, a suite of technologies that consolidates data and advanced tools into a single, user-friendly ecosystem. By utilizing Power Platform, organizations can automate mundane tasks, foster collaboration, and unlock new levels of efficiency and creativity.
Companies struggle to meet the growing demand for apps that boost employee productivity, often outpacing their development capacity, especially with the need to modernize legacy systems.
Key challenges include evolving employee expectations, high development costs, the need for agility, and scalable solutions to meet the demands of a rapidly changing market.
By combining the efforts of Citizen Developers (non-experts using low-code tools) and Professional Developers, organizations can accelerate app development, ensuring robust and scalable solutions while fostering collaboration.
Connectors in the Power Platform simplify integration between systems, enabling seamless operations by bridging various services like Outlook, SharePoint, Teams, and ERP systems. They support automation, such as processing invoices across multiple platforms.
Dataverse provides a secure, structured way to store and manage business data in tables, with built-in standard and customizable options. It supports application development, allowing businesses to create tailored solutions while ensuring data security and productivity. Together, connectors and Dataverse empower organizations to streamline workflows and enhance efficiency.
AI in Microsoft Power Platform enhances productivity by simplifying complex tasks and automating workflows. Tools like Copilot use Natural Language Processing (NLP) to help users build apps, analyze data, and create workflows effortlessly, even without technical expertise.
Copilot assists in Power Apps for app creation, Power Automate for designing workflows, and Copilot for building chatbots, turning simple descriptions into actionable solutions. It integrates seamlessly with data and tools, offering real-time guidance and automated setups. This revolutionizes development by saving time, increasing efficiency, and empowering users at all levels.
Practical Value of Power FX in Microsoft Power Platform
Power FX is the core low-code language in Microsoft Power Platform, enabling non-technical users to create dynamic applications and workflows.
Applications:
Power Apps: Power FX powers Canvas Apps by managing conditions, filtering data, and performing calculations. Example: Validating input fields with logic like If(IsBlank(Field), false, true).
Microsoft Dataverse: Used for calculated columns, e.g., computing "Total Price" (Product Price × Quantity) without complex code.
Copilot Studio: Defines logic, such as validating reservation dates for restaurants within 14 days, providing error messages for invalid inputs.
Power FX empowers users to transform ideas into functional solutions effortlessly.
Integration of Power Platform with Microsoft Ecosystem
Microsoft 365 Integration: Power Platform provides connectors for Outlook, SharePoint, and Excel, enabling rapid creation of custom solutions integrated with everyday tools.
Teams Integration: Power Platform facilitates building low-code apps and chatbots directly within Teams to enhance collaboration, especially for remote work scenarios.
Dynamics 365 Integration: Power Apps supports creating model-driven applications tailored to ERP and CRM needs, such as finance dashboards, sales tools, and customer service enhancements.
Practical Benefits: Companies can streamline processes, improve collaboration, and access tailored data insights with minimal technical complexity.
Conclusion: Power Platform delivers versatile, low-code solutions that seamlessly integrate across Microsoft services, empowering businesses to innovate efficiently.
How apps work together
Integrated Tools: Power Platform combines Power Apps, Power Automate, and Power BI to enable businesses to act, automate, and analyze effectively.
Power Apps: Allows creation of low-code custom applications, such as mobile tools for checking IT equipment availability, saving time and effort.
Power Automate: Automates routine tasks like sending reminders for equipment returns, reducing errors and improving resource availability.
Power BI: Provides actionable insights by analyzing data, such as equipment usage patterns or real estate market trends, aiding informed decision-making.
Business Value: The platform boosts productivity, improves decision-making, and optimizes resource use by seamlessly integrating app creation, automation, and analytics.
How Microsoft Azure Works with Power Platform
Integrated Functionality: Azure provides robust cloud infrastructure and advanced services, while Power Platform enables building low-code, cost-effective solutions for app development, automation, and scalability.
Airline System Use Case: Data like flight schedules and gate assignments are accessed via Power Apps and Microsoft Teams, ensuring easy user interaction.
Azure Services: Tools like Azure Functions (serverless processing), Azure Bot Service (intelligent chatbots), and Cosmos DB (distributed database) enhance data processing and automation.
Analytics and Reporting: Azure Data Lake and Event Hubs store and process event data, while Power BI delivers actionable insights via detailed reports.
Business Value: This integration ensures seamless workflows, real-time updates, and intelligent analytics, driving digital transformation and operational efficiency.
Course Module: Power Platform Core Components
In this module, learners will gain a comprehensive understanding of the fundamental components of Microsoft Power Platform, focusing on key administrative, security, and data management aspects.
The module will cover the following topics:
Power Platform Administration:
Explore the administrative capabilities of Power Platform, including environment management, monitoring, and compliance considerations. Learners will understand how to configure environments, manage capacity, and ensure effective platform governance.
Security & Governance:
Learn about the robust security model of Power Platform, including role-based access control (RBAC), data loss prevention (DLP) policies, and compliance frameworks. This section will equip learners with the knowledge to implement governance strategies that align with organizational policies.
Dataverse Exploring:
Delve into Microsoft Dataverse, the backbone of Power Platform's data storage capabilities. Learners will explore its structure, capabilities, and best practices for data organization, including tables, columns, and relationships.
Examine the Connectors:
Understand the wide array of connectors available within Power Platform to seamlessly integrate with various data sources and services. Learners will explore standard and premium connectors and their role in extending app functionality.
Data Model Building & ERD Design:
Gain practical experience in designing an effective data model for a given use case. Learners will learn how to define entities, relationships, and attributes, and visually represent them through an Entity-Relationship Diagram (ERD).
Dataverse Demo (Implementing the ERD):
Apply the knowledge acquired by implementing the previously designed ERD within Dataverse. This hands-on demo will showcase how to create tables, relationships, and business rules, providing a practical understanding of data model implementation in Power Platform.
This lecture provides a comprehensive overview of Environments in Power Platform, explaining how they serve as dedicated spaces for organizations to store, manage, and share data, applications, and Flows. Key points include:
Environments are linked to a Microsoft Azure AD Tenant, allowing only users within the same tenant to access them.
Each environment supports a Microsoft Dataverse database, enabling control over user permissions, security settings, and data storage.
Environments are geographically specific, with data stored in regional data centers (e.g., America, Europe, Asia).
They are used for Development, Testing, and Production, ensuring a clear separation between stages to prevent errors and maintain business continuity.
Organizations can create multiple environments based on geographic or business needs (e.g., separate environments for Europe and Asia).
The lecture also includes a visual example of a single tenant with multiple environments for different regions (e.g., USA, Canada, Australia), each containing Apps, Flows, and Dataverse.
Key Takeaway:
Environments in Power Platform enhance data management efficiency, security, and performance by providing structured, task-specific spaces (development, testing, production) and geographic flexibility. This design ensures data privacy, reduces errors, and supports seamless business operations.
This demo will guide you through the process of setting up a Microsoft Tenant and configuring a Power Platform Developer Environment. The goal is to create a dedicated space for development, testing, and deploying Power Platform solutions.
This lecture introduces the Power Platform Admin Center, the central hub for managing all aspects of Power Platform environments, data, security, licensing, and integrations. It is designed for administrators to monitor and control everything from a single interface.
Key Sections in the Admin Center:
Home:
Provides a quick overview of service health, including any disruptions, and allows customization with cards for important information.
Environments:
Lists all environments within the organization, which can be categorized as Development, Testing, or Production, and may include Dataverse or Dataverse for Teams.
Analytics:
Offers critical statistics on Dataverse, Power Automate Flows, and Power Apps, helping administrators monitor system performance.
Billing:
Manages licenses, allowing administrators to view and assign user licenses.
Settings:
Controls general settings, such as who can create or manage environments.
Resources:
Displays storage capacity and resources related to Dynamics 365, and allows management of additional features.
Help + Support:
Provides access to support tickets and troubleshooting resources.
Data Integration:
Manages connections with external data sources like Salesforce or SQL Server.
Data:
Focuses on managing data sources, gateways, and virtual network integrations.
Policies:
Handles security and privacy policies, such as Customer Lockbox and isolation controls.
Admin Centers:
Offers direct links to other admin centers like Microsoft 365 or Azure Active Directory.
Practical Application:
Administrators typically start on the Home page for an overview, then navigate to specific sections based on their tasks. For example:
To create a new environment, go to Environments.
To check workflow issues, use Analytics.
The Power Platform Admin Center acts as the command center for managing and optimizing Power Platform operations, ensuring efficient administration and control.
This lecture introduces the various Admin and Maker Portals available in Power Platform, which are designed to help users manage and create solutions efficiently. While the Power Platform Admin Center is used for overall administration, the Maker Portals are tailored for specific tasks like app development, data management, and automation.
Key Takeaways:
Maker Portals provide specialized tools for building and managing Power Platform solutions.
Each portal is tailored to a specific product (e.g., Power Apps, Power Automate, Power BI), ensuring a focused and efficient workflow.
These portals enable users to create, manage, and deploy solutions independently, making Power Platform a versatile tool for businesses.
This lecture explains the concept of Managed Environments in Microsoft Power Platform, a feature designed to simplify the management of applications and data in large organizations. Managed Environments provide advanced capabilities for administrators to control and secure their environments more effectively.
This lecture highlights how Managed Environments can streamline app and data management, making Power Platform a more secure and efficient tool for organizations.
This lecture focuses on the security and governance features of Microsoft Power Platform, emphasizing how the platform ensures data protection, compliance, and accessibility.
Key Takeaways:
Power Platform not only provides innovative and easy-to-use tools but also ensures the highest levels of security, compliance, and accessibility.
Features like DLP Policies, TLS encryption, and Accessibility Checker make the platform a reliable choice for organizations looking to protect their data and ensure inclusivity.
This lecture provides a simplified explanation of Microsoft Dataverse, a powerful platform designed to centralize and manage data efficiently in the cloud.
Key Takeaways:
Dataverse is more than just a database; it’s a comprehensive system for managing data efficiently and securely.
Its integration with Power Platform and Dynamics 365 makes it a powerful tool for organizations looking to streamline data management and application development.
This lecture explains how Microsoft Dataverse provides scalable solutions for managing large and growing datasets, making it an ideal choice for businesses and projects that need to handle increasing amounts of data.
Key Takeaways:
Dataverse is not just a regular database; it’s a comprehensive system designed to scale with your business needs.
With features like massive data capacity, flexible storage, and expandable storage options, Dataverse ensures that businesses can handle growing data demands without issues.
The platform’s integration with Azure Cloud provides a secure and scalable environment for managing data.
This lecture provides a simplified explanation of the structure and benefits of Microsoft Dataverse, a powerful platform for organizing and managing data.
Key Takeaways:
Microsoft Dataverse is more than just a database; it’s an intelligent system for organizing and linking your data, no matter how complex.
Its structure, based on the Common Data Model (CDM), ensures easy integration, flexibility, and excellent organization.
This lecture explains the three types of tables available in Microsoft Dataverse, each designed to help you organize and manage data according to your specific needs.
Key Takeaways:
Microsoft Dataverse offers three types of tables to suit various data storage and management needs:
Standard Tables: Ready-to-use and customizable.
Managed Tables: Stable and part of pre-built solutions.
Custom Tables: Fully customizable for unique requirements.
This flexibility allows you to manage data efficiently, whether you’re using pre-built solutions or creating custom ones.
This lecture provides a simplified explanation of columns in Microsoft Dataverse, focusing on their role in organizing and managing data within tables.
Key Takeaways:
Columns in Microsoft Dataverse are essential for organizing and managing data efficiently.
By defining specific data types for each column, you ensure data consistency and accuracy.
Whether you’re working with a few columns or hundreds, Dataverse provides the flexibility to handle data of any scale.
This lecture explains the concept of relationships between tables in Microsoft Dataverse, emphasizing why data should be separated into different tables and how these tables are connected.
Key Takeaways:
Separating data into multiple tables improves efficiency, performance, and reporting.
Relationships between tables (e.g., One-to-Many, Many-to-Many) ensure that data is logically connected and easy to manage.
Microsoft Dataverse provides the tools to create and manage these relationships, making it a powerful platform for organizing complex data.
This lecture provides a simplified explanation of Business Logic (or Business Rules) in Microsoft Dataverse, focusing on how these rules help enforce data accuracy and compliance with organizational policies.
Key Takeaways:
Business Rules in Microsoft Dataverse allow you to enforce data accuracy and compliance with organizational policies.
These rules are applied at the data level, ensuring consistency across all applications and scenarios.
By using Business Rules, you can simplify application development, save time, and ensure data integrity.
This lecture explains Dataflows, a cloud-based technology for self-service data preparation, and how they integrate with tools like Microsoft Dataverse, Power BI, and Azure Data Lake Storage.
Key Takeaways:
Dataflows provide a powerful, cloud-based solution for data preparation and transformation.
They integrate seamlessly with Microsoft Power Platform tools like Power BI, Power Apps, and Dataverse, as well as Azure Data Lake Storage.
By centralizing data transformations and making them accessible to multiple services, Dataflows enhance collaboration, flexibility, and efficiency in data management.
This lecture explains the Common Data Model (CDM), a standardized data schema that allows different systems to store and share data in a unified way.
Key Takeaways:
Common Data Model (CDM) provides a standardized way to store and share data across different systems, ensuring consistency and ease of integration.
By using CDM, organizations can simplify data analysis, improve collaboration, and reuse data models across multiple projects.
CDM is widely applicable across various industries, making it a versatile tool for data management.
This lecture explains Power Platform Connectors, which act as bridges between your applications or workflows and external data sources.
Key Takeaways:
Power Platform Connectors are essential for integrating your applications or workflows with external data sources.
They simplify data retrieval and storage, expand functionality, and allow you to leverage existing data.
Whether using standard connectors or building custom connectors, they are the backbone of seamless integration in Power Platform.
This lecture explains the different types of data sources and how Connectors in Microsoft Power Platform act as bridges between these data sources and your applications or workflows.
Also, this lecture explains the concepts of Triggers and Actions in Power Automate, which are essential for automating workflows.
Key Takeaways:
Connectors are essential for integrating your applications or workflows with various data sources.
There are two main types of data sources: tabular data (e.g., Excel, SQL) and function-based data (e.g., sending emails, managing files).
Power Platform offers over 1,000 connectors, including both standard and premium options, to connect with a wide range of services.
By using Connectors, you can build powerful, integrated solutions that work seamlessly with Microsoft 365 and other services.
Triggers are what start a Workflow in Power Automate, either based on time or an event.
Actions are the tasks that the Workflow performs after being triggered.
Together, Triggers and Actions enable you to automate processes efficiently, from sending emails to updating databases.
This lecture explains the different types of Connectors available in Microsoft Power Platform, including Standard, Premium, and Custom Connectors.
Key Takeaways:
Standard Connectors are included with a Microsoft 365 subscription and provide access to common services like SharePoint and OneDrive.
Premium Connectors require additional licensing and provide access to advanced services like Salesforce and Dynamics 365.
Custom Connectors allow you to build connectors for custom APIs or services, offering flexibility for unique business needs.
The type of connector you use depends on your specific requirements and the APIs available to you.
This lecture focuses on data modeling and how to design an Entity-Relationship Diagram (ERD) for a simple use case: managing customer orders. The goal is to create a data model consisting of three tables: Customers, Orders, and OrderItems.
Key Takeaways:
Data Modeling is essential for organizing and managing data efficiently.
A well-designed data model includes tables, fields, and relationships that reflect the real-world use case.
Primary Keys uniquely identify records in a table, while Foreign Keys establish relationships between tables.
One-to-Many Relationships are common in data models, such as one customer placing many orders or one order containing many items.
Practical Use Case:
Scenario: A company wants to manage customer orders and track the items in each order.
Process:
Create a Customers Table to store customer information.
Create an Orders Table to store order details, linking each order to a customer via CustomerID.
Create an OrderItems Table to store the items in each order, linking each item to an order via OrderID.
Use the ERD to visualize the relationships between the tables and ensure the data model is correctly structured.
This lecture provides a clear understanding of data modeling and how to design an ERD for a simple use case, such as managing customer orders. By following these steps, you can create a robust and scalable data model for your applications.
This is the first part of a hands-on demo where we will implement the data model designed in the previous lecture. In this session, we will focus on introducing the demo and creating the Customers Table in a database. We will go through multiple practices to ensure you understand the process thoroughly.
In the second part of the demo, we will continue implementing the data model by creating the Orders and OrderItems tables. We will also establish the relationships between these tables and the Customers Table. This session will focus on one-to-many relationships, data integrity, and hands-on practices to reinforce your understanding.
Welcome to the Building Applications with Microsoft Power Apps module! In this hands-on session, you’ll discover how to create powerful business applications without writing complex code. Whether you're streamlining workflows or replacing paper-based processes, Power Apps empowers you to build flexible, data-driven solutions using simple drag-and-drop tools and Excel-like formulas. By exploring both canvas and model-driven app approaches, you’ll gain practical skills to connect to data, design user interfaces, and automate business tasks — all with minimal development effort. Let’s turn your ideas into apps!
In this module, we will explore the core concepts and practical skills needed to build applications using Microsoft Power Apps. We’ll begin with an overview of Power Apps and the differences between canvas apps and model-driven apps. Then, you'll learn how to build both types of apps from scratch — from connecting to data sources and designing user interfaces to implementing logic and sharing your apps with users. Throughout the session, live demos and real-world examples will reinforce each concept, helping you gain confidence in developing business-ready applications with little to no code.
In this lecture, we introduce Microsoft Power Apps — a powerful low-code platform that enables anyone to build custom business applications quickly and efficiently. You’ll learn what Power Apps is, its core capabilities, and how it leverages familiar tools like Excel formulas and prebuilt connectors to simplify app development. We’ll also explore the platform’s ability to connect to a wide range of data sources such as SharePoint, Dataverse, and SQL Server, empowering you to create flexible, scalable apps that work seamlessly across web, mobile, and Microsoft 365 services.
In this lecture, you’ll dive into Canvas Apps, a flexible and intuitive way to design custom applications tailored to specific business needs. You'll learn how to build pixel-perfect user interfaces using a drag-and-drop editor and enhance functionality with Power Fx formulas — similar to Excel. We’ll cover key benefits, such as seamless integration with multiple data sources, responsive design across devices, and real-world use cases like streamlining operations at Heathrow Airport. By the end, you’ll understand how Canvas Apps can replace manual processes and empower teams to build smart, interactive solutions with ease.
In this lecture, you'll explore Model-driven Apps — a powerful approach to building structured, data-centric applications using Microsoft Dataverse. Unlike Canvas Apps, model-driven apps focus on your data model and automatically generate responsive user interfaces based on defined tables, relationships, and business rules. You’ll learn how to design forms, views, dashboards, and automate workflows using built-in logic components. Through real-world examples, you’ll see how organizations use model-driven apps to manage complex business processes such as CRM systems, making them ideal for operational and enterprise-grade solutions.
In this lecture, you’ll learn the key differences between Canvas Apps and Model-driven Apps to help you choose the right approach for your business needs. We’ll compare them across several dimensions — including data sources, design flexibility, user interface, use cases, and deployment scenarios. You’ll explore real-world examples that show how both app types can be used independently or together to deliver comprehensive solutions. By the end, you’ll be equipped to make informed decisions on when to use each app type and how to combine them effectively within the Power Platform.
In this hands-on lecture, you’ll learn how to build a basic Canvas App from start to finish using Power Apps. We'll walk through the full creation process — identifying a business need, connecting to data sources like SharePoint or Excel, designing screens with controls, and applying Power Fx formulas for interactivity. You’ll explore essential components such as galleries, forms, input controls, and responsive containers. With step-by-step guidance and a real-world use case, you’ll gain practical skills to create and publish an app that improves efficiency and solves everyday business challenges.
In this live demo, you’ll see a complete walkthrough of building a real-world Canvas App for a manufacturing scenario. Using data stored in Excel and OneDrive, we’ll create an app that allows users to track building conditions directly from their mobile devices. You’ll learn how to connect to data, design user-friendly screens, and enable updates on the go — replacing inefficient manual processes like email and shared spreadsheets. This demo reinforces key concepts from the previous lecture and showcases how Power Apps can bring real value to everyday business operations.
In this lecture, you’ll learn how to build a Model-driven App using Microsoft Power Apps and Dataverse. We'll guide you through the step-by-step process — from defining tables, columns, and relationships, to designing forms, views, and dashboards. You'll also explore how to implement business logic using flows, rules, and business process flows, along with integrating visualization tools like charts and Power BI. By the end, you’ll be able to create data-driven applications with structured navigation, responsive design, and rich user experiences — all without writing code.
This demo showcases how to build a Model-Driven App using Power Apps and Dataverse to manage customer data. Through a CRM example, you'll learn how to structure data, customize forms and views, and enhance workflows with built-in automation and dashboards—all using a low-code approach to boost business efficiency.
4o
Unlock the full potential of automation with Microsoft Power Automate! In this hands-on module, you will learn how to create, manage, and optimize powerful workflows that automate repetitive tasks, boost productivity, and streamline business processes. Covering Cloud Flows, Business Process Flows, and Desktop Flows (RPA), you’ll explore real-world scenarios like automating approvals, integrating apps, and using AI for smarter automation. Get familiar with the Power Automate apps (Portal, Mobile, Desktop) and learn to build basic and advanced flows with ease—even with the help of Copilot. This module is ideal for beginners and aspiring automation experts eager to drive digital transformation with low-code solutions.
In this module, you will explore the full capabilities and business value of Microsoft Power Automate. The agenda includes:
Introduction to Power Automate: Overview of the platform and its core functionalities.
Capabilities of Power Automate: Learn how Power Automate can automate routine tasks, integrate systems, and streamline processes.
Exploring Power Automate Apps: Introduction to the three key apps—Power Automate Portal, Power Automate Mobile App, and Power Automate for Desktop.
Understanding Desktop Flows (RPA): Dive into Robotic Process Automation and learn how to automate manual desktop tasks.
Business Value of Automation: Discover real-world examples and case studies demonstrating the tangible benefits of automation.
Cloud Flows Explained: Understand the types, triggers, and actions in cloud-based flows and how they can be leveraged for efficiency.
Power Automate Demonstration: Practical live demos showcasing how to build and run flows for various business needs.
In this lecture, you will dive into the core capabilities of Microsoft Power Automate and discover how it empowers businesses to automate a wide range of tasks without writing code. We will cover common scenarios where Power Automate adds value—such as automating data transfers between systems, guiding users through multi-step business processes, and using Robotic Process Automation (RPA) to handle repetitive desktop and web tasks. Real-world examples will demonstrate how automation improves efficiency, accuracy, and overall productivity across various industries.
In this lecture, you’ll explore the three main types of flows in Microsoft Power Automate—Business Process Flows, Cloud Flows, and Desktop Flows. You'll learn how each flow type is designed to automate different kinds of tasks, from guiding users through structured business processes, to automating cloud-based activities triggered by events, to recording and replaying manual actions on desktop environments. Real-life use cases will show how to choose the right flow type for your business needs, helping you design smarter, more efficient automations.
In this lecture, you’ll get introduced to the three key applications within Power Automate—Power Automate Portal, Power Automate Mobile App, and Power Automate for Desktop. You’ll learn how each app is designed to help makers create, manage, and monitor automations from anywhere—whether through a web portal, a mobile device, or directly on a desktop for Robotic Process Automation (RPA). Practical examples will illustrate how to leverage each app to build powerful and flexible workflows suited to any environment.
In this lecture, you’ll learn all about Cloud Flows in Microsoft Power Automate—how they work, when to use them, and the powerful automation opportunities they offer. You’ll explore the different types of Cloud Flows (Automated, Instant, and Scheduled), understand how triggers and actions build seamless workflows, and see practical examples of integrating apps, automating approvals, and scheduling repetitive tasks. Whether automating daily operations or connecting multiple services, Cloud Flows empower you to create scalable, code-free automations with over 1,000 connectors.
In this lecture, you’ll discover how Process Mining in Microsoft Power Automate helps organizations uncover hidden inefficiencies and optimize their business processes. You’ll learn how process mining analyzes data from systems to visualize workflows, identify bottlenecks, and highlight opportunities for automation and improvement. This lecture will show you how to leverage insights from real operational data to drive smarter decisions, streamline operations, and maximize the impact of automation initiatives.
In this lecture, you'll learn how to create a basic Power Automate cloud flow using templates. It focuses on automating tasks like saving email attachments to OneDrive folders based on the sender. You'll explore the Power Automate maker portal, where you can select templates and configure flows with a point-and-click interface. The lecture also introduces Copilot, a tool that helps you create and troubleshoot flows by describing your desired automation. By the end, you'll have a hands-on understanding of how to build and refine cloud flows using Power Automate.
This lecture covers the process of building a desktop flow using Power Automate for Desktop, which runs directly on your local machine. You'll learn how to create flows that automate tasks like interacting with applications or files on your computer. The lecture introduces the Power Automate Desktop designer, where you can use pre-built templates or record actions to build your flows. You'll also see how to test and trigger these flows manually or through cloud flows. By the end, you will understand how to create and run desktop flows for various automation tasks.
This lecture highlights the business value of Power Automate through a case study of Komatsu Australia, which used the tool to automate its invoice processing workflow. Komatsu faced challenges in manually processing over 52,000 invoices annually, but by leveraging Power Automate and AI Builder, they streamlined the process, saving over 300 labor hours for just one supplier. The success led to the launch of a citizen developer program, empowering employees to innovate and improve operational efficiency across the company. The lecture demonstrates how Power Automate can drive operational efficiency and inspire digital transformation within businesses.
This demo introduces the process of creating a cloud flow to automate the submission of purchase orders (PO) through an app. It walks through setting up the cloud flow that triggers when a PO is submitted, capturing the necessary details, and storing them in a database or system. You'll see how to automate data collection and enhance workflow efficiency using Power Automate.
In this part of the demo, you’ll learn how to automate the approval process for the purchase orders (PO) submitted in the previous demo. It demonstrates how to set up approval workflows, notify the relevant stakeholders, and track responses within Power Automate. The goal is to streamline and speed up the approval process, reducing manual oversight and delays.
Building on Part 2, this demo dives deeper into the implementation of approval automation. It shows how to handle different approval scenarios, set up conditional branches for various responses, and ensure that the process moves forward based on the decisions made. You'll see how to create a more dynamic and flexible approval workflow using Power Automate.
This demo demonstrates how to create and execute a desktop flow using Power Automate for Desktop to automate the extraction of the daily exchange rate from the Central Bank of Egypt's website. It walks you through the process of navigating the website, extracting the relevant exchange rate data, and saving it into an Excel file. The flow then sends the file to the VP, automating the entire process from data retrieval to file management, ensuring timely and accurate reporting with minimal manual intervention.
Learn how Power BI transforms raw data into interactive, visual insights. This section introduces you to Power BI’s core purpose—connecting to various data sources, cleaning and modeling data, and creating meaningful analytics to support better business decisions.
Get a clear overview of what you’ll learn in this Power BI module. From building data-driven reports and dashboards to applying AI insights and transforming data, this agenda sets the foundation for the skills and tools you'll master throughout the course.
This lecture will discover how Power BI connects to diverse data sources and turns them into interactive, visual insights. Learn about its key components—Power BI Desktop, the Power BI service, and mobile apps—and how they work together to let users analyze, share, and consume data in a flexible, user-friendly way.
Explore the core building blocks of Power BI: Workspaces, Semantic Models, Reports, Dashboards, and Template Apps. Learn how each element fits into the data analytics workflow and how they work together to help you organize, visualize, and share data effectively across your organization.
Learn how to clean and transform raw data using Power BI Desktop and Power Query Editor. Understand the different data views—Report, Data, and Model—and discover essential techniques like changing data types, removing columns, and reshaping data for better analysis and visualization.
Discover how Power BI uses AI to automatically detect trends, anomalies, and key performance insights in your data. Learn to interact with AI-driven notifications, explore report- and visual-level insights, and understand how Power BI explains data patterns to support smarter, faster decisions.
Follow a step-by-step process to build and share a Power BI dashboard. Learn how to prepare your data, create reports, pin visuals to dashboards, and share insights with others. This hands-on walkthrough shows how Power BI turns raw data into accessible, interactive business intelligence.
See the real-world impact of Power BI through the success story of the Miami Heat. Learn how data-driven insights boosted ticket sales, optimized operations, and improved fan experience—proving how Power BI can drive smart decisions and real business value across any industry.
Get a quick preview of what you'll learn in this Power BI course. In this demo, we walk through the basics of building interactive dashboards, transforming data, and spotting insights using AI—showcasing how Power BI helps you turn data into action. See the platform in action before diving deeper!
In this introduction, you'll discover how Power Pages fits into the Microsoft Power Platform and empowers both citizen and pro developers to build secure, data-driven business websites. You'll learn why organizations use Power Pages to give external users access to business data, such as customer support or order history, and how this low-code platform simplifies building responsive, professional sites connected to Microsoft Dataverse.
In this module agenda, you’ll get a clear overview of what to expect in the Power Pages learning journey. We'll explore the core features of Power Pages, understand the business value it brings, walk through the step-by-step process of building a website, and discover how Copilot can streamline your development experience. This agenda sets the foundation for mastering how to create secure, user-friendly business websites with Microsoft Power Pages.
In this lecture, you'll discover how Microsoft Power Pages enables the creation, hosting, and management of modern, external-facing websites. Learn to design responsive, mobile-friendly sites with low-code tools, customizable templates, and a streamlined visual studio. Power Pages integrates seamlessly with other Power Platform components like Dataverse, Power Apps, Power Automate, and Power BI, making it easy to build secure, dynamic websites that meet unique business needs and enhance user engagement.
Power Pages provides significant value to businesses by enabling them to create efficient, externally facing websites with minimal effort. For instance, Contoso Real Estate can use Power Pages to build a property listing site, offering customers self-service options like managing profiles, viewing listings, and requesting showings. This enhances customer engagement, streamlines data operations, and improves daily workflows. Additionally, it helps build stronger relationships with buyers by providing them with a secure platform for real-time updates and interactions. All of this can be achieved quickly through a low-code platform.
In this lecture, you'll learn the essential steps to create a site using Microsoft Power Pages. From selecting templates and defining site structure to connecting to Dataverse and securing your site, you'll explore the key elements of site creation. Discover how to use the Design Studio to design pages, apply branding, and connect your site to business data. Learn how to customize your site with themes, set up data-driven components, and configure security to ensure authorized access.
This lecture explores how to leverage Copilot in Power Pages to streamline website creation. Using natural language instructions, Copilot can help you build sites by generating relevant content, suggesting images, creating forms, and setting up Dataverse tables. You can start by describing the type of site you want, and Copilot will generate a name, layout, and pages for you. Learn how to use Copilot to quickly build and modify sites, ensuring efficient and tailored results.
In this practical demo, you’ll get hands-on experience building a simple website using Power Pages. Step-by-step, you’ll learn how to create a website from scratch.
In this practical demo, you’ll get hands-on experience building a simple website using Power Pages. Step-by-step, you’ll learn how to create a website using Power Pages template.
In this practical demo, you’ll get hands-on experience building a simple website using Power Pages. Step-by-step, you’ll learn how to create a website using Copilot and use dynamic data from Dataverse.
This module introduces you to the AI authoring experience within Microsoft Power Platform, focusing on tools that empower business users to create intelligent solutions with ease. You'll explore Microsoft Copilot Studio, a user-friendly platform for building conversational AI agents, and learn how to configure generative AI capabilities to meet business needs. The module guides you through building a simple copilot, explaining key components and practical use cases for AI bots in real-world scenarios. Additionally, you'll dive into AI Builder, a no-code tool designed to help users create, train, and deploy custom AI models that drive business value. Whether you're new to AI or looking to enhance your understanding of Microsoft’s AI tools, this module provides a practical foundation for creating smart, automated solutions across your organization.
In this module, learners will begin by exploring Copilot Studio, gaining an overview of its interface and purpose within the Microsoft Power Platform. They will then delve into the components of Copilot Studio, understanding how each part contributes to building effective AI copilots. Next, the module walks through the steps to create a basic agent, offering hands-on guidance in setting up a functional AI assistant. Learners will also examine use cases for Generative AI bots, discovering how they can be applied in real business scenarios to improve efficiency and engagement. The focus then shifts to AI Builder, where learners will explore its capabilities and how it supports no-code AI model creation. The lifecycle of creating an AI Builder model will be discussed in detail, from data preparation to training and deployment. The agenda also includes a Copilot demo and an AI Builder demo, allowing learners to see these tools in action and solidify their understanding through practical examples.
This lecture introduces learners to Copilot Studio, a powerful, no-code solution within Microsoft Power Platform designed to help organizations quickly build and deploy AI-powered agents (bots). It begins by explaining the growing need for faster, more accurate customer service and how conversational AI bots can meet this demand by engaging in real-time, iterative dialogues to resolve customer queries. Copilot Studio simplifies the traditionally complex process of bot development, enabling subject matter experts (SMEs) to build, manage, and update agents without requiring coding skills or involvement from data scientists and developers.
Learners explore key features of the platform, including its SaaS-based setup, code-free graphical interface, and integration capabilities with back-end systems using Power Automate. The lecture highlights how users can build rich, multi-turn conversations, test them in real-time, and even allow agents to act on behalf of users by connecting to external services. Additionally, Copilot Studio supports extending existing agents with organizational data and includes AI-driven analytics dashboards to monitor usage, resolution rates, and engagement, empowering continuous improvement of the agent's performance.
This lecture provides an overview of the key components that make up Copilot Studio, the no-code platform used to build intelligent conversational agents. At the heart of agent design are topics, which define structured conversation paths between the user and the agent. Each topic contains trigger phrases—words or questions a user might type—and conversation nodes, which determine how the agent should respond. The platform uses natural language understanding (NLU) to interpret user intent and match inputs to the most appropriate topic, even if the exact trigger phrase isn't used.
A vital part of NLU in Copilot Studio is the use of entities, which are data elements (like names, cities, or zip codes) that help the agent understand specific details within user input. To make agents more powerful, developers can integrate actions by connecting to Microsoft Power Automate flows. These flows allow agents to perform tasks or retrieve data from back-end systems, such as checking a user's account after login.
The generative AI feature enhances conversations by allowing agents to draw from public or organizational documents when a direct answer isn’t available. This creates more dynamic and data-informed responses. After designing or updating an agent, users can publish it across multiple platforms—websites, mobile apps, Teams, or Facebook. Publishing can also include authentication options using identity providers like Microsoft Entra ID, enabling personalized and secure interactions with users.
Together, these components—topics, entities, actions, generative AI, and publishing tools—form a comprehensive, flexible framework that allows organizations to build sophisticated, responsive, and integrated conversational agents without writing code.
This lecture walks learners through the step-by-step process of creating a basic agent using Microsoft Copilot Studio. It begins by introducing the Copilot Studio designer, the central workspace where users can create, manage, and customize conversational agents using a no-code interface. The process starts with creating an agent by providing essential details such as the agent's name, language, and icon, and optionally linking it to knowledge sources for generative AI responses. These agents are designed with collaboration in mind, allowing both low-code users and pro developers to work within the same authoring canvas.
The next step is to define topics, which are dialog trees guiding how the agent handles user interactions. Topics consist of trigger phrases and conversation nodes like "Show a message," "Ask a question," "Call an action," and "Redirect to another topic." These elements collectively shape the flow and logic of conversations. Authors can enhance interactions by using Adaptive Cards and integrating Power Fx for advanced data handling.
Once the structure is built, users can test their agent in real time using a built-in test pane that visually traces dialog progression, helping fine-tune how topics perform individually and interact with each other. The lecture also covers generative AI configuration, showing how to connect the agent to various knowledge sources—such as SharePoint, OneDrive, Dataverse documents, or web search engines—to provide richer, more dynamic responses.
Finally, the lecture explains how to publish the agent to different channels like websites or social media, beginning with a demo site for internal review. This comprehensive guide equips learners with all the foundational tools and best practices needed to build and deploy an effective AI agent using Copilot Studio.
This lecture highlights the practical use cases for Generative AI bots in Copilot Studio and their value in delivering natural, intelligent, and context-aware interactions. Generative AI bots allow organizations to provide fast, dynamic responses to user queries by pulling information directly from internal or external sources—like documents, websites, or knowledge bases—without requiring pre-authored conversation topics. This reduces the need to manually create multiple topic paths and enables quicker deployment of functional agents.
One key use case is fallback support: when a user query doesn’t match any existing topic, the agent uses generative AI to attempt an intelligent answer. If that fails too, the system's fallback topic takes over, potentially escalating the conversation. This tiered approach ensures users get support even when specific intents haven’t been manually configured.
Another major benefit is contextual understanding. Generative AI can retain context across questions. For example, if a user asks about the "IF function in Excel" and then follows up with "Can you give me an example?", the agent understands the reference and continues the conversation naturally. This improves the user experience by mimicking how human conversations flow, making AI bots more helpful and intuitive.
In this lecture, we’ll explore AI Builder, a powerful tool within the Microsoft Power Platform that allows businesses to easily incorporate artificial intelligence into their processes without requiring coding or specialized data science knowledge. AI Builder offers both prebuilt and custom models that can automate tasks, analyze data, and extract insights across various business functions. We’ll begin by introducing the AI Hub, the central area for accessing AI tools like prompts, AI models, and document automation solutions. Then, we’ll dive into the types of models available in AI Builder, including prebuilt models for tasks such as invoice processing, sentiment analysis, receipt scanning, and text recognition, as well as custom models that allow you to design AI solutions tailored to your specific needs. By the end of this session, you'll have a clear understanding of how to leverage AI Builder to automate your workflows, streamline operations, and gain valuable insights into your business data.
In this lecture, we'll walk through the lifecycle of creating an AI Builder model to add intelligence to your business. The process begins by choosing the right AI model type that aligns with your specific business needs, selecting from a wide range of AI solutions. Next, you will connect your business-specific data from available options to train and customize your model. Once the data is integrated, you can tailor the model to optimize its performance based on your requirements. After that, the training process begins, which is automated and teaches the model to solve business problems by learning from your data. For instance, it could learn to detect your products in images or predict certain business outcomes. Finally, you'll use the insights generated by your trained model to create solutions within the Power Platform. These insights can be applied in Power Automate to automate workflows or in Power Apps to build predictive apps, all without needing coding expertise.
The Copilot Demo lecture introduces the key functionalities and features of Copilot Studio, focusing on how it helps businesses create AI-driven agents (bots) for improving customer service and engagement. The demo walks through the process of building and deploying a conversational agent with Copilot Studio, showcasing its user-friendly, no-code interface. Participants will see how to create an agent by defining topics, integrating generative AI, testing the agent in real-time, and publishing it across multiple channels like websites or social media platforms. The demonstration highlights how Copilot Studio empowers subject matter experts (SMEs) to build and manage intelligent agents without requiring AI or coding expertise. Additionally, it emphasizes the importance of continuous monitoring and optimization to enhance agent performance through real-time analytics and insights.
The AI Builder Demo lecture introduces AI Builder, a tool within the Microsoft Power Platform that allows businesses to integrate AI into their workflows without requiring advanced coding or data science skills. The demo covers various AI models available in AI Builder, such as prebuilt models for invoice processing, sentiment analysis, and object detection, as well as custom models that can be tailored to specific business needs. The session walks participants through the process of building and training an AI model, from selecting a model type and connecting relevant business data to training the model automatically. The demo also shows how AI Builder’s insights can be used to create practical solutions, such as automating document processing with Power Automate or predicting supplier compliance within Power Apps. This lecture highlights how AI Builder makes it easier for businesses to add intelligence to their processes, enhancing productivity without requiring coding expertise.
Discover the transformative capabilities of Microsoft Power Platform with our in-depth course that covers its business value and extensive product features. This course provides hands-on experience in creating simple Power Apps, connecting data through Microsoft Dataverse, and crafting interactive Power BI dashboards. You'll also learn to streamline processes using Power Automate and enhance digital experiences with Microsoft Copilot Studio.
Delve into the core components of the Power Platform, understanding its integration with other Microsoft products and exploring foundational elements like administration, security, and governance. Gain practical knowledge on how Microsoft Dataverse and various data connectors function to support your applications.
The course emphasizes the practical use of Microsoft Power Apps, enabling both citizen and professional developers to build applications that address real business needs. You’ll see how Power Automate can revolutionize process automation, allowing you to create automated workflows that are both efficient and reliable.
Further, explore how Power BI can be utilized to generate meaningful reports and dashboards that offer AI-driven insights, helping you make informed business decisions. Learn to create modern external-facing websites with Power Pages, leveraging shared business data stored in Microsoft Dataverse.
Finally, get acquainted with Microsoft Copilot Studio, where you'll customize Copilot experiences and develop generative AI tools using AI Builder to further optimize your business processes. This course is rich with practical examples and real-world applications, ensuring that learners not only understand the theory but can also implement their knowledge effectively.