Automating Tasks With Power Automate

Disclaimer:
This training topic is currently available for in-house sessions only, with a minimum requirement of 5 participants. Public program sessions are not available at the moment. The public program date will be announced when scheduled.

Course Overview for Automating Tasks With Power Automate

Automating Tasks With Power Automate, Learn to build practical cloud and desktop flows for reminders, notifications, approvals, data extraction, Excel tasks and end-to-end business workflows.

Course Objectives

  • Build scheduled, automated and instant cloud flows using triggers, actions, conditions, loops and connectors.
  • Automate notifications and approvals across Forms, OneDrive, SharePoint, Outlook, Teams and Excel.
  • Create desktop flows to extract text with OCR, consolidate Excel files, send email and run an Excel macro.
  • Use variables, expressions, time functions and error handling; build monitored workflows with SLA escalation and multi-level approvals; apply selected Copilot features to assist with flow creation and documentation.

Who Should Attend

This Automating Tasks With Power Automate programme is suitable for finance and shared services teams, business analysts, project managers, IT professionals and administrative staff who want to automate repetitive work across Microsoft 365 and desktop applications.

Group training is limited to 20 pax only.

Methodology

The Automating Tasks With Power Automate course is a hands-on workshop led by an instructor. You will apply what you learn immediately by completing mini projects throughout the session.

Setup Requirements

  1. Use a Windows computer with a browser and desktop Excel for the desktop exercises.
  2. Download and install Power Automate for desktop before class at https://go.microsoft.com/fwlink/?linkid=2102613.
  3. For online learning, use two computer screens to better manage the learning experience.

Difficulty Level

Intermediate

Duration

3 days

Course Content

1. Power Automate And Power Platform Environments

  • Understand the Power Platform ecosystem, workflow automation and robotic process automation (RPA).
  • Distinguish cloud flows from desktop flows and identify tasks suited to each approach.
  • Recognise Power Platform environment types and select the appropriate environment for your exercises.
  • Navigate the web portal and desktop designer; identify flows, connections and run history.
  • Distinguish Save, Save draft and Publish where available, including drafts and publishing for solution-aware cloud flows.

2. Building And Managing Cloud Workflows

  • Select scheduled, automated or instant flows according to how the task should start.
  • Build a flow from a trigger and actions; configure connectors, connections and action inputs.
  • Use dynamic content to pass results from one action into another.
  • Apply Condition and Switch to route work according to business rules.
  • Use Apply to each to process a collection and Do until to repeat actions until a condition is met.
  • Name flows and actions clearly; document each exercise using Flow Overview, Triggers and Actions.

3. Variables Functions And Time Handling

  • Choose variable types including string, integer, float, Boolean, array and object.
  • Initialise and update variables; append values and use expressions alongside dynamic content.
  • Apply useful functions to combine text, compare values, handle missing values and perform calculations.
  • Use time-related functions such as utcNow, formatDateTime, addDays and convertTimeZone.
  • Configure recurrence frequency, start time and time zone for scheduled reminders.
  • Check expression results and distinguish a displayed date format from the underlying date and time value.

4. Scheduled Reminders And Recurring Messages

  • Create a scheduled flow to send reminders through Outlook and Microsoft Teams.
  • Post recurring Teams messages and record results in an Excel table.
  • Configure Teams message attributes, including whether to post in a chat or a channel.
  • Map action outputs to Excel columns and verify the recorded results.

5. OneDrive And SharePoint Notifications

  • Send an Outlook notification when a new file is created in OneDrive.
  • Apply conditions to notify recipients only when a specified file or matching file is created.
  • Send email when a new file is created in a SharePoint document library.
  • Post a Teams notification when a file is changed in SharePoint.
  • Create a SharePoint list for an exercise and send email when a list item changes.
  • Distinguish file events from list item events; check which details the trigger returns.

6. Forms Responses And Approval Workflows

  • Retrieve a submitted Forms response and send email and Teams notifications.
  • Use a condition to alert the team when feedback or review scores meet a poor-rating threshold.
  • Compare approval types, including first to respond, everyone must approve and custom responses.
  • Create an approval flow for a Forms submission and route the result using the approval outcome.
  • Create an approval process for changes to a SharePoint list item.
  • Capture approver responses and comments; send outcome notifications and update the relevant record.
  • Explore sequential approval steps and calendar event creation as extensions to the core examples.

7. Instant Flows Testing And Copilot Assistance

  • Build an instant flow to send business reporting emails from a list of records.
  • Loop through records and map recipient details and message content into the email action.
  • Test flows and inspect action inputs, outputs and failed steps in run history.
  • Correct connection, data and expression errors; introduce run-after settings for failed actions.
  • Use available Copilot features to assist with generating, explaining and refining flows; review the result before use.

8. Power Automate Desktop Foundations

  • Navigate the actions pane, workspace and variables pane; create and run a desktop flow.
  • Use variables, lists and data tables to store and pass data between actions.
  • Apply If, Loop and For each to control desktop flow execution.
  • Work with file paths and folders; launch applications and organise reusable steps into subflows.
  • Run selected actions, use breakpoints and inspect variable values when debugging.

9. Extracting Text With OCR And Handling Errors

  • Extract text from an individual image using optical character recognition (OCR).
  • Retrieve image files from a folder and use For each to process them in sequence.
  • Store extracted text and check its accuracy against the source image.
  • Configure action or block error handling and use an error-handling subflow.
  • Test how the flow responds to an unreadable image or an unsuccessful extraction.

10. Desktop Excel Consolidation Email And Macros

  • Launch Excel and read data from workbooks into variables or data tables.
  • Retrieve Excel files from a folder and append their records into a blank destination workbook.
  • Manage headers and the next available row so appended data is not overwritten.
  • Save and close the workbooks; check row counts and source totals against the consolidated output.
  • Send an email through the desktop Outlook application in the supplied exercise.
  • Run an existing Excel macro from a desktop flow and verify the resulting workbook changes.

11. End-To-End Business Workflow Design

  • Design a complete workflow across multiple stages rather than a single automation task.
  • Create a finance service request using Microsoft Forms and SharePoint.
  • Capture request information and maintain the request status in a SharePoint list.
  • Use Switch to route requests according to business categories such as Accounts Payable, Accounts Receivable, Vendor and General Ledger.
  • Assign requests to the appropriate person or team; apply priority and exception rules.
  • Update request status as the workflow progresses and send Outlook or Teams notifications at appropriate stages.
  • Route requests that do not meet predefined rules for manual review and test the complete process from submission to completion.

12. SLA Monitoring And Escalation Workflows

  • Create a scheduled flow to monitor outstanding requests and retrieve open records from SharePoint.
  • Calculate the age of outstanding requests using date expressions and compare elapsed time against defined SLA targets.
  • Identify requests approaching or exceeding SLA and determine when escalation is required.
  • Send reminders to responsible users and escalate overdue requests to the appropriate manager or team.
  • Update escalation information in SharePoint and prevent unnecessary repeat escalation.
  • Use multiple flows to support different parts of the same business process and data source.

13. Advanced Multi-Level Approvals And Exceptions

  • Build approval routing according to transaction value or other business criteria.
  • Determine dynamically which approval levels are required and create sequential approval stages.
  • Route requests to different approvers according to approval limits and stop subsequent stages when a request is rejected.
  • Capture approval outcomes and approver comments; update the underlying SharePoint record after approval decisions.
  • Notify the requester of approval or rejection and route exceptional transactions for separate review.
  • Maintain approval information for audit and follow-up purposes.

14. Choosing An Automation Approach And Wrap-Up

  • Compare Power Automate cloud flows, desktop flows, Power Query, VBA and manual workflows.
  • Choose cloud flows for connected service events and desktop flows for local application tasks.
  • Identify when Power Query suits data transformation and when an existing VBA macro can be reused.
  • Review practical limitations, dependencies and the checks needed before reusing a flow.

Course Schedule

Day 1

TimeTopics
9AM–10:30AMPower Platform and environments; cloud versus desktop flows; portal walkthrough; Save, draft and Publish; triggers, actions and connectors.
10:30AM–12:30PMConditions and loops; variables, expressions and time functions; scheduled Outlook and Teams reminders; recurring messages and Excel logging.
12:30PM–1:30PMLunch
1:30PM–3PMOneDrive and SharePoint file notifications; file filters; Teams chat and channel messages; SharePoint list change notifications.
3PM–5PMForms response notifications; poor-feedback alerts; approval types; Forms approval workflow; testing and reviewing run history.

Day 2

TimeTopics
9AM–10:30AMSharePoint list approval workflow; instant emails from a list; calendar event and sequential approval extensions; Copilot assistance and troubleshooting.
10:30AM–12:30PMDesktop designer walkthrough; variables, lists and data tables; If, Loop and For each; subflows; OCR from an image and a folder.
12:30PM–1:30PMLunch
1:30PM–3:30PMDesktop error handling; consolidate Excel files from a folder; save and validate the output; desktop Outlook email and running an Excel macro.
3:30PM–5PMDebugging and validation; adapt a workflow to your work; review completed cloud and desktop flows.

Day 3

TimeTopics
9AM–10:30AMEnd-to-end business workflow design; finance service requests; Forms and SharePoint; categorisation, routing, assignment, status management and notifications.
10:30AM–12:30PMContinue the service-request workflow; exception routing and testing; build scheduled SLA monitoring, reminders and escalation.
12:30PM–1:30PMLunch
1:30PM–3PMSLA monitoring continued; ageing calculations, escalation levels, status updates and testing multiple flows supporting the same process.
3PM–5PMAdvanced multi-level approvals; conditional approval routes, sequential approvals, rejection paths and exception handling; choosing the appropriate automation approach and course wrap-up.

How To Submit an Enquiry to Us?

  1. Fill in the form below and submit to us.
  2. Initiate a conversation via live chat on the bottom left of our website by stating: “Hi, my name is [your-name]. I’ve already submitted the form for this training.”
  3. We’ll promptly reach out to you regarding the training you’re interested in.

HRD CORP

✅ 100% HRD Corp Claimable Training Programmes

Unlock fully claimable training designed to elevate skills, performance, and workplace capability — with no upfront payment required for eligible companies under the HRD Corp SBL-Khas scheme.

We are a registered HRD Corp training provider, ensuring a seamless claim process handled from application to approval.

Empower your workforce. Maximise your HRD Corp levy. Train with confidence.

Simple 4-Step Process:

Get trained in 4 easy steps

From first contact to post-training claim – we make the entire journey seamless and stress-free.

1
Contact Us
Reach out via WhatsApp, Email, or our Enquiry Form to discuss your training needs and company goals
2
Confirm Program
We recommend the right program and schedule - public or customized - to fit your team, timeline and budget.
3
We Assist with HRD Corp Process
Our team prepares documents for grant applications for your convenience
4
Train & Claim
Attend the training receive your certificate, and we submit the course fee claim after training

Program Enquiry Form

    ORGANIZATION DETAILS








    PERSON-IN-CHARGE DETAILS






    FOR FURTHER INFORMATION, PLEASE CONTACT US!

    Thank you