Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 28 hours
Course Outline
- Introduction to Microsoft Power Apps
Objective: Learn the concept of building applications without writing code.- Overview of Office 365 platform components, their capabilities, and integration with Power Apps
- The concept of 'less is more'
- What is Power Apps and what benefits does it offer?
- Where can you apply Power Apps?
- Canvas-based and model-driven applications
- Ready-made application templates in Power Apps
- Building Applications with Microsoft Power Apps
Objective: Familiarize yourself with the Power Apps tool and the working environment.- Environment and permission configuration
- Work methodology
- Creating the interface – introduction
- Data layer – discussion
- Basics of communication and information exchange in an application
- Power Apps for SharePoint 365
Objective: Create your first custom application based on SharePoint 365. Power Apps for SharePoint is a special version of Power Apps embedded within the SharePoint platform.- Creating a SharePoint form using Power Apps
- Power Apps form as an interface for SharePoint lists
- Power Apps interface
- Basic controls – Text and buttons
- Controls – Input (incoming data)
- Application based on an Excel sheet import
- Working with Power Apps
Objective: Build your own application from scratch.- Creating a blank application
- Screen color scheme, backgrounds, and font adjustment
- Buttons and icons
- Controls and their types – Galleries and forms, Media
- Customizing controls
- Text controls for entering and displaying data
- Steering – Drop-down menus, combo boxes, date pickers, option buttons, etc.
- Forms as an interface for adding and editing data
- Presenting information in charts
- Data Sources for Applications
Objective: Learn about the capabilities for connecting applications to data sources.- What are data sources?
- Popular data sources
- Data storage and services
- How to choose a data source for your needs
- Data in applications
- Presenting data
- Creating an application based on data sources
- Adding, modifying, and deleting controls
- Formulas in an application
- What is a model-driven application?
- Creating a model-driven application
- Working with Forms
Objective: Gain the ability to create an interactive user interface.- View form - Read-only
- Form details
- Edit form – Editing and saving data
- Adding and deleting data
- Galleries and Functions
Objective: Learn how to create effective and efficient navigation lists.- Managing galleries
- ThisItem
- Text formatting and conditional formatting
- Filtering, sorting, and searching
- Navigation and dynamic dependencies
- Automation in Power Apps
Objective: Create automation in your application without the need to work with code.- First steps with Power Automate for Power Apps
- Office 365 Users connector, SQL Server connector
- Conditional operations
- Basic operations
- Power Automate schedule
- Invoking a process from Power Apps
- Running a flow from Power Apps
- Managing and Testing Applications
Objective: Learn the next steps involved in sharing your application with colleagues.- Application versioning
- Sharing applications
- Working environments
- Testing applications
- Application settings
- Publishing and sharing applications
- Embedding Power Apps in Teams
- Embedding Power Apps in SharePoint Online
- Mobile Power Apps application
- Integration of Power Apps and Power BI
- Introduction to Microsoft Power Automate
What you will learn in this module: Discover the capabilities offered by the Power Automate service.- What is Power Automate?
- What versions are available and where can you apply Power Automate?
- Cloud (online) and desktop flows
- What benefits will you gain from automation?
- Working in Low-Code and No-Code modes
- Flow Work Modes
What you will learn in this module: Understand how flows work and how they can help you.- Automated flows and flow triggers
- Scheduled flows and schedule handling
- Instant flows – user-triggered actions
- Power Automate in Office 365 applications
- Working with Microsoft Power Automate
What you will learn in this module: Create your first flows to automate work.- Getting started with Power Automate
- Navigating the application
- Automation based on a template
- Flow from scratch, step by step
- Creating a cloud flow using a data service connector
- Editing flows
- Publishing and running flows
- Turning a flow on and off
- Flows in Office 365 Suite Applications
What you will learn in this module: Learn automation in basic Office 365 suite applications.- Integration with Office 365
- Online flow in SharePoint 365 service
- Flows managing Outlook 365 email
- Automation handling in OneDrive for Business
- Flows in the Forms application
- Accepting SharePoint entries
- Flows in SharePoint 365
What you will learn in this module: Based on the SharePoint platform, learn methods for effective document management.- Managing lists and document libraries
- Approving and versioning files
- Managing document workflows
- Collaborating with the Teams application
- Approving tasks in the Teams application
- Automation in Practice
What you will learn in this module: Adapt automation to the applications you use.- Data connectors in Power Platform: standard and premium
- Adding a trigger
- Adding an action
- Conditional code execution: IF and SWITCH functions
- Working with lists: apply to each functionality
- Programming loop: Do / Until logic
- Expressions and variables
- Data operations: Data processing in Power Query
- Functions in expressions: Strings, numbers, and time
- Flow Administration and Maintenance
What you will learn in this module: You will have the opportunity to learn how to manage your flows.- Managing flows
- Flow maintenance
- Reviewing run history, performance analysis, and error diagnostics
- Sharing flows: Exporting and importing flows
- Working environment
- Data security policy
- Data integration
- Power Automate and Office 365 Applications
What you will learn in this module: Launch automation on your smartphone - * Optional module.- Downloading and installing the application
- Logging into the Office 365 profile
- Creating and managing flows
- Working with applications
Requirements
Testimonials (3)
Practical and hands on labs on report developmemt using Power BI The labs were excellent and the trainer offered very good hands on sessions
Sinzala Sichaanji - Bank of Zambia
Course - Mastering Power Platform: Power Apps, Power Automate, DataVerse, Power BI, and Power Virtual Agents
We did quite complex examples, so we could get a feeling of how the real work with Power Automate Desktop can look like in the real world scenario.
Michal Strnad - MicroNova AG
Course - Microsoft Flow/Power Automate
Dynamic, adaptive, and informative