WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Classroom training -  Introduction to Power Automate

Classroom Training

Power Automate Introduction 2-day training course

Classroom training course - online version also available

£850 + VAT for most venues (£995 + VAT for London)

2 days

This two-day course will show you how to get your computer to do your tedious day-to-day work for you (always an attractive idea), with topics covered including automating your use of OneDrive, Excel 365, SharePoint, Power BI, SQL Server and Teams.  You'll also lean how to create and manage online surveys using Forms, and much more!

Course details

  • Locations for Introduction to Power Automate coursesPossible locations:London, Manchester, Online
  • Next Introduction to Power Automate course locationNext classroom course:Mon 07 November 2022
  • Introduction to Power Automate course timesTime:09:30-16:30

Course Contents

The contents of this course are as follows:

Getting started

  • What Power Automate is and does
  • Software licensing overview
  • Logging on

Creating flows

  • Using templates
  • Creating new flows
  • Viewing the underlying JSON

Basic flow concepts

  • Adding actions
  • Understanding triggers
  • Setting variables

Conditions and loops

  • Syntax of conditions
  • Condition groups
  • Switch statements
  • Types of loop

Basic expressions

  • Syntax of expressions
  • Common functions

Automating Excel 365

  • Signing on to Office 365
  • Common Excel actions


  • Linking to email servers
  • Creating flow rules
  • Downloading attachments
  • Working with Outlook

Files and folders

  • OneDrive, DropBox, etc
  • Copying and moving files
  • Other file/folder operations


  • Linking to SharePoint
  • Working with SharePoint lists
  • Copying and moving files
  • Storing data in SharePoint


  • The Teams bot
  • Connecting to Teams
  • Posting content
  • Adding calendar items


  • SQL Server gateways
  • Linking to Azure
  • Connecting to databases
  • Retrieving/changing data


  • Creating online forms
  • Types of input
  • Publishing surveys
  • Processing replies

Covered if time allows If time

Approval flows

  • Automated vs instant
  • Managing approval flows
  • Sequential vs parallel

Handling errors

  • Debugging techniques
  • Logging errors

Power Platform integration

  • Linking to Power BI
  • Linking to Power Apps

Because for both online and classroom courses you'll be using our computers, you won't need to install any software to attend this course, but you will get more out of the two days if you have some familiarity with Teams, Power BI and/or SharePoint.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Pacing and level of course was spot on. Right mix of professionalism and humour."

Mark Tyrie (Waltham Forest Council)

"We managed to complete about 4 days in 2 which is an achievement as our trainer made the course enjoyable and made you feel any question you asked was relevant. No doubt the course manual will be very useful!"

Trish Boateng (Derby and Burton Hospitals NHS FT)

"I thought the training was fantastic and the trainer very engaging. It is great to have the manual and the SQL scripts as a resource to refer to!"

Natalie Friend DuPreez (Department of Health and Social Care (DHSC))

"For our team we have been searching for a good quality course to teach us PowerBI and I and my colleague left the course last week genuinely excited about what we can achieve using the available data and all of the functionality in PowerBI. The course was well structured and pitched at exactly the right level, in terms of existing knowledge. I was very happy with the course and felt that it fulfilled my/our needs perfectly. Other colleagues in the department had already been on the course and recommended it so were keen to get places when our colleague advised us he was setting up more sessions."

Ian Hawkins (Derby and Burton Hospitals NHS FT)

"Completely changed my understanding of working with data."

Deepak Thakur (Government Internal Audit Agency (GIAA))

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Introduction to Power Automate training dates

Here are the classroom Introduction to Power Automate courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Tue 07-08 November 2022 2 £850 Book places
Date(s) Venue

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power Automate training at your offices (we'll even provide and set up the computers).

Related Courses

Power Automate Desktop RECOMMENDED

Power Automate Desktop

2 day course

Advanced Power Automate

Advanced Power Automate

2 day course

Other Power Automate training resources

Power Automate exercises

Power Automate exercises

We have the following Power Automate exercises available.

View Power Automate Desktop exercises

Power Automate blogs

Power Automate blogs

You can read the following blogs on Power Automate.

View Power Automate Desktop or Power Automate blogs

This page has 0 threads Add post