The Microsoft Power Platform enables organisations to build business solutions quickly using low-code tools. With Power Apps and Power Automate, users can create custom applications, automate workflows and connect different data sources without advanced programming skills.

In this hands-on training, participants learn how to build simple business apps with Power Apps and automate processes using Power Automate. Through practical exercises, they discover how to connect to common data sources such as SharePoint, Excel and Microsoft 365 services.

By the end of the course, participants will be able to create their own apps and automate everyday tasks to improve productivity and streamline business processes.

Duration

2 days.

Course Outline

Part 1 – Introduction to the Microsoft Power Platform

1. Understanding the Power Platform Ecosystem

The Microsoft Power Platform provides a set of low-code tools that allow organisations to build applications, automate processes and analyse data without extensive programming knowledge.

In this introductory module, participants discover how Power Apps and Power Automate interact with other Microsoft services and how they can be used to create integrated business solutions.

Topics

• Overview of the Microsoft Power Platform
• Key components: Power Apps, Power Automate, Power BI and Power Virtual Agents
• Introduction to AI Builder capabilities
• Understanding connectors and connections
• Introduction to Microsoft Dataverse
• Integration with Dynamics 365
• Real-life examples of business solutions built with the Power Platform

Part 2 – Building Applications with Power Apps

1. Introduction to Power Apps

Modern organisations store information in different systems such as SharePoint, Excel, Dynamics 365 or external databases. Power Apps allows users to create applications that provide a simple interface to access and update this data.

Participants will learn how Power Apps enables non-developers to build mobile-friendly applications and improve business processes.

Topics

• What is Microsoft Power Apps?
• Canvas apps vs Model-driven apps
• Overview of Power Apps portals
• Creating apps using templates
• Generating apps directly from existing data
• Using Power Apps on mobile devices

Practical exercise

Create a first Power Apps application.

2. Designing Canvas Apps

In this module, participants explore how to design and customise applications using Power Apps Studio. They learn how to build screens, add controls and implement basic logic using Power FX.

Topics

• Creating applications with Power Apps Studio
• Working with data connections
• Adding screens and interface elements
• Using galleries to display data
• Introduction to forms
• Implementing logic with Power FX formulas

Practical exercise

Customising and extending a canvas application.

3. Connecting to Data Sources

Applications typically rely on different data sources. This module explains how to connect Power Apps to common services and how to retrieve and manipulate data within an app.

Topics

• Connecting to SharePoint lists and document libraries
• Accessing Microsoft 365 services
• Integrating with Microsoft Teams
• Managing tasks from Outlook and Planner
• Working with Excel data
• Connecting to Microsoft Dataverse
• Using connectors to integrate external systems

Practical exercise

Using connectors within an application.

4. Working with Forms and User Input

Forms are a key component of many applications. Participants learn how to design forms that allow users to view, edit and create records.

Topics

• Display and edit forms
• Understanding data cards
• Customising form layouts
• Input validation
• Creating dynamic form behaviour
• Using formulas to control fields

Practical exercise

Designing a form-based application interface.

5. Managing Data in Power Apps

In this module, participants learn how to manage and manipulate data within their applications.

Topics

• Configuring and managing data sources
• Working with variables and collections
• Updating data records
• Using the Patch function
• Handling errors
• Refreshing and searching data
• Understanding delegation and performance considerations

Practical exercise

Working with multiple data sources.

6. Publishing and Sharing Applications

Once an application is ready, it needs to be shared with users. This module explains how to configure and distribute Power Apps within an organisation.

Topics

• Configuring application settings
• Responsive design considerations
• Sharing applications with users or teams
• Managing permissions
• Embedding apps in SharePoint pages
• Integrating apps into Microsoft Teams
• Monitoring application usage and performance

Practical exercise

Publishing and sharing an application.

7. Customising SharePoint Forms with Power Apps

Power Apps can be used to replace and enhance default SharePoint forms. Participants learn how to customise these forms to improve usability and functionality.

Topics

• Customising SharePoint list forms
• Understanding SharePoint integration controls
• Adapting forms for different modes (view, edit, new)
• Adding dynamic behaviour to forms
• Creating responsive SharePoint forms

Practical exercise

Customising a SharePoint list form.

Part 3 – Automating Processes with Power Automate

1. Introduction to Power Automate

Power Automate enables users to create automated workflows that connect different services and applications.

Participants learn how to automate repetitive tasks and integrate different systems without writing code.

Topics

• What is Microsoft Power Automate?
• Understanding flows and automation scenarios
• Types of flows (automated, instant, scheduled)
• Components of a flow
• Working with triggers and actions
• Using connections and connectors
• Introduction to the Power Automate mobile app

Practical exercise

Creating a flow from a template.

2. Creating and Managing Flows

Participants learn how to design automated workflows and connect them to common business applications.

Topics

• Creating flows from templates or from scratch
• Using automatic triggers
• Creating manual flows with buttons
• Scheduling automated processes
• Working with connectors
• Adding conditions and simple logic
• Monitoring and troubleshooting flows

Practical exercise

Building a custom workflow.

3. Managing Flow Access and Collaboration

This module explains how flows can be shared and managed within a team or organisation.

Topics

• Sharing flows with colleagues
• Co-ownership of flows
• Managing permissions
• Understanding connections and references
• Run-only permissions

Practical exercise

Managing access to a flow.

4. Creating Approval Workflows

Approval processes are common in many organisations. Power Automate makes it possible to automate these processes.

Topics

• Creating approval flows
• Different approval scenarios
• Approve or reject actions
• Processing approval results
• Integrating approvals with SharePoint and Teams

Practical exercise

Creating an approval workflow.

5. Using Power Automate on Mobile Devices

Power Automate can also be managed from mobile devices.

Topics

• Overview of the mobile application
• Monitoring automation activity
• Starting flows manually
• Managing flows from mobile devices

Practical exercise

Working with Power Automate on mobile.

Audience

This course is designed for professionals who want to create simple business applications and automate workflows using Microsoft Power Platform.

Typical participants include:

• Business users and power users
• Administrative professionals
• Business analysts
• Project managers
• IT support staff
• Microsoft 365 users who want to automate tasks

No programming experience is required.

Prerequisites

Participants should have:

• Basic knowledge of Microsoft 365 applications
• Basic experience with SharePoint, Excel or Teams
• General computer skills

No prior experience with Power Apps or Power Automate is required.