Live Developer Training starts 5 October 2026. Seats are limited.Live training starts 5 OctReserve your seat →Reserve →
View Courses
Self-paced video course · with a 13-times Microsoft MVP

Power Automate Training Course

Automate approvals, notifications and SharePoint processes with cloud flows, expressions, AI Builder and Power Automate Desktop.

5 modules25+ hours of video78 topicsSource files & PDFs
Get 1-year All-AccessSee the curriculum
Includes all 8 courses and 50+ solutions for 12 months.
What you’ll learn

Skills you can use on real projects

Every module is hands-on, built from the problems Bijay solves for clients.

  • Choose the right flow type and understand licensing, environments and connectors
  • Write expressions and control logic with conditions, loops, scopes and try-catch
  • Build approvals with multiple levels, Teams, Forms, reminders and escalations
  • Work with SharePoint triggers, OData filters and large lists
  • Use AI Builder prebuilt and custom models, and prompts, inside flows
  • Automate Excel, PDF, Outlook and web tasks with desktop flows (RPA)
Curriculum

Power Automate course curriculum

5 modules and 78 topics. Open a module to see every topic.

Module1

Introduction to Power Automate, Licensing & Connector Fundamentals

15 topics
  1. What is Power Automate and Why Use It?
  2. Types of Flows: Automated, Instant, Scheduled & Desktop Flows
  3. Power Automate Licensing, Pricing & Subscription Overview
  4. Power Platform Environments for Power Automate
  5. Accessing Power Automate (Web Portal & Mobile App)
  6. Navigating Power Automate Home Interface
  7. Understanding Cloud Flow Designer
  8. Introduction to Connectors in Power Automate
  9. Standard vs Premium Connectors (Key Differences)
  10. Common Connectors (SharePoint, Dataverse, Excel, Outlook, Teams, OneDrive)
  11. Working with Solutions in Power Automate
  12. Authentication Types (OAuth, API Keys, Service Accounts)
  13. Creating Flows Using Copilot & Templates
  14. Creating Flows from Scratch (Blank Flows)
  15. Flow Triggers, Actions, Monitoring & Error Handling Basics
Module2

Power Automate Expressions, Logic & Control Flow

15 topics
  1. Introduction to Power Automate Expressions
  2. Expression Syntax & Working Mechanism
  3. Dynamic Content vs Expressions
  4. Using Compose Action for Testing Expressions
  5. Working with Variables in Power Automate (Initialize, Set, Increment, Append)
  6. Control Actions Overview (Condition, Switch, Scope)
  7. Condition Control for Decision Making
  8. Switch Control for Multi-Condition Logic
  9. Apply to Each (Looping through Arrays)
  10. Do Until Loop for Repeated Execution
  11. Scope Action for Grouping Logic
  12. String Functions (concat, split, replace, trim, etc.) in Power Automate
  13. Power Automate Array Functions (length, join, first, last, contains)
  14. Date & Time Functions (utcNow, addDays, formatDateTime) in Power Automate
  15. Error Handling & Try–Catch Pattern Using Scopes
Module3

Power Automate Approvals & SharePoint Integration

18 topics
  1. Overview of Power Automate Approval Processes
  2. Types of Approval Flows (First to Respond, Everyone Must Approve)
  3. Building Basic Approval Flows
  4. Multi-Level Sequential Approvals
  5. Power Automate Approval Custom Response
  6. Capturing Approval Responses & Comments
  7. Reassigning, Escalating & Cancelling Approvals
  8. Power Automate reminder implementation
  9. Approval Integration with Microsoft Teams
  10. Approval Flows with Microsoft Forms
  11. Customizing Approval Emails
  12. Monitoring Approval History
  13. SharePoint Triggers (Create, Modify, Delete Items)
  14. Creating & Updating SharePoint List Items
  15. Managing SharePoint Files (Upload, Move, Delete, Rename)
  16. Trigger Conditions in Power Automate
  17. Using OData Filters & Get Items Optimization
  18. Working with SharePoint Person, Lookup & Large Lists Handling
Module4

Power Automate AI Builder, Prompting & Intelligence

15 topics
  1. Introduction to AI Builder & Power Automate AI Capabilities
  2. Understanding Prompts in Power Platform
  3. Creating & Managing Prompts (Edit, Share, Delete)
  4. Using Prompts Inside Power Automate Flows
  5. Overview of AI Builder & Its Use Cases
  6. Types of AI Models in AI Builder
  7. How AI Builder Works (Training, Inputs, Outputs, Confidence Score)
  8. AI Builder Licensing & Credits Overview
  9. Prebuilt AI Models Overview
  10. Using Prebuilt Models in Flows (Invoice, Form, Text Recognition)
  11. Custom AI Models Introduction
  12. Prediction Model (Training & Publishing)
  13. Category Classification Model
  14. Document Processing Models (Invoices, Receipts, Forms)
  15. Object Detection AI Model for Automation Scenarios
Module5

Power Automate Desktop (RPA) & Real-World Automation

15 topics
  1. Introduction to Power Automate Desktop (PAD)
  2. Cloud Flows vs Desktop Flows (RPA Concept)
  3. Installing & Setting Up Power Automate Desktop
  4. PAD Interface Overview & Key Components
  5. Connecting Desktop Flows with Cloud Flows
  6. Understanding Variables & Data Types in PAD
  7. Creating Your First Desktop Flow
  8. Working with Control Actions (If, Loop, Switch)
  9. Excel Automation (Read, Write, Update Data)
  10. Data Table Management in Desktop Flows
  11. PDF Automation (Extract, Merge, Split Data)
  12. Email Automation Using Outlook Actions
  13. SharePoint Automation from Desktop Flows
  14. Web Automation & Data Scraping
  15. Exporting, Importing & Managing Desktop Flows
All-Access membership · 1 year

Every course and every solution, for one full year

This course is part of the All-Access membership. One membership unlocks all of these for 12 months, so you can move from one skill to the next without paying again.

Get 1-year All-Access
One payment · no automatic renewal · secure checkout on SPGuides Academy
What you get for one year

Everything included in All-Access

  • All 8 video courses: SharePoint Online, SPFx, PowerShell, Power Apps, Power Automate, Power BI, Copilot Studio and Power Pages
  • 50+ ready-to-use Power Platform and SPFx solutions to download and reuse
  • Every new lesson and solution added during your year
  • Full learning resources: PDFs, source files and code
  • WhatsApp group and private community access
  • Dedicated mentor support
  • Monthly live sessions and webinars
  • Interview preparation, placement support and real projects
  • One payment for 12 months, with no automatic renewal
Student reviews

What learners say about training with Bijay

★★★★★
The training covers concepts from the basics to the advanced, and it was a great help in my current SharePoint Online development project. Bijay is always ready to help with any queries, whether about the course or your project. He is a great tutor.
Deepa
DeepaSr. SharePoint Consultant
★★★★★
Bijay not only clearly knows his subject, he makes the content interesting and delivers it with great real-world examples of where it works and where it doesn’t. I will highly recommend this training to everyone.
Siva
SivaSr. SharePoint Tech Lead
★★★★★
You can see the dedication and detail put into each module. I don’t think there is a more complete SharePoint training course in the market.
Gerson Almonte
Gerson AlmonteSharePoint Developer
★★★★★
A very helpful course for SharePoint developers. I learned new things within the first 3–4 lectures, and even the small details of lists and libraries are covered.
Reshma Bhalekar
Reshma BhalekarSenior SharePoint Developer
Bijay Kumar, 13-times Microsoft MVP
Your instructor

Bijay Kumar

13-times Microsoft MVP · Founder, TSinfo Technologies

Bijay has more than 18 years of hands-on experience with Microsoft technologies, specializing in SharePoint, the Power Platform, SPFx and Microsoft 365. He has trained thousands of developers and IT professionals through SPGuides, wrote “SharePoint Online Modern Experience Practical Guide”, co-wrote “Microsoft Power Platform: A Deep Dive”, and runs the SPGuides YouTube channel. Every lesson comes from real client projects.

MVP profileLinkedInAbout BijaySPGuides YouTube
FAQ

Frequently asked questions

Who is this Power Automate training course for?

This course is ideal for IT professionals, business users, analysts, and developers who want to automate repetitive tasks, approvals, and integrations across Microsoft 365 and other systems.

Do I need prior experience with automation or coding?

No. You don’t need RPA or coding experience. Basic familiarity with Microsoft 365 apps (like SharePoint, Outlook, and Teams) is enough; the course walks you through building flows step by step.

What types of workflows will I be able to build after this course?

You’ll be able to create flows for approvals, notifications, data collection, integrations with SharePoint, Forms, Outlook, Teams, and more, covering real business scenarios, not just simple demos.

Does the course cover best practices and advanced concepts?

Yes. Beyond basic flows, you’ll learn expressions, conditions, loops, error handling, solutions, and patterns used for professional, production-ready automation.

Will this Power Automate training help me in my current role or career?

Yes. Automating processes with Power Automate is a key skill for modern Microsoft 365 professionals, helping you save time, reduce manual work, and position yourself for Power Platform and automation-focused roles.

Can I buy the Power Automate course on its own?

Courses are part of the All-Access membership. One payment gives you all 8 courses, 50+ ready-to-use solutions, the community and mentor support for a full year, so you can add related skills later without paying again.

How long do I have access?

You get 12 months of access from the day you join, with no automatic renewal. Lessons and solutions added during your year are included, and the monthly live sessions and webinars run all year.

Start today

Learn Power Automate the practical way

Join All-Access and start this course today, then carry on with every other course and solution for a full year.

Get 1-year All-Access
Includes all 8 courses and 50+ solutions for 12 months.

Want to try the teaching style first?

Read the free Power Automate tutorials on SPGuides, or join the next free webinar.

Free Power Automate tutorialsFree webinars