Microsoft Power Platform

Microsoft Power Platform makes it easy to rapidly build and share professional grade
low code application. Power platform mainly consists of five components.


Prerequisites :

No minimum qualification is mandatory for joining this course

Microsoft Certified: Power Platform App Maker Associate - Training

If you’re a business professional with deep expertise in your solution domain and you want to use your passion for building Microsoft Power Platform solutions to simplify, automate, and transform tasks and processes for your team, this certification is designed for you. You must have the skills to accomplish key technical business analyst tasks, such as data modeling, basic UX design, requirements analysis, and process analysis.

You fit the profile for the app maker role if you’re self-directed and solution-focused, and you work with the maker tools of Microsoft Power Platform to solve business problems. You might have experience with Visual Basic for Applications, Excel PivotTables, Teams, and other tools. Although you might not have formal IT training, you’re comfortable working with IT administrators and Microsoft Power Platform developers using technology to solve business problems. You’re responsible for:

  • Designing and creating apps and automating workflows.
  • Analyzing and visualizing data in context of an app or automated workflow.
  • Implementing and managing apps and automated workflows.

Microsoft Power Platform

Course Details

1. One to One Training Sessions
2. Official Training Content
3. Daily 1Hr. or Weekends 2Hrs. (Sat. & Sun.) Training Sessions
4. No. of Days 30, No. of Hours -30
5. Recordings of each session

Syllabus of Microsoft Power Platform

Microsoft Power Apps

 Introduction to Power Apps 

• What is Power Apps
• Types of Power Apps
• Introduction to Power App Studio

Overview of Dataverse

• What is Microsoft Dataverse
• Tables in Dataverse
• Creating the Table in Dataverse
• Columns in Dataverse
• Forms in Dataverse
• Views in Dataverse
• Relationships in Dataverse
• Dashboards and Charts


Overview of Solution 

• Introduction to Solution
• Types of Solution
• Best practice of use solution

Introduction to Model-Driven Power Apps

• What is Model-Driven Power Apps
• Dataverse Table
• Views and Forms in Model-Driven Apps
• Add Charts and Dashboards in Model-Driven Apps
• Assign Security Roles in Model Driven App

Introduction to Process in Model-Driven Power Apps

• Rule in Model Driven App
• Workflow in Model Driven App
• Add Business Process Flow in Model Driven App

Introduction to Canvas Apps

• Canvas App Building Blocks of Canvas App
• Introduction to Canvas App Studio

Start with the Canvas Apps

• First Canvas App from Template
• Creating First Blank Canvas App
• Screens in the Canvas App
• Properties of Canvas App Screen

Canvas Examples and Controls

• Kinds of Controls
• Adding a Control
• Reordering, Moving, and Resizing the Controls
• Configuring the Control from the toolbar
• Configuring the Control
• Configuring the Control using formula

Notifications and Navigation in Canvas App

• Navigation from one screen to another screen
• Show notification in Canvas App

Connectors of Power Apps

• Introduction to Power Apps Connectors
• Different Kinds of Connectors in Power Apps
• Using the Dataverse as the data source

Dataverse Source with Canvas App

• Create form from Dataverse column
• Use Dataverse view in canvas app

• Create Record in Dataverse from Canvas App


SharePoint Online data source with Canvas App

• Creating the SharePoint List
• Using the SharePoint as the data source in Power Apps

Gallery, Date Table, Form in Canvas App

• What are Data Table, Form, and Gallery
• Difference between Data Table and Gallery
• Add Galleries and customize Galleries in Canvas
• Add form and types of form in Canvas

Power Fx and Logical Condition in Power Apps

• What is Power Fx
• If and Else Condition in Canvas
• Switch Conditions in Canvas
• Implementation with example

Variables in Canvas App 

• Introduction to Variables
• Types of Variables Scope of Variables
• Set Value of Variables
• Implementation with example

Advance Formulas of Canvas Apps

• Creating the Custom Forms and function to submit the data
• Filter and Lookup Function in Canvas
• Differentiating Lookup, Search, and Filter
• Group by function in Canvas App

Version and Restore Canvas App

• Define Versioning
• Restoring a Version

Custom Pages in Power App

• Introduction to Custom Pages
• Create and use of Custom Pages
• Embedded Custom Page in Model Driven App

Sharing the Power Apps

• Sharing App to User
• Sharing App to Team

Export or Import Power Apps 

• Export Power App
• Import Power App

License and Costs of Power Apps 

• Overview of License and Cost in Power App
• Different types of Licenses in Power App

Microsoft Power Automate

Overview of Power Automate

• Define Power Automate
• Introduction to Power Automate Flows and its different kinds
• Different Connectors in the Power Automate
• Power Platform Admin Center

Environment Setup

• Create Flow from template
• Introduction To various Flow templates available
• Understand Flow runs and Flow details Page
• Understanding Different Power automate Connectors
• Creating flows with real world scenarios
• Moving the data continuously between the multiple systems through Flows
• Creating business process flows for automating the enterprise process

Power Automate Introduction to Expressions 

• Fetching Dynamic Content in Flows
• Introduction To Expressions
• Use Expressions to Fetch Dynamic content in Flow
• Expression Exercise and Testing
• Introduction to switch statements and conditions in Flows
• Parallel Branching in Flows

Advance Functions in Power Automate 

• Introduction To HTTP requests
• Working with HTTP requests
• Parsing JSON in Power Automate
• Handling HTTP requests In Power Automate

Approval Flows

• Introduction to Power Automate Approval Flows
• Understanding Approval Flows in depth
• Creating employee leave system with Approval Flows

Personal Automation through Power Automate Desktop 

• Recording the Actions and Steps on desktop
• Working with the files stored in the local machine folder
• Automation of day today tasks with Power Automate desktops

Developer Insights to Power Automate 

• Best Practices in Power Automate
• Error Handling in Power Automate
• Documentation in Power Automate

Microsoft Power BI

Introduction to Power BI Platform

• Understanding the Power BI Platform
• Creating a Trial Office
• Tenant for Development
• Understanding Power BI Licensing

Getting Started with Power BI Desktop

• Getting Started with Power BI Desktop
• Creating Queries in Power BI Desktop
• Modelling Data in Power BI Desktop
• Designing Reports in Power BI Desktop
• Publishing Power BI Desktop Projects

Designing a Data Model with Power BI Desktop

• Modelling Data in Power BI Desktop
• Understanding Table Relationships
• Understanding Calculated Columns versus Measures

Designing and Deploying Dashboards 

• Understanding the Differences between Dashboards and Reports
• Creating and Configuring Dashboards
• Executing Queries with Natural Language QA
• Sharing Dashboards with Other Office Users
• Configuring Data Alerts on Dashboard Tiles

Publishing Content using Apps and App Workspaces

• Understanding the Role of App Workspaces
• Publishing App Workspaces

Power Virtual Agent

Introduction to Power Virtual Agent

• Overview of Power Virtual Agent
• Component of Power Virtual Agent

Power Virtual Agent Example

• Create your first Bot
• Create and edit Topics
• Enhance your Bot
• Publish your Bot
• Embedded your Bot

Microsoft Power Pages

Introduction to Power Pages 

• Overview of Power Pages
• Introduction to Power Pages Studio

Power Pages Example

• Power Pages capabilities
• Create your first Power Pages site
• Manage your Power Pages site
• Power Pages security