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.
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.
    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

I feel much more confident using formulas now. I will definitely do more charts for insertion into reports now.

S.X. Merton Council, Excel Level 1

All aspects of the training were valuable

D.T. Watmos, Outlook Overview and MS Teams for Hosts

Which part of the course did you find particularly valuable All of it, as a project manager beginner most of the information was valuable and has improved my knowledge of project management

M. , Project Management Essentials

Very informative and presented well

L.M. Nhs South Tyneside, Excel Level 2

The trainer was a great teacher and I cant wait for level 3.

R. Universal Wolf, Excel Level 2

Picked up a great deal from this session. Very useful going back to basics and getting to know Excel better. It39s been a great confidence booster. I particularly enjoyed learning about conditional formatting, slicers, formula39s and generic search functions. I feel I am able to work a lot quicker in my job role

A.N. Bloom Procurement Services Ltd, Excel Essentials

Following this training what are you going to do differently Ensure we all use MS Project for live project programming so that I can use it to create an overall programme. I will then use the project overview for reporting.

A.R. Adler &Amp; Allan, Microsoft Project Essentials

 

 

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:8/23/2026 3:18:28 PM