Learn Power Automate Step By Step With projects - Course Introduction

Course overview (what the tutorial/course is)

• The video introduces a Power Automate course built from the instructor’s real-world projects, not hypothetical examples.
• Participants will receive actual source code plus exercises that can be reused inside their own organizations.
• The course uses real-time, hands-on examples to explain basic concepts and then apply them in projects.

Course structure

The course is divided into two parts, with an optional section.

Optional section: Set up Microsoft 365 (M365)

• If required to work with Power Automate, the course includes guidance for setting up an M365 environment.

Part 1: Power Automate basics + a full project

Topics include:

• Flow types
• Flow templates
  • What they are
  • How to use them
• Create flows and understanding connectors
• How to create a maintainable flow (noted as divided into two parts)
• Variables
  • Create and use
• Compose operation
  • How it differs from variables
• A guided project building an “Excel Uploader Tool”, including:
  • Excel uploader tool overview and requirements
  • Working with REST API (explained within the project)
  • Using the Excel Online connector to build the tool
  • Data operations: Filter and Select
  • Looping: using Apply to each
  • Try/catch-like error handling (since try/catch isn’t directly available)
  • Run history URL generation for debugging
    • Emphasis on using this across environments such as Dev and Production
  • Custom error logging
    • Because Run history expires after 28 days, the course shows how to store errors for audit purposes
  • Trigger conditions
  • Conditional control (logic handling in flows)

Part 2: Real-time approval projects

Projects include:

• Basic Approvals
  • Understanding the approval system in Power Automate
• A project to create multi-level dynamic approvals (“multi-level Dynamic serial flow”)
• A project for conditional approval flow
• A final configurable approval flow project:
  • Implementing a configurable approval system
  • Adding a reminder system feature within the approval workflow

Key product/feature concepts highlighted

• Practical flow construction focused on:
  • Maintainability
  • Connectors
  • Templates
• Debugging and operational support:
  • Run history URL for environment-based debugging
  • Custom error logging to preserve errors beyond 28-day retention
• Data handling capabilities:
  • Filter and Select operations
  • Distinguishing variables vs Compose
• Flow control and robustness:
  • Apply to each loops
  • Error handling patterns resembling try/catch
  • Trigger conditions and conditional control
• Approval workflow capabilities:
  • Approvals
  • Multi-level dynamic serial flows
  • Conditional approvals
  • Configurable approval system
  • Reminders in approval processes

Main speaker / sources

• Primary speaker: An instructor/author referred to as “guys” in narration (no name given in the subtitles).
• Source content: The course created by this instructor (real projects + provided source code and exercises).