Training Course

Microsoft Power Apps and Power Automate Essentials

PDF
Course Duration: 2 Days

Course Overview

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.

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.

Software Version

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

Course Content

  • Introduction

    Welcome and Overview
    Different types of app
    What is Power Automate What is the dataverse

  • Power Apps Maker Environment/Studio

    Accessing Apps
    Where to build apps from
    Solutions
    Flows and tables
    Dataflows

  • Navigating the studio

    Introduction
    Left navigation panel
    Design area
    Object properties
    Formula bar
    Review

  • Creating an app from existing data

    Excel
    SharePoint list
    Dataverse table
    Copilot

  • Actions

    Navigation
    Store temporary data
    Select
    Start a flow using a button

  • Data Views

    Data sources
    Canvas apps
    Collections
    Variables

  • Power FX

    introduction
    Excel vs PowerFX
    Reference guide
    Maths functions
    Using App maker
    Examples of FX formulas

  • Dataverse

    Tables
    Forms
    Views
    Relationships
    Processes
    Rules
    Creating columns
    Types of columns

  • Forms and Views

    Introduction
    Creating views
    Creating forms

  • Business rules

    Introduction
    Column values
    Show/hide lock columns

  • Business processes

    Creating application table
    Creating application business process

  • Project to create application

    NULL

  • System Administration

    Providing access
    Security roles
    Power Automate
    Administration

Included with this course

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

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
05 Aug - 06 Aug 2026
Virtual
£895
04 Nov - 05 Nov 2026
Virtual
£895

Private Training

Private course
Flexible date and location
Please quote for prices

  • Course Options

    Private courses:
    Private course
    Flexible date and location
    Please quote for prices
    Public scheduled courses:
    All prices exclude VAT, prices per delegate.
    05 Aug - 06 Aug 2026
    Virtual
    £895
    04 Nov - 05 Nov 2026
    Virtual
    £895
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask a Question
  • Microsoft Power Apps and Power Automate Essentials Course Options
    Private
    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
    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
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

 

Course Reviews
Both days were very informative

C.P. Ipl Group, Microsoft Power Apps and Power Automate Essentials

Following this training what are you going to do differently Use many tips and tricks, use IF more, use function library within Excel.

S.B. Education Development Trust, Excel Level 2

Many thanks... good initial overview.

A.S.L. United Reformed Church Northern Synod, SharePoint and Teams Overview

Very useful training for the role out of our project cost control and resource planning initiatives.

S.H. Deepocean, Microsoft Project Essentials

I feel much happier after sitting the course

D.G. Stobart Rail, Excel Level 1

The course was delivered by a lovely tutor who really enjoys what she does. This was evident through out the course which made it a lovely experience for me

J.E. Hmp Full Sutton, Hmp Gartree, Minute Taking

Which part of the course did you find particularly valuable The visualisations were really helpful and the whole process was very easy to follow

L. Hmpps, Microsoft Power BI Desktop

Following this training what are you going to do differently Tidy up the current spreadsheets that I use using the new features that I have learnt. Will help me with my KPIs.

C.G. Vehicle Lease and Service Ltd, Excel Level 2

 

 

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:7/15/2026 9:37:21 AM