Training course

Microsoft Power Apps and Power Automate Essentials

Are you ready to unlock the potential of the Power Platform? Our beginner-friendly course will empower you to build applications using Microsoft’s powerful suite of tools. Whether you’re a non-technical enthusiast or a budding developer this course is tailored for you.

Since this is a beginner's course we will cover two of the four Power Platform tools within the course curriculum Power Apps and Power Automate. You will also learn to integrate with common Office 365 products such as Outlook and One Drive.

  • 2 Days
  • Online or in person
  • Private courses available
Download outline (PDF)

Course Objectives

  • During this 2 day Power Platform course you will learn:
    1. Power Apps Essentials:
    Create mobile and desktop applications effortlessly.
    Explore hands-on demonstrations of Power Apps features.
    Integrate with common Office 365 products like Outlook and OneDrive.
    2. Power Automate Basics:
    Set up background automation using Power Automate.
    Learn how to streamline processes and workflows.
    By the end of this course you’ll have the confidence to design build and deploy applications within your organization.

Included

  • Lunch and refreshments when training is delivered at our training venues
  • Comprehensive course materials and exercises
  • Telephone and Email Support

Software Version

This course will be delivered using the PowerApps browser version available via the Office 365 Enterprise licencing scheme.

Course content Back to top

  1. Introduction
    Welcome and Overview
    Different types of app
    What is Power Automate What is the dataverse
  2. Power Apps Maker Environment/Studio
    Accessing Apps
    Where to build apps from
    Solutions
    Flows and tables
    Dataflows
  3. Navigating the studio
    Introduction
    Left navigation panel
    Design area
    Object properties
    Formula bar
    Review
  4. Creating an app from existing data
    Excel
    SharePoint list
    Dataverse table
    Copilot
  5. Actions
    Navigation
    Store temporary data
    Select
    Start a flow using a button
  6. Data Views
    Data sources
    Canvas apps
    Collections
    Variables
  7. Power FX
    introduction
    Excel vs PowerFX
    Reference guide
    Maths functions
    Using App maker
    Examples of FX formulas
  8. Dataverse
    Tables
    Forms
    Views
    Relationships
    Processes
    Rules
    Creating columns
    Types of columns
  9. Forms and Views
    Introduction
    Creating views
    Creating forms
  10. Business rules
    Introduction
    Column values
    Show/hide lock columns
  11. Business processes
    Creating application table
    Creating application business process
  12. Project to create application
    NULL
  13. System Administration
    Providing access
    Security roles
    Power Automate
    Administration

Public dates and prices Back to top

Prices are per delegate and exclude VAT.

  • Wednesday 4 November 2026

    Virtual, live online 2 days 9:30–16:30

    £895+ VAT

  • Tuesday 9 February 2027

    Virtual, live online 2 days 9:30–16:30

    £895+ VAT

  • Monday 22 March 2027

    Virtual, live online 2 days 9:30–16:30

    £895+ VAT

  • Wednesday 4 August 2027

    Virtual, live online 2 days 9:30–16:30

    £895+ VAT

  • Wednesday 3 November 2027

    Virtual, live online 2 days 9:30–16:30

    £895+ VAT

Can't make these dates? Ask about a private course on a date that suits you.

Training a team?

Run this course privately, on your dates

  • Private Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
  • Bespoke Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
  • Virtual These courses can be attended from anywhere.

What delegates say Back to top

“Both days were very informative”
C.P., Ipl Group
“Learned a lot from todays course that I can take into my workplace”
C.D., Nissan Nmuk, excel level 2
“Very enjoyable course with a lot of good information in a short time.”
J.R., Hitachi Construction Machinery Uk, Excel Level 2

Following this training what are you going to do differently

“I am now able to create spreadsheets using excel to compile, present and share data.”
B., London Borough Of Merton, Excel Level 1

Please select the words that best describe your learning experience

“For someone who hasn’t used computers much this was a great help”
G.H., Universal Wolf, Excel Level 1
“Really informative, gave a good insight of how powerpoint can help to explain different ideas”
R., Redefining PowerPoint Design Create and Present with Impact
“Very good!”
L.O., Labour Party, Excel Level 2
“Informative, helpful, professional, valuable”
O., Excel Level 3

Related courses

Please contact us to discuss your Microsoft Power Apps and Power Automate Essentials course, we have many solutions available to ensure you receive the best training possible.

Your PowerApps course can be delivered online or in-person. You can choose your learning path and delivery style. Learn in-person or online with our virtual classrooms. Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Microsoft Power Apps and Power Automate Essentials course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account. You can master PowerApps, please contact us to book a place or get a quote for your Microsoft Power Apps and Power Automate Essentials course.

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed: 10/20/2026 10:17:00 PM