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
Your 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
