Get in Touch
 Duration 28 hours

Course Outline

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (3)

Provisional Courses

Related Categories