
Program
Power Automate
Automate the busywork between your business tools
Learn to build automated workflows that move data and trigger actions across the tools your company already uses — no custom code required.
8
Weeks
40
Chapters
4
Practice formats
1
Portfolio artifact
8 weeks — one module per week (8 modules, 40 chapters), each week ending with a live class every Saturday, plus a module exam before the next module opens.
Curriculum
40 chapters across 8 modules — each with guided notes, a live example, a quiz, an exercise, a challenge, and class practice.
Module 1 · AUTOMATION FOUNDATIONS
- 1Introduction to Power AutomateWhat workflow automation is, the kinds of flows, connectors, where Power Automate fits in the Power Platform, and choosing what to automate first.Learn →
- 2Triggers, Actions & Dynamic ContentBuilding a first flow, trigger options and conditions, actions, dynamic content, testing and run history, and staying within request limits.Learn →
- 3Expressions, Variables & DataWorkflow expressions, common functions for text, dates, and logic, Compose and variables, arrays and JSON, and formatting data for people.Learn →
- 4Designing a Flow Before You Build ItMapping the process, defining trigger, inputs and outputs, naming, idempotent design, and the patterns that keep flows readable.Learn →
- 5Connectors, Connections & LicensingStandard vs. premium connectors, connections and who they run as, connector limits, data loss prevention groups, and estimating licence needs.Learn →
Module 2 · BUILDING FLOWS
- 6Conditions, Switches & LoopsBranching with Condition and Switch, looping with Apply to each and Do until, parallel branches, and keeping logic readable.Learn →
- 7Approval FlowsApproval types, sequential and parallel approvals, approvals in Teams and Outlook, reminders and escalation, recording outcomes, and measuring turnaround.Learn →
- 8Working with SharePoint, Excel & DataverseReading and writing lists, tables, and rows; OData filter queries; pagination and thresholds; avoiding duplicates; and moving data between systems.Learn →
- 9Notifications, Teams & Adaptive CardsDesigning useful notifications, email and Teams messages, adaptive cards that collect responses, digests versus alerts, and avoiding notification fatigue.Learn →
- 10Scheduled Flows, Time Zones & ReportsRecurrence triggers, time zones and daylight saving, batch processing, scheduled reports and digests, and making scheduled jobs dependable.Learn →
Module 3 · RELIABLE, GOVERNED AUTOMATION
- 11Error Handling & MonitoringWhy flows fail, configure run after, try/catch/finally with scopes, retry policies, terminate, alerting owners, and reading run history and analytics.Learn →
- 12Desktop Flows & RPARobotic process automation with Power Automate Desktop, attended vs unattended, UI and web automation, choosing API vs RPA, and making bots robust.Learn →
- 13Governance, Security & ALMConnections and ownership, service accounts, DLP policies, environments and solutions, connection references and environment variables, and documenting flows.Learn →
- 14Child Flows & Reusable AutomationBreaking big flows into child flows with inputs and outputs, reusing logic across flows, and organising automation in solutions.Learn →
- 15Performance, Concurrency & ThrottlingMaking flows fast and within limits: filtering at the source, apply-to-each concurrency, batching, pagination, throttling and trigger conditions.Learn →
Module 4 · DATA & DOCUMENT AUTOMATION
- 16Processing Excel & CSV FilesReading Excel tables and CSV files in flows, validating rows, transforming values, writing results back, and the limits of Excel as a data source.Learn →
- 17JSON, Parse JSON & Data OperationsUnderstanding JSON objects and arrays, Parse JSON with schemas, Select, Filter array, Join and Create HTML table — transforming data without loops.Learn →
- 18Calling APIs with HTTPREST basics, the HTTP action, headers and authentication, status codes and error handling, pagination, and when to build a custom connector instead.Learn →
- 19Generating Documents & PDFsCreating letters, certificates and reports from templates: Word templates, HTML to PDF, file naming, storage, and approvals with signatures.Learn →
- 20Dataverse Flow PatternsDataverse triggers with filters and scope, List rows with OData and FetchXML, upserts, relating rows, running as the triggering user, and avoiding loops.Learn →
Module 5 · EMAIL, FORMS & AI AUTOMATION
- 21Email Automation & AttachmentsShared mailbox triggers, filtering by sender and subject, saving attachments, routing messages, sending well-formatted emails, and avoiding mail loops.Learn →
- 22Forms, Surveys & Feedback AutomationMicrosoft Forms triggers, getting response details, storing answers, routing by answer, NPS calculation, and closing the feedback loop.Learn →
- 23AI Builder in FlowsExtracting invoice and form data, classifying text, sentiment, confidence thresholds, human review for low-confidence results, and measuring accuracy.Learn →
- 24Copilot & Generative AI in FlowsBuilding flows by describing them, using GPT prompts in flows (summaries, drafts, classification), prompt design, and guardrails for generated content.Learn →
- 25Process Mining: Find What to AutomateUsing event logs to see how processes really run: cases, activities, variants, cycle time, rework and bottlenecks — and turning findings into automation candidates.Learn →
Module 6 · DESKTOP FLOWS IN DEPTH
- 26UI & Web Automation in Desktop FlowsPower Automate for desktop: the recorder, UI elements and selectors, browser automation, waiting for elements, and making bots resilient to screen changes.Learn →
- 27Variables, Data Tables & Loops in Desktop FlowsDesktop flow variables and data types, data tables and lists, For each and Loop actions, conditions, subflows, and passing data to and from cloud flows.Learn →
- 28Excel & File Automation on the DesktopLaunching and reading Excel, writing results, working with folders and files, PDF text extraction, and when to use cloud Excel actions instead.Learn →
- 29Error Handling & Recovery for BotsOn block error, retry policies, screenshots and logs on failure, recovering applications to a known state, and alerting the right people.Learn →
- 30Unattended Bots, Machines & SchedulingMachines and machine groups, unattended run requirements, scheduling and queueing, capacity planning, and secure credentials for bots.Learn →
Module 7 · ENTERPRISE AUTOMATION
- 31Multi-Stage & Conditional ApprovalsSequential and parallel approval stages, routing by amount and department, delegation and out-of-office, approval audit trails, and approvals in Teams.Learn →
- 32Integrating Business SystemsSyncing CRM, ERP and HR systems: system of record, keys and mapping, one-way vs. two-way sync, change detection, conflict rules, and reconciliation.Learn →
- 33Event-Driven Automation & WebhooksTriggering flows from external events: webhooks and the HTTP request trigger, securing endpoints, validating payloads, responding quickly, and queue patterns.Learn →
- 34Monitoring & Analytics for AutomationFlow and desktop run analytics, success rate and duration trends, central error logging, alerting, dashboards for owners, and the CoE Starter Kit.Learn →
- 35Security, Identity & Service AccountsLeast privilege for flows, service accounts vs. personal connections, sharing and co-ownership, run-only users, secrets management, and audit trails.Learn →
Module 8 · AUTOMATION PRACTICE, CAREER & CAPSTONE
- 36Finding & Prioritising Automation OpportunitiesDiscovering candidates with users and data, scoring value vs. effort, calculating ROI and payback, and building an automation backlog.Learn →
- 37Documentation & HandoverWhat to document for every automation, solution design documents, runbooks, user guides, and handing over to support teams.Learn →
- 38Certification Preparation (PL-900 & PL-500)Power Platform Fundamentals (PL-900) and Power Automate RPA Developer (PL-500): skills measured, study plans, hands-on practice and exam strategy.Learn →
- 39Automation Career & PortfolioAutomation roles and career paths, building a portfolio of flows, describing impact on your CV, and preparing for interviews and practical tests.Learn →
- 40Capstone: Automate a Manual Task End to EndDesign, build, test, and document a working flow that replaces a real manual task end to end, with visible error handling.Learn →
Delivery
Blended — self-paced lessons plus live build sessions
Portfolio outcome
A working automated flow that replaces a real manual task end to end, with visible error handling.
Certificate
Certificate of completion, verifiable online with its credential code.
By the end of this program, you'll be job-ready to…
- Turn a manual, repetitive task into a triggered automated flow
- Build branching logic and approval routing that mirrors real business rules
- Design flows that fail visibly instead of silently
Salary expectations
Estimated U.S. national average annual salary by experience level.
$65,000
Entry-level
$95,000
Mid-level
$130,000
Senior-level
Estimated figures for planning purposes — actual pay varies by location, employer, and experience.
Tools you'll master
Practical training, every chapter
- A live "try it yourself" example in every chapter you can run immediately
- A hands-on exercise per chapter, with hints and a reveal-able answer
- An open-ended challenge per chapter, graded against real success criteria
- Class practice prompts for pairs or cohorts, not just solo homework
Why take this program
Interview- and job-ready
Built to the same bar Aicloud actually hires against — not a generic syllabus.
Tier 1 company partners
Program partnerships with leading employers are in progress — see Affiliation for status.
Job connection access
Graduates get access to Aicloud's own hiring pipeline and employer referral network.
Professional networking
Cohort discussion boards and live sessions connect you with peers and mentors, not just content.
A real portfolio
You leave with a concrete, explainable artifact — proof of knowledge, not just a certificate.