Microsoft Power Platform

Description

Microsoft Power Platform consists of primary applications such as Power BI, Power Apps, Power Automate, and Power Virtual Agents.

Course Content

 1-An Introduction to PowerApps

• What is PowerApps?
• The benefits of apps
• How to get PowerApps
• PowerApps Studio and Web version
• Introduction to Power Apps, Power Automate, Power BI
• License Options and Costs
• Discover PowerApps with Templates
• Introduction to Data Connector
• Power Apps Admin Centre
• Download and Install Power Apps
• Create Login and configure Power bi web account
• Explore Power Apps Platform
• Explore Power Apps Components
• Explore all Data Connectors

2-Getting Started with PowerApps

• Building a new app from a data source
• Add, edit and remove controls
• Intro to Formulas
• Testing an app
• App Settings
• Publish and Share Apps
• Version History and Restore
• PowerApps Mobile App
• Save the Apps in local computer and cloud
• Publish and Share the Apps
• Open and Edit existing Apps
• Customizing the apps
• Explore Tree View (BrowserScreen, DetailScreen, EditScreen)
• Add and Modify records using Apps in One Drive
• Explore the Formula of each button

3: Customizing Canvas Apps

• Different types of Power Apps for different scenarios
• Creating Flooring Apps using Google Sheet
• Local variable, Global Variables
• Understanding Data Forms and Cards
• How to add Button Control in Apps
• Working with Formulas (IF)
• Adding Video to Apps
• Adding Rating Control to the Apps
• Create Popup message in Apps
• Update Context Function to create Local Variable
• Delegate in Power Apps
• Use Timer
• Localization

4-Understand Environment

• What is Environment (Namespace)
• Benefit of multiple environments
• Reason to use Environments
• Separate app development by department
• Development Environment
• Manage access to environment
• Explore Power Apps Admin Centre
• Create a New Environment
• Environment Name, Type, Region, Purpose

5-Understand Office 365 and SharePoint Data Source

• What is Office 365 and how to use
• Sharepoint Apps
• Sharepoint Data Connection and Apps
• Explore Sharepoint
• Power BI Connection
• Explore Office 365 Enterprises Trial
• Create a Free Trial Office 365 Account
• Login to Office 365 Account
• Explore all Office 365 Apps
• Open Admin page of Office 365
• Open Sharepoint Site

6-Model-Driven Power Apps

• Understand Model Driven Apps
• Difference between Canvas and Model Driven Apps
• Benefit of Model Driven Apps
• Explore Sample Template Fundraiser
• Create Environment, Create Database
• Add new records in Fundraiser
• Navigate between 2 environments

7-Common Data Services (CDS)/Dataverse

• What is Common Data Services?
• Entities
• Security & Benefits
• Entity Relationships
• Entity Types
• Create a Common Data Entity
• Create a Custom Entity
• Add and Customized Fields
• Adding Relationships
• Customize view, Customize main form
• Create a custom entity and import data
• Use Common Data Service to store data
• Add a Business Rule
• Importing Data from an Excel file

8-Portal Apps

• Introduction to Power Apps Portal
• Buildings Apps
• Create and build first Portal power apps
• Create a new Environment
• Create Database
• Design Web site
• Create Entities
• Create Forms and Add records

9-Artificial Intelligence (AI) & Virtual Agents in Power Apps

• What is AI?
• Power Apps AI Builder
• Virtual Agents
• Create Object Detection example using AI

10-An Introduction to Power Platform

• Power Apps
• Power BI
• Power Automate/Flow
• Power Virtual Agents

11-An Introduction to Power Automate

• What is Microsoft Power Automate?
• Features of Power Automation.
• The benefits of automation
• How to get to Power Automate?
• How to Set up Power Automate in Office 365
• What is a Flow?
• Types of Flow.
• Environment Setup

12-Getting Started with Power Automate

• Exploring Power Flow Interface
• Using Power Automate Home page
• Creating Power Flow
• Navigating in Power Automate
• Editing a Power Automate
• Publish and trigger a Power Automate
• Turn off or delete a Power Automate

13-Types of Automate

• Using Automated Flow
• Using Instant Flow
• Using Scheduled Flow
• Using UI Flow/Desktop
• Using Business Process Flow

14-Creating Flows as Blank

• Creating Flow from scratch
• Creating flow Triggers
• Flow Actions
• Understanding Dynamic Contents
• Testing your flow

15-Understanding Expression, Logics 

• Introduction to expressions
• Expression testing
• Adding single and multiple actions
• Working with Files
• Approval Process
• Looping, Condition
• Expression
• Variables
• Creating and Testing conditions
• Schedule Flow
• Examples of scheduled flow
• Using Different inputs
• Triggering Power Apps applications
• Testing Power Apps applications

16-Built-in Functions 

• Setting Expression
• String Function – Concatenate, Substring, IndexOf, Split etc
• Collection functions
• Datetime function

17-Conditions and Looping 

• Variables
• If statements
• Logical Comparison operators
• Other expression functions

18-Creating UI Flows and Business Process Flow

• Understanding UI Flow
• Create and Manage UI Flow
• Benefits and limitation of UI Flows
• Creating Business Process Flow (BPF)

19-Virtual Agent

• Introduction to Power Platform
• Introduction to Virtual Agents
• Overview of creating Power Virtual Agents bots
• Get started working with environments
• Create environments
• Create bots and work with the Power Virtual Agents interface
• Delete a bot
• Work with the Power Virtual Agents user interface
• Create topics
• Get started with topics
• Work with lesson topics
• Components of Power Virtual Agents
• Entities
• Prebuilt entities
• System Topics
• Create topics
• Work with conversation nodes
• Test bots
• Publish bots and analyse performance
• Exercise – Build your first chatbot
• Task 1: Sign in to create a bot
• Task 2: Take a quick tour of the user interface
• Exercise 2: Try out a conversation in the Test Bot pane (Hello!)
• Exercise 3: Edit your conversation
• Task 1: Make a copy of the topic
• Task 2: Edit the copy of the topic
• Exercise 4: Publish your bot to the demo site for testing
• Check your knowledge

20-Power BI (With Power query)

• Overview to Power BI
• Power BI Desktop
• Power BI Service
• Installing Power BI Desktop
• Create Power BI account
• What is Power Query Editor
• Closer look of Query Editor Interfaced
• Overview of Different View of Data Model
• What is Power Query
• Interface
• From Web
• From Excel File Module Introduction
• Understanding the interface of the Report view
• Creating our first Visualization
• Log in to Power BI Service
• Understanding the Interface
• Imparting our Data from Power BI Desktop to Power BI Service