Course Overview

This Level 1 program develops practical Power Automate skills through progressively structured business scenarios. Participants begin with core cloud-flow concepts and move into conditions, scheduling, JSON, data operations, arrays, data transfer, conflict validation and approvals. Dynamic Content and expressions are taught inside the flows where they are actually required, keeping the course practical and application-focused.

 

 Create automated, scheduled and business-triggered cloud flows.
 Use Dynamic Content and expressions to work with data produced by previous actions.
 Build decision logic using Conditions and Switch.
 Understand JSON output and extract structured values using Parse JSON.
 Use Compose, Select, Filter Array and Create HTML Table for data transformation.
 Work with arrays, grouping, filtering and structured data movement.
 Validate business rules before creating records or calendar bookings.
 Build a complete single-stage approval process with status tracking.

FOUNDATION – Introduction & Fundamentals

LOGIC – Conditions, Switch & Expressions

DATA – JSON, Operations & Arrays

BUSINESS FLOWS – Validation, Transfer & Approval

LEVEL 1

1. Introduction to Power Automate

Automation and business use cases
 What Power Automate is
 Why organizations automate repetitive business processes
 Examples of workflows participants will build during the course.

2. Power Automate Fundamentals

Triggers, actions, connectors, flow types
 Automated, Instant and Scheduled cloud flows
 Triggers, actions, connectors and connections
 Flow designer, testing, run history, inputs and outputs.

3. Case Study: Employee Leave Request + Dynamic Content

Capture requests using dynamic values
 Capture leave details from Microsoft Forms
 Create and update a SharePoint record
 Use Dynamic Content from previous flow actions.

4. Case Study: Daily Sales Report + Expressions

Scheduled reporting and expressions
 Run a flow on a recurring schedule
 Prepare a daily business summary
 Introduce expressions such as utcNow() and formatDateTime() in context.

5. Case Study: Pre-Meeting Reminder with Attachment

Timed reminders and attachments
 Work with Outlook Calendar meeting information
 Retrieve a supporting file and attach it to an email
 Format meeting date and time for a clear reminder.

6. Case Study: Sales Lead Qualification & Follow-Up

Conditions and business decision logic
 Evaluate leads using business criteria such as budget and timeline
 Use AND / OR logic and multiple decision paths
 Set lead priority and trigger different follow-up actions.

7. Case Study: Employee Service Desk – Switch

Multi-path request routing
 Route requests by service category
 Use Switch cases instead of repeated Conditions
 Apply different actions for IT, HR, Payroll or Facilities requests.

8. Understanding JSON & Parse JSON

Read and extract structured data
 Understand objects, arrays, properties and values
 Inspect JSON output produced by Power Automate actions
 Generate a schema and access parsed values.

9. Data Operations

Compose, Select, Filter, tables
 Use Compose for intermediate values
 Use Select and Filter Array to transform data
 Create readable HTML tables from arrays.

10. Case Study: Outlook Calendar Change Monitoring

Transform and summarize event data
 Retrieve events from a defined time window
 Transform event details using Select and date expressions
 Create and email a readable calendar summary.

11. Case Study: Automated Task Reminder

Arrays, filtering and grouping
 Filter SharePoint tasks by status and due date
 Build and deduplicate email arrays
 Group multiple tasks into one consolidated reminder.

12. Case Study: Excel Table to SharePoint List

Transfer structured business data
 Read structured rows from an Excel table
 Process multiple records using Apply to each
 Create corresponding items in a SharePoint list.

13. Case Study: Meeting Room Booking & Conflict Prevention

Validate availability and prevent conflicts
 Check existing bookings before accepting a new request
 Detect overlapping date/time ranges
 Create a booking only when the requested slot is available.

14. Case Study: Employee Purchase Request & Manager Approval

Approval decisions and tracking
 Submit a purchase request for manager approval
 Branch the flow using Approve / Reject outcome
 Update request status and retain approval decision details.