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.
Course Outline
-
Introduction to Microsoft Power Apps
Objective: To understand the concept of creating applications without writing code.- Description of Office365 platform components and their integration with Power Apps
- The concept of less is more
- What is Power Apps and what benefits does it offer?
- Where can you apply PowerApps?
- Canvas-based and data model applications
- Ready-made application templates in Power Apps
-
Building Applications with Microsoft Power Apps
Objective: To familiarize participants with the Power Apps tool and working environment.- Environment configuration and permissions
- Methodology of work
- Creating the interface – introduction
- Data layer – overview
- Basics of communication and information exchange in the application
-
Power Apps for SharePoint 365
Objective: To 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 a SharePoint list
- Power Apps interface
- Basic controls – Text and buttons
- Controls – Input (incoming data)
- Application based on an imported Excel sheet
-
Working with Power Apps
Objective: To build a custom application from scratch.- Creating an empty application
- Screen color, background, and font customization
- Buttons and icons
- Controls and their types – Galleries and forms, Media
- Customizing controls
- Text controls for data input and display
- Control elements – drop-down menus, combo boxes, date selectors, option buttons, etc.
- Forms as interfaces for adding and editing data
- Presenting information on charts
-
Data Sources for Applications
Objective: To familiarize participants with connecting applications to data sources.- What are data sources?
- Popular data sources
- Data storage and services
- How to select a data source for your needs
- Data in applications
- Presenting data
- Creating an application based on a data source
- Adding, modifying, and deleting control elements
- Forms in the application
- What is a model-based application?
- Creating a model-based application
-
Working with Forms
Objective: To gain the ability to create an interactive user interface.- Read-only form – preview
- Form details
- Edit form – editing and saving data
- Adding and deleting data
-
Galleries and Functions
Objective: To learn how to create effective and efficient navigational lists.- Managing galleries
- ThisItem
- Text formatting and conditional formatting
- Filtering, sorting, and searching
- Navigation and dynamic dependencies
-
Automation in Power Apps
Objective: To create automation in your application without writing code.- First steps with Power Automate for Power Apps
- Office 365 Users connector, SQL Server connector
- Conditional operations
- Basic operations
- Power Automate schedule
- Triggering a process from Power Apps
- Running a flow from PowerApps
-
Managing and Testing Applications
Objective: To learn the next steps involved in sharing your application with colleagues.- Application versioning
- Sharing applications
- Work environments
- Testing applications
- Application settings
- Publishing and sharing applications
- Embedding PowerApps in Teams groups
- Embedding PowerApps 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: You will discover the possibilities offered by using the Power Automate service.- What is Power Automate?
- Available versions and where you can apply Power Automate
- Cloud (online) and desktop flows
- What benefits will you gain from automation?
- Working in Low-Code and No-Code modes
-
Flow Modes
What you will learn in this module: You will learn how flows work and how they can help you.- Automated flows and flow triggers (triggers)
- Scheduled flows and schedule management
- Instant flows – user-triggered actions
- Power Automate in Office 365 applications
-
Working with Microsoft Power Automate
What you will learn in this module: You will create your first workflows that automate tasks.- Starting work in Power Automate
- Navigating the application
- Automation based on templates
- Building a flow from scratch, step by step
- Creating a cloud-based flow using a data service connector
- Editing flows
- Publishing and running flows
- Enabling and disabling flows
-
Flows in Office 365 Applications
What you will learn in this module: You will learn how to automate tasks in basic Office 365 applications.- Integration with Office 365
- Online flow in SharePoint 365 service
- Flows supporting Outlook 365 email
- Automation support 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, you will learn effective methods for managing documents.- Managing lists and document libraries
- Approving and versioning files
- Document circulation management
- Collaboration with the Teams application
- Task approval in the Teams application
-
Automation in Practice
What you will learn in this module: You will adapt automation to the applications you use.- Data connectors in Power Platform: standard and premium
- Adding a trigger
- Adding actions
- Conditional code execution: IF and SWITCH functions
- Working with lists: apply to each functionality
- Programmatic loop: Do / Until logic
- Expressions and variables
- Data operations: data processing in Power Query
- Functions in expressions: strings, numbers, and time
-
Administration and Maintenance of Flows
What you will learn in this module: You will have the opportunity to learn how to manage your flows.- Flow management
- Flow maintenance
- Reviewing run history, performance analysis, and error diagnostics
- Sharing flows: exporting and importing flows
- Work environment
- Data security policy
- Data integration
-
Power Automate and Office 365 Applications
What you will learn in this module: You will run automation on your smartphone – * optional module.- Downloading and installing the application
- Logging into your Office 365 profile
- Creating and managing flows
- Working with applications
28 Hours
Testimonials (2)
I thought the trainer was really engaging and was very quick on his feet to answer questions that were related to our work and really tailored the teaching towards our needs and went above and beyond to meet them. I could not recommend Shaun enough!
Tom King - Complete Coherence
Course - Microsoft Power Platform Fundamentals
I really admire Trainer's patience for all the people who were asking him to repeat something 4-5 times. I also believe that he has great knowledge about the topic, but like said above, we didn't spend enough time on this. Moreover, it was good it was hands-on training, where we could practice in real time what we're taught, but again, I'd like to know more about the PowerApps, not about SharePoint, as I'm really familiar with that one, and if I wanted to learn more, I'd probably just choose a training for the SharePoint, not PowerApps.
