Microsoft Power Apps and Power Automate – Fundamental Track is a comprehensive, instructor-led program designed to help professionals design business applications and automate workflows using Microsoft’s Power Platform. This course provides a structured, hands-on introduction to building apps and automations that streamline operations, reduce manual work, and improve process consistency.
Many organizations rely heavily on spreadsheets, email approvals, and manual processes to manage daily operations. While these methods work, they often create inefficiencies, errors, and delays. Microsoft Power Apps and Power Automate enable users to transform these manual processes into structured, automated, and secure digital solutions that integrate seamlessly with Microsoft 365 and external systems.
Over three days, participants learn how to design, test, publish, and manage applications using Power Apps, as well as how to automate business processes using Power Automate. The course balances conceptual understanding with practical exercises, ensuring learners can confidently apply what they learn to real workplace scenarios.
What learners will gain from this course:
A clear understanding of when and how to use Power Apps and Power Automate
The ability to build custom apps from existing data sources
Practical experience creating automated workflows for business processes
Skills to integrate apps and flows with Microsoft Teams, SharePoint, and other services
Knowledge of administration, security, and maintenance best practices
Exposure to Copilot capabilities for faster app and flow creation
Key learning areas include:
Power Apps Fundamentals
Canvas apps versus model-driven apps
App design, branding, controls, and formulas
Connecting to data sources such as Excel, SharePoint, and Azure SQL
App testing, publishing, sharing, and version management
Advanced App Design and Integration
Using controls, charts, and forms effectively
Integrating Power Apps with Teams, SharePoint Online, and Power Automate
Managing environments, users, and app lifecycle
Power Automate Essentials
Designing automated workflows using templates and custom logic
Applying conditions, loops, approvals, and decision logic
Connecting workflows to Microsoft 365, third-party services, and on-premises systems
Automation at Scale
Monitoring flow history and analytics
Managing permissions, environments, and data policies
Using the Power Automate mobile app for approvals and triggers
Copilot in Power Apps and Power Automate
Creating apps and flows using AI-assisted prompts
Understanding Copilot’s capabilities and limitations
Accelerating development while maintaining control and governance
This course is suitable for beginners, business users, and professionals who have been using Microsoft 365 and want to optimise or redesign their business processes. No prior development experience is required.
By the end of the program, learners will be able to confidently design business apps, automate workflows, and maintain Power Platform solutions that support scalable, secure, and efficient business operations.
Training Course Modules
Module 1: An Introduction to Power Apps
Let's get started with an introduction to Microsoft PowerApps. Traditionally building customised solutions for a business involved using a coding language to build an application from scratch. Typically, these solutions could often only be used within the business, making external use of the application a large hurdle to overcome. With PowerApps we can now not only easily build solutions, but we can also share them with users in our business. Deployment takes seconds and you could by testing your own app on your phone in no time. This module will overview the features of PowerApps, its benefits to a business and the variety of ways you can build and access your apps on different devices.
Module 2: Getting Started with Power Apps
To begin our journey through the Power Apps product, we will begin by looking at some of the templates that are available to view and edit. Microsoft's templates are a good starting point to discover what the product is capable off and how it can be achieved. We will also take the chance to have a tour of the editor so that students are familiar with the interface that they will be using over the two-day course. We will then build our first app from a static data source, showing students how to test their changes in the app instantly without the need to publish. We will also discuss how to configure your apps settings and how to access the app once it has been saved and shared.
Module 3: Branding and Media
In our next module, we will look at the options available to designers that allow them to implement their business branding. Not only will this deal with the aesthetics of your app, it will also introduce time-saving tips to help keep your branding consistent. We will also be discussing how to embed media into your app which can be useful if you are planning on an app that might promote video content.
Module 4: Power Apps Controls
So far in the course, we would have covered the basics of adding, editing and removing controls from our applications. The drive behind this module is to provide more depth on the categories of controls which can be used on a form. Your instructor will take you through each control and discuss its purpose and configuration. Tackling the wide selection of controls will help students recognise when to use the right control.
Module 5: Data Sources and Logic
To help maintain and view essential business information, organisations often have a diverse selection of locations to keep different types of data. This could range from databases to file storage locations. Power Apps offers connections to a wide selection of data sources. We will show students to build their PowerApps to bring in data from a variety of sources as well as how they can utilise the common data source, a storage location unique to Power Apps.
Module 6: Model-Driven Apps
Module one to five discussed how to work with the original type of Power App known as a Canvas App, Microsoft have now introduced a second type of app known as a model-driven app. Model driven apps involve a different development process to canvas apps. We will review this development process during this module.
Model-Driven apps can be quicker to build than canvas apps, but they are less customisable and typically have a higher cost, knowing which type of app to use is not always a simple decision, we will show you the pros and cons of each.
Module 7: Power App Integration
Power Apps is designed to easily connect to other business systems to read and update information. In this module we will discuss some simple ways to integrate Power Apps with key Office 365 systems including Teams, SharePoint Online and Power Automate. The result, is the ability to use a combination of systems to create solutions for a variety of business requirements.
Module 8: Administration and Maintenance of Power Apps
In our last module for Microsoft Power Apps, we will be looking at how a business can manage their existing apps. This could be using analytics to discover usage trends. We will discover how to export and import apps, so they can be reused in other locations. Finally, we will discuss how Office 365 administrators can shape the PowerApps experience with high-level settings that help ensure data segregation and security.
Module 9: An Introduction to Power Automate
Let’s get started with an introduction to Microsoft Power Automate. Historically, automating business processes typically landed in the lap of a developer in the business, who has a good understanding of coding and the systems that they were connecting. However, more and more systems deployed to businesses are encouraging a bigger focus on end user design and management. With this culture change, end users are looking to further improve their business solutions. Power Automate brings workflow design to all audiences. It offers the building blocks for lightweight or business-critical processes. In this module, we cover an overview of the product and its application to Office 365 and third-party services.
Module 10: Getting Started with Power Automate
We begin our discovery of Microsoft Power Automate by building our first business process. We will discuss how to use templates to get started with Power Automate or how to use a blank template to start with no defined actions. Once in the product, we will give you a tour of the editor, workflow management page and the home screen to help you navigate around the product. Next, we will start to add, edit and remove actions from our workflow template in order to customise the Flow for a specific business need. Once ready we will publish and trigger the workflow to test that it works as expected. We will finish this module by discussing how to turn a Flow on or off as well as deleting a Power Automate.
Module 11: Power Automate Logic
Decision making during a business process is often a bottleneck. Waiting for decisions or information to steer the workflow towards its goal is dependent on how long the involved party spends on the task. This could be mitigated if the desired information is found declared elsewhere for example, as a document property or a form entry to name a few examples. Logic in a workflow allows existing information to push the workflow down multiple paths. This often speeds up workflow duration and minimizes human input. In this module, we will look at the core logic found in Power Automate and a practical application of each option.
Module 12: Integration
Businesses will often user a selection of productivity tools and services beyond Office 365. Marketing teams may use Facebook and Twitter whereas a sales team may use Salesforce to manage their customers. Power Automate provides connectors for popular services allowing your processes to extend beyond Office 365 to other web services. Connections can even be made to on-premises servers, allowing your business systems house at the office to take part in your processes.
Module 13: The Mobile App
Power Automate has a corresponding mobile app that can be used to leverage many features of Power Automate. Firstly, it offers users the capability to build new Power Automate, directly from their phone or tablet. Secondly, it can be used to manage existing flows including editing, viewing history, saving a copy, disabling and deleting Power Automate. You can access any approvals that have been sent to you by Power Automate and approve or reject decisions. The app also supports the push notifications that can be sent to your phone or tablet from a Power Automate. Additionally, you can even create buttons that appear in the app which allow you to trigger Flows. This valuable app will be detailed in this module.
Module 14: Administration And Maintenance
In our last module for Microsoft Power Automate, we will be taking a look at how a business can manage their Flows once they have a good uptake of the product. We will begin by discussing managing individual Power Automate. This could be using history to discover the source of any issues and implement error handling as well as using the analytics to discover usage trends. We will discover how to share a Power Automate which is ideal for sharing the maintenance of a Power Automate with another colleague and how to import and export Power Automate. Finally, we will discuss how Office 365 administrators can shape the Power Automate experience with high-level settings that help ensure data segregation and security.
Module 15: Introduction to Copilot in Power Apps & Power Automate
In this module, we shall be looking at the Copilot feature introduced to Power Apps and Power Automate. Students will be able to leverage the power of AI using Copilot to help build apps and flows with ease.
Automate workflows, reduce manual tasks, and scale with precision — without writing code.
Go from Office 365 user to workflow architect with Copilot-enabled app and flow creation.
Empower your team to build secure, business-grade apps and automate processes across departments.
Course Overview
Modern businesses rely on agility, automation, and low-code solutions to stay competitive. This 3-day instructor-led training equips your team with the skills to build business applications and automate processes using Microsoft Power Apps and Power Automate even without a coding background.
Participants will learn how to connect to data sources like SharePoint, Excel, and SQL, build intuitive apps, and create process-driven automation using Power Automate. They’ll understand the differences between canvas and model-driven apps, leverage integration with Microsoft Teams and SharePoint, and administer environments with governance and control.
Critically, the course includes hands-on labs and showcases Copilot features in both Power Apps and Power Automate allowing faster app generation, flow setup, and automation recommendations powered by AI.
Whether you're a business analyst, IT pro, or digital transformation leader, this course will help you unlock automation opportunities, reduce development cycles, and enhance organizational efficiency using Microsoft’s Power Platform.
Learning Objectives
App building with Power Apps (Canvas & Model-Driven)
Power Automate workflow creation & logic handling
Office 365 integrations (SharePoint, Teams, Outlook)
Data connection & delegation (SharePoint, SQL, etc.)
App branding & control customizations
Compliance & environment administration
Copilot AI integration for app and flow generation
Mobile app usage for approvals and workflow management
Who Should Attend
Office 365 Power Users
Business Analysts
IT Support Staff
Digital Transformation Leads
Functional Consultants
Prerequisites
No prior coding or Power Platform experience is required.
Familiarity with Office 365 is helpful but not essential.
Course Modules
Module 1: An Introduction to Power Apps
Explore Power Apps fundamentals, benefits, app types, and how to get started with templates and deployment.
Module 2: Getting Started with Power Apps
Learn to build your first app from data, test in real-time, configure settings, and publish across devices.
Module 3: Branding and Media
Apply business branding, layout consistency, and embed media assets to enhance your app’s visual identity.
Module 4: Power Apps Controls
Use various control types, formulas, and charts to enhance data entry and interactivity in apps.
Module 5: Data Sources and Logic
Connect to diverse data sources (cloud & on-prem), understand delegation, and structure data for app logic.
Module 6: Model-Driven Apps
Compare model-driven vs canvas apps and learn how to build, edit, and navigate model-driven interfaces.
Module 7: Power App Integration
Embed Power Apps within Teams and SharePoint and trigger flows through Power Automate integration.
Module 8: Administration and Maintenance of Power Apps
Monitor usage, manage environments, and enforce governance through Power Apps admin tools.
Module 9: An Introduction to Power Automate
Discover Power Automate’s purpose, benefits, and how it simplifies business workflow automation for all users.
Module 10: Getting Started with Power Automate
Create, edit, and test flows from templates or scratch, and manage activation, publishing, or deletion.
Module 11: Power Automate Logic
Design workflows using conditions, loops, switches, and logic branches to automate decision-making.
Module 12: Integration
Utilize connectors for third-party and on-premises systems to extend automation beyond Office 365.
Module 13: The Mobile App
Manage, monitor, and trigger flows on mobile — including approvals, notifications, and mobile-based creation.
Module 14: Administration and Maintenance
Oversee flow performance, history, security, analytics, and sharing using Office 365 admin controls.
Module 15: Introduction to Copilot in Power Apps & Power Automate
Leverage AI Copilot to quickly create, modify, and streamline app and flow development with intelligent suggestions.
Professional Outcomes
Completing this course positions you for roles such as Power Platform Analyst, Business Solutions Consultant, Workflow Automation Specialist, or Low-Code Application Developer — all high-demand roles in digital transformation initiatives.
Certification Details
No specific exam for this course
Frequently Asked Questions
Is this course beginner-friendly?
Yes — no coding experience is needed, and we start from Power Platform fundamentals.
Do I get hands-on practice?
Absolutely — each module includes guided labs, real-life examples, and simulations.
Will I learn both Power Apps and Power Automate?
Yes, the course equally covers both tools with practical integration between them.
Is Copilot included in this training?
Yes — you’ll experience Copilot for app and flow generation with real examples.
Can I connect to external data sources like SQL?
Yes — the course includes working with SharePoint, SQL, and on-premises gateways.
Will this help reduce manual work in my department?
Definitely — automation logic and flow design will help streamline repetitive tasks.
Is this aligned with Microsoft’s official Power Platform capabilities?
Yes, the course is built around Microsoft’s recommended practices and real-world use cases.
Is this HRDC claimable?
Yes, for eligible Malaysian employers.
Can we request in-house delivery for our team?
Yes, GemRain offers private group training for corporate clients.
Does the course prepare us for certification?
While not a direct exam prep, this course aligns well with PL-900 (Microsoft Power Platform Fundamentals) content.