Power Automate Course – Level 1
Build cloud flows with triggers, conditions, expressions and approvals using Outlook, Forms, Excel and SharePoint
Power AutomateOutlookFormsSharePoint
₹15,00015 hrs · Classroom fee
Course content
What you'll learn
25 modules across Level 1 and Level 2 (Advanced), each built around a real business flow.
Power Automate Level 1Your first 14 hands-on flows, from the basics to real business processes.
Foundation
1
Introduction to Power Automate
What Power Automate is, why organisations automate and example workflows
2
Power Automate fundamentals
Automated, instant and scheduled cloud flows; triggers, actions and connectors; the flow designer, testing and run history
Logic
3
Leave request with dynamic content
Collect a request in Microsoft Forms, save it to SharePoint and use dynamic content
4
Daily sales report with expressions
A scheduled flow that sends a daily summary, using utcNow() and formatDateTime()
5
Pre-meeting reminder with attachment
Read Outlook Calendar events, attach the right file and format dates
6
Sales lead qualification and follow-up
Conditions with AND/OR logic to set lead priority and trigger follow-ups
7
Employee service desk (Switch)
Route requests by category: IT, HR, Payroll and Facilities
8
JSON and Parse JSON
Objects, arrays and properties; generate a schema and use the parsed values
Data
9
Data operations
Compose, Select, Filter Array and HTML tables
10
Outlook calendar change monitoring
Get events in a time window, transform the data and email a summary
11
Automated task reminder
Filter SharePoint tasks, remove duplicates and group tasks by owner
12
Excel table to SharePoint list
Read Excel rows with Apply to each and create SharePoint items
Business flows
13
Meeting room booking and conflict prevention
Check existing bookings, detect overlaps and book only free slots
14
Purchase request and manager approval
Send for approval, branch on Approve or Reject, and keep a status and decision record
Power Automate Level 2 (Advanced)Reusable, connected automation built the way companies run it in production.
Advanced flows
15
Company car sequential approval
Multi-level approvals (Line Manager, HR, Fleet), dynamic approvers from an approval matrix, audit trail, rejections and timeouts
16
Email attachment document routing
Process Outlook attachments and route documents to SharePoint by business rules, with status tracking
17
Error handling and troubleshooting
Run history analysis, Scope and Configure Run After, nulls and bad data types, and Terminate
18
Employee access provisioning (parent and child flows)
Reusable child flows, passing parameters, access-matrix logic and returning results
19
Inventory reorder and stock threshold control
Threshold checks, detect existing requests and create reorder requests without duplicates
20
Employee offboarding and asset recovery
Retrieve assigned assets, keep return records in SharePoint and block offboarding until assets are cleared
Capstone project
21
Capstone 1: exception intake and assignment
Log and validate exceptions, assign them with a routing matrix and calculate SLA deadlines
22
Capstone 2: SLA monitoring and escalation
Scheduled checks, find overdue cases, escalate and use flags to prevent repeat escalations
23
Capstone 3: resolution and outcome
Detect resolution updates, measure SLA compliance, record outcomes and prevent trigger loops
24
Capstone integration and testing
End-to-end testing of normal, breached, missing-routing and already-escalated cases
Deployment
25
Environments and solutions
Default, Developer, Sandbox and Production environments; solution-aware flows, connection references, environment variables and moving from Dev to Test to Prod
