Microsoft Power Automate & Power Pages Intermediate Course Overview

The Microsoft Power Automate & Power Pages Intermediate Training Course is designed for participants who already have basic familiarity with Microsoft 365 or Microsoft Power Platform and want to develop practical skills in workflow automation and business portal development.

The course provides a brief introduction to the capabilities of Microsoft Power Automate and Microsoft Power Pages, followed by intermediate-level hands-on activities focused on creating useful business solutions.

Microsoft Power Automate enables organizations to automate repetitive processes, approvals, notifications, data movement, and other business workflows across Microsoft 365 and supported applications.

Microsoft Power Pages is a low-code platform for creating secure, professional business websites and self-service portals. It allows organizations to provide users with web-based access to information, forms, services, and business processes.

Throughout the course, participants will learn how to build, test, manage, and maintain automated workflows and business portals while applying appropriate workflow logic, access controls, data integration, and basic error-handling techniques.

 

Duration 4 days – 28 hrs

 

Objectives 

• Design and develop automated business workflows.
• Create automated, instant, and scheduled cloud flows.
• Automate approvals, notifications, reminders, and recurring business tasks.
• Integrate Power Automate with SharePoint and other Microsoft 365 applications.
• Configure workflow triggers, actions, conditions, branches, and variables.
• Apply workflow logic and basic error-handling techniques.
• Test, troubleshoot, monitor, and maintain automated workflows.
• Create and manage automated business processes independently.
• Understand the capabilities and common business applications of Microsoft Power Pages.
• Design and develop business websites and self-service portals.
• Create and manage web pages, navigation, content, forms, lists, and user interfaces.
• Work with Microsoft Dataverse as the primary data platform for Power Pages.
• Integrate Power Pages solutions with Microsoft 365 services and business processes using Power Platform components such as Power Automate.
• Configure user access, authentication concepts, web roles, and permissions.
• Control who can view, access, create, or update information through a portal.
• Customize the appearance and functionality of a Power Pages website.
• Independently build, update, and maintain business websites and portals.

 

 Target Audience 

• Business Analysts
• Process Improvement Specialists
• Operations Personnel
• Administrative Professionals
• Microsoft 365 Power Users
• SharePoint Users and Administrators
• IT Support Professionals
• Application Support Teams
• Digital Transformation Teams
• Business Process Owners
• Low-Code / No-Code Developers
• Employees responsible for workflow automation
• Employees responsible for internal or external business portals

 

Prerequisites 

• Basic knowledge of Microsoft 365 applications.
• Basic experience using SharePoint, Excel, Outlook, or Teams.
• Basic understanding of business processes and workflows.
• Familiarity with Microsoft Power Platform is helpful but not mandatory.
• Basic understanding of tables, records, columns, and structured data.
• Access to the appropriate Microsoft Power Platform environment and licenses for hands-on exercises.

 

Course Outline 

DAY 1 – Power Platform and Power Automate Intermediate 

Module 1: Introduction to Microsoft Power Platform

• Overview of Microsoft Power Platform
• Introduction to:
  • Power Automate
  • Power Pages
  • Power Apps
  • Power BI
  • Microsoft Dataverse
• How Power Automate and Power Pages work together
• Common business use cases
• Understanding connectors and data sources

Module 2: Power Automate Fundamentals Review

• Power Automate interface and environment
• Understanding cloud flows
• Types of flows:
  • Automated cloud flows
  • Instant cloud flows
  • Scheduled cloud flows
• Triggers and actions
• Working with Microsoft 365 connectors

 Module 3: Building Intermediate Automated Workflows

• Designing business workflow logic
• Configuring triggers and actions
• Using dynamic content
• Working with variables
• Using expressions
• Conditions and branching
• Switch controls
• Apply to Each
• Do Until
• Working with multiple workflow steps

Hands-On Exercise: Build a multi-step automated business workflow using Microsoft 365 applications.

 

DAY 2 – Business Process Automation and Integration

Module 4: Automating Approvals and Notifications

• Creating approval workflows
• Single-stage approvals
• Sequential approvals
• Approval outcomes
• Email notifications
• Microsoft Teams notifications
• Reminder and escalation workflows
• Scheduled and recurring tasks

 Module 5: Power Automate with SharePoint and Microsoft 365

• Connecting Power Automate with SharePoint
• Creating workflows based on SharePoint lists
• Creating and updating SharePoint items
• Automating document-related processes
• Integration with:
  • Outlook
  • Teams
  • Excel
  • OneDrive
  • Microsoft Forms
• Managing data between applications

 Module 6: Error Handling, Testing and Maintenance

• Understanding flow failures
• Configuring Run After
• Using scopes
• Basic exception-handling techniques
• Monitoring flow runs
• Troubleshooting failed flows
• Testing automation solutions
• Modifying existing workflows
• Workflow documentation
• Maintenance best practices

Hands-On Workshop:  Develop an automated request-and-approval workflow using SharePoint, Outlook/Teams, and Power Automate.

 

DAY 3 – Microsoft Power Pages Intermediate 

Module 7: Introduction to Microsoft Power Pages

• What Microsoft Power Pages can do
• Common Power Pages business scenarios
• Internal versus external portals
• Power Pages architecture
• Understanding sites, pages, components, and data
• Power Pages Design Studio overview

 Module 8: Creating and Managing Business Websites

• Creating a Power Pages website
• Working with templates
• Creating and managing web pages
• Page hierarchy and navigation
• Adding sections and components
• Working with:
  • Text
  • Images
  • Links
  • Buttons
  • Forms
  • Lists
• Creating user-friendly interfaces
• Applying themes and branding
• Responsive website considerations

Module 9: Working with Data

• Introduction to Microsoft Dataverse
• Tables, columns, and records
• Connecting Power Pages to Dataverse
• Displaying business information
• Creating forms
• Editing and updating records
• Creating lists and views
• Capturing information from portal users

Hands-On Workshop:  Create a functional business self-service portal with pages, navigation, forms, and business data.

 

DAY 4 – Power Pages Security, Integration and Capstone Project 

Module 10: User Access and Security

• Power Pages authentication concepts
• Understanding site users
• Web roles
• Table permissions
• Page permissions
• Controlling access to portal content
• Controlling access to business data
• Security considerations for external-facing portals

 Module 11: Power Pages and Power Automate Integration

• Connecting portal activities to automated workflows
• Triggering business processes from submitted information
• Sending automated notifications
• Creating approval processes
• Updating records based on workflow results
• Integrating Power Pages, Dataverse, SharePoint, and Microsoft 365
• Practical integration scenarios

 Module 12: Managing and Maintaining Power Pages

• Updating website content
• Managing navigation
• Maintaining forms and lists
• Reviewing site configuration
• Basic troubleshooting
• Website administration considerations
• Publishing changes
• Maintaining business websites independently