What is Microsoft Power Apps

Course Road Map

Introduction to the course

Who can benefit from this course

Licensing requirement for this course

Why do we need JSON in Power Apps (Skip if you already know JSON)

Understanding Power Apps Environment

Power Apps designer

Let's focus only on look and feel!

Working with container control

Adding and working with controls

Dynamically changing control properties at run-time

Understanding control colors and opacity

Grouping controls

Power Apps Simple vs Complex controls

If and Contextual variables in Power Apps

Adding some actions to Text input

Text Label and Text Input

SampleVideo SlowMotion

HTML text and Rich Text Editor

Checkbox, Toggle and Date Picker are the easiest to work with

Working with Image and Video controls

Working with Buttons, Shapes and Icons

Dropdown, List and Radio

IMPORTANT - Before you start with complex controls

Working with Combo box

Working with Gallery and Data Table

Cleaning up the app we made so far

Pie chart

Planning and preparation

Logical and comparison operators to use in Filters

Working with Filter in Power Apps

Filtering collection columns

Making a fancier UI for your filter function

Inserting item into a collection - Form design

Inserting item into a collection - Adding code

Improving items display using Vertical Gallery

Improving collection item view

Some commonly used formulas in Power Apps

Deleting a record from collection

Updating single record in a collection using Patch function

Adding a calculated column to a collection

How to delete a record from a collection Properly

Working with aggregate functions (AverageMaxMinSum)

What we learned so far - Quick review

Solving the delete record mystery - Optional

In this section we will learn

Connecting Power Apps to Microsoft Excel on SharePointOneDrive

Display form and Edit form

Using Collect, Patch and Remove with Microsoft Excel files

SharePoint and Power Apps - Hosting Power apps inside SharePoint

How to use Edit form like a pro - Part 2

How to use Edit form like a pro - Part 1

Preparing SharePoint site for our demo

Converting a text field to Lookup in SharePoint using Power Apps

Using SharePoint as data source for Power Apps

Search, Filter and delegation

Customizing SharePoint forms using Power Apps

Updating more than one SharePoint list on Edit form submission

Sending email from Power Apps

Calling Power Automate Flow from Power Apps

Power Apps permissions - Easy but complicated!!!

Packaging an App with dependencies (Power Automate Flow)

Deploying Power App to a new environment

Understanding Power Platform environments

Your next course is free

About the Bonus section

Working with PowerApps Components

Adding navigation menu to PowerApps