Power Apps Course Content

What is Power Apps?

PowerApps is a Microsoft tool used to develop data-driven business applications. It serves as both a development environment and data layer that allows users, analysts, and managers, to build scalable applications with no code. Almost all manual Excel / paper processes can be replaced by Power Apps. PowerApps is quickly growing to become the number 1 no code development environment.

Power Apps is a suite of apps, services, and connectors, as well as a data platform that provides a rapid development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your data stored either in the underlying data platform (Microsoft Dataverse) or in various online (One Drive, Azure, Google Drive, Amazon, Salesforce) and on-premises data sources (such as SharePoint, Microsoft 365, Dynamics 365, SQL Server, and so on).

What are the main features of PowerApps?

Microsoft ecosystem – Power Apps is similar to other familiar Microsoft applications, like Word or Excel. It has the same ribbon structure and similar design, which makes it easy to learn and transfer knowledge. PowerApps is the Microsoft’s way to build applications, similar to how PowerPoint is Microsoft’s way to build presentations.

Easy to use – No coding necessary or even required. Similar to other Microsoft applications, it’s a drag-and-drop system which makes thing easy, and has an amazing user-friendly interface.

Build it once, run it everywhere – Once you build a PowerApps applications, it can be run anywhere with no further development. This means that your application can easily go from phone, tablet, and web without any more effort, and can be run on all systems (Windows, Mac, Linux).

Connect to anything – Microsoft’s in-built data connectors allow you to easily connect to any data sources, whether it’s in OneDrive, Google Sheets, SQL, RedShift, your computer’s filesystem, S3, you get the idea (every data source).

Customize to your heart’s desire – PowerApps allows you to build your app your way. This means that you can build the application in your vision – your imagination is your only limitation!

Why Learn PowerApps?

Create impact fast – Power Apps allows you to build applications fast, so if you’re looking to quickly build scalable applications, this is for you

Increase your and your organizations productivity – Do you have a process in your organization or with yourself that is currently that is managed by shared Excel files or, worse yet, paper? PowerApps allows you to replace this with a data-driven application

Get hired / increase your employability – PowerApps is one of the fastest growing tools in medium-to-large businesses, and is expected to be the top sought after Microsoft skill. Put this skill on your resume to boost your chances and pay rate.

Improve your toolkit – Add this to your list of Microsoft skills – this is very powerful in conjunction with other Microsoft products (Office, PowerBI, Azure, 365, etc.)

Why Take This Course?

Complete guide – This is the 100% start to finish, zero to hero, basic to advanced guide on PowerApps. There is no other course like it that teaches you everything from start to finish.

Fully instructional – we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the PowerApps features, but a course that actually builds applications with you

Learn to learn – During the latter parts of the course, we go through situations where we encounter new features or errors, and work through how we would use the documentation to resolve them. In this way, you not only learn about Power Apps inside and out, but learn how to resolve your own issues as they come up. You will become a PowerApps master.

Curriculum

Introduction

What is PowerApps?

PowerApps Features

Why learn PowerApps

Course overview

Environment Setup

PowerApps account

Connecting to data – Onedrive

Connecting to data – GoogleSheets

Basic:PowerApps Concepts.

Developmet environment

Running your first application

Saving your Application

Basic functionality

Customizing

Beginner: Canavas Apps

Environment layout, views, elements and properties.

Introduction to galleries

Forms and data cards

Property assignments

Edit forms, updates, textboxes and triggers

Introduction to functions and formulas

Introduction navigation

Error checking

Run application on your phone

Intermediate: Canavas Apps

Create Canvas App from scratch, master, and documentations screens

Customizing the look of the application, documentation links.

Buttons

Galleries

Customizing Galleries.

Navigation

Introduction to variables

Contextual variables

Global Variables

Collections

Adding a search field

Filter functions

Creating the Detail screen

Creating the Edit Form screen

Linking up navigation on screens

Creating the New form screen

Data validation (ismatch)

Data validation (variables)

Connecting to multiple data sources

Data tables

Lookup

Adding call functionality

Publish your application

Change screen order

Expert: Canavas Apps

Introduction

Documentation

User() fuction

Today() and Now() fuctions

Grouping elements

Launching other sevices

Cascading dropdown 1 & 2

Delete button

Popups for confirmations

Expert: Common Data Service / Dataverse

Introduction

CDS/Dateverse setup

Entities

Relationships in entities

Business rules and views

Forms, dashboards, charts, keys, and data

Creating an entity

Adding text fields

Adding calculated fields

Uploading data

Viewing the data

Creating custom views and forms

Creating business rules

Other CDS/Dataverse concepts

Advanced: Canvas Apps

Introduction

Input elements

Image elements

Combining image with pen inputs

Combining image with camera input

Combining image with upload photo input

Images in galleries

Charts and graphs

Advanced: Model-Driven Apps

Introduction

Environment setup

Navigating the environment

Site map

Edit forms and views

Applying business rules

Site map complexities

Introduction to business process flows

Documentation

Create a Full App

Create an App from scratch to end as per industry’s practice

About Instructor

I am Praveen Gampa, trainer. I am specialized in SAP BW, BOE and Microsoft Power Apps, Power BI, Excel Pivot Tables, Power Pivot and Power Query

I am an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.

I have 20+ years of overall IT experience, I have been training learners on these powerful technologies for over 10+ years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.

I have over 10+ years of Online, end-user training and Management Consulting experience. It brings this knowledge and skills to my training course showing Power BI users how to easily create sophisticated management reports, perform data analysis, and create amazing interactive dashboards without using any complex programming specialized tools.

I have consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Retail and Logistics industries across several countries and continents.