Microsoft PowerApps crash course - from UI to Integration

Name: Microsoft PowerApps crash course - from UI to Integration
Rating: 4.8 (5196 reviews)

From "What is Power Apps?" to "Deploy your app and Flows to production" in one course.

Highest Rated

Created byAlireza Aliabadi

Last updated 11/2023

English

What you'll learn

What Microsoft PowerApps is and where it is used
How to create user interface elements using PowerApps
How to add functionality to the apps that are built using PowerApps
How to connect PowerApps to external sources (SharePoint, Excel and Automate Flows)
How to secure Power Apps
How to deploy Power Apps solutions
How to work with Power Automate Environments
How to customize SharePoint forms using Power Apps and adding additional functionalities to SharePoint forms

Course content

7 sections • 69 lectures • 13h 38m total length

Introduction to the course1:56
What is Microsoft Power Apps6:40
Let's see what Power Apps is and have a quick demo
Who can benefit from this course?4:44
Course Road Map2:07
Let's see how the course is structured and what we are going to learn in this course.
Licensing requirement for this course4:30
Learn about Power Apps licensing that you need for this course.

Why do we need JSON in Power Apps? (Skip if you already know JSON)7:47
I have free and short course for everyone taking my Power Apps and Power Automate courses. To get the basic JSON knowledge for this course assuming you don't know anything about JSON, you need only 30 minutes of my "JSON crash course" on Udemy.
Understanding Power Apps Environment10:43
In this lecture we review the features of Power Apps portal
Power Apps designer16:25
In this lecture you will learn about below items in Power Apps designer
Screens and components
Controls
Data
Media
App Checker
Save, run and share
Test your knowledge

Let's focus only on look and feel!2:22
Let's set the expectation on what we are going to learn in this section.
Adding and working with controls14:53
In this lecture you will learn:
Adding control to App Screen
Changing control properties
Adding basic functions to controls
Working with container control10:46
In this lecture you will learn:
Set screen as start up screen
Working with container control
Understanding control colors and opacity4:31
Dynamically changing control properties at run-time12:58
Learn to dynamically bind control properties at run time in PowerApps, using text inputs, labels, sliders, and containers, and explore self and parent references for responsive UI.
Grouping controls7:14
In this lecture you learn about control grouping.
Power Apps Simple vs Complex controls7:53
If and Contextual variables in Power Apps10:58
In this lecture we learn about two basic expressions that we need to work with controls:
- Understanding If expression
- Understanding contextual variables
Text Label and Text Input10:50
Let's learn about Text Label and Text Input
Adding some actions to Text input16:22
In this lecture we learn:
Enable save button on Power Apps screen when Text input value changes
Disable/Enable Text input by clicking a checkbox
HTML text and Rich Text Editor8:11
Working with Image and Video controls15:37
In this video you will learn about using Images and Videos in Power Apps
Working with Buttons, Shapes and Icons17:08
Do we really need buttons in Power Apps?
What is the difference between Shape and Icon?
Checkbox, Toggle and Date Picker are the easiest to work with9:11
Just a quick review on these simple controls and their important properties
Dropdown, List and Radio14:11
In this lecture you learn about the controls that allow users select one or a few options from a given list of selections.
Simple controls review
IMPORTANT - Before you start with complex controls13:51
Our complex controls work with Records and Collections and we go through these concepts before we actually start with complex controls.
Working with Combo box11:52
Working with Gallery and Data Table18:50
In this lecture you will learn about:
1. How to show combobox selected items on the screen
2. How to use and customize vertical gallery
3. How to use data table
Pie chart11:35
In this lecture we learn how to create a Pie chart from a collection
Cleaning up the app we made so far5:56
Not that much of training. We just clean up the app we developed so far.

Planning and preparation6:12
In this lecture we discuss the topics covered in this section. We also create the app we need for this section with required collection inside it.
Logical and comparison operators to use in Filters13:48
Working with Filter in Power Apps18:20
In this lecture we see how to use filter function to filter a collection rows based on filter values from a Text Input, Drop down and a combo box (multi select)
Making a fancier UI for your filter function10:59
No comments. Just watch this lecture and I am sure you enjoy it.
Filtering collection columns5:29
Improving items display using Vertical Gallery14:47
In this lecture we replace the data table with Vertical Gallery. We will also learn how to user Switch to apply conditional formatting to field labels.
Inserting item into a collection - Form design12:13
In this lecture we design the form that captures the values to be added to our collection
Inserting item into a collection - Adding code15:14
In this lecture we add code to implement insert functionality
Some commonly used formulas in Power Apps18:52
In this lecture we learn about below formulas:
Text
Value
Table
User
Improving collection item view16:34
Updating single record in a collection using Patch function21:38
In this lecture we create an edit screen for single record editing and then we use Patch function to enable single item update.
Deleting a record from collection3:05
Using remove function to delete a record from a collection
How to delete a record from a collection "Properly"17:05
Adding a calculated column to a collection9:26
In this video we will learn how to add calculated columns to a collection based on the values in other columns.
Working with aggregate functions (Average/Max/Min/Sum)14:11
In this lecture we start with aggregate functions (Average/Min/Max/Sum) and the we learn how to combine aggregate functions with filter.
What we learned so far - Quick review7:37
Please watch this lecture carefully and make sure you have a good grasp of every single topic before you go to the integration.
Accessing Contextual variables in other screens14:21
As mentioned before, this lecture covers the ways to share values across different screens in one App
Solving the delete record mystery - Optional19:13

In this section we will learn...2:32
Power Apps integration with
MS Excel
SharePoint
Email
Power Automate
Complex Controls
Edit Form
Display Form
Connecting Power Apps to Microsoft Excel on SharePoint/OneDrive11:03
Using Collect, Patch and Remove with Microsoft Excel files13:32
Display form and Edit form13:40
How to use "Edit form" like a pro - Part 124:12
How to use "Edit form" like a pro - Part 219:44
In this lecture we learn how to replace a Text input inside a Data card with a combobox.
SharePoint and Power Apps - Hosting Power apps inside SharePoint9:00
Preparing SharePoint site for our demo10:02
In this lecture we create lists that we need to connect and work with them inside SharePoint.
Customizing SharePoint forms using Power Apps15:07
Converting a text field to Lookup in SharePoint using Power Apps13:08
Using SharePoint as data source for Power Apps14:56
Search, Filter and delegation16:24
In this lecture we understand the difference between Filter and Search, review delegation in search and learn how to resolve delegation warning.
Updating more than one SharePoint list on Edit form submission25:22
Learn to build a Power Apps user interface for viewing, inserting, and editing orders in SharePoint, auto-fill unit price, calculate totals, and update product stock via patch on submit.
Calling Power Automate Flow from Power Apps22:34
Sending email from Power Apps9:12
In this lecture you will learn how create an email connector and send e-mail directly from Power Apps.

Power Apps permissions - Easy but complicated!!!10:32
Understanding Security roles in Power Apps:
1. Owner
2. Co-owner
3. User
Connector security and user license
Understanding Power Platform environments9:00
In this lecture you will learn about environments and how to create them in the Power Platform admin center
Packaging an App with dependencies (Power Automate Flow)6:56
In this lecture we export the App that we developed in this course with Poser Automate flow that the app relies on it for deployment to another environment.
Deploying Power App to a new environment5:16
Importing and testing the deployed app in the new environment.
Your next course is free5:25
This is how you can get your get your next course for free.

About the Bonus section1:14
Working with PowerApps Components20:40
This lecture covers creating and adding components to the PowerApps screens. We also cover creation of custom properties for components.
Adding navigation menu to PowerApps19:26
Learn to add navigation menus in Power Apps using a gallery or the modern tab list. Drive the sitemap as a global variable to navigate between screens or launch URLs.

Requirements

Basic understanding of JSON (JavaScript Object Notation)
Familiarity with SharePoint Online lists and libraries
Familiarity with OneDrive

Description

So you want to learn Power Apps and you have no clue what it is or you have checked lots of online resources and learned many bits and pieces and looking for a resource to connect all of them so that you can call yourself a Power Apps Developer.

This course starts from basics of the Power Platform and takes you to building fully functional apps that interact with external data sources (Excel, SharePoint and Power Automate); and by the end of the course we learn how to deploy the app and all its dependencies to another environment.

We are not using any ready-made templates/wizards. All samples are created from scratch based on Canvas app, while following the standards and best practices that enables you immediately understand apps that are created with templates so that you can make changes in them and customize them.

This course is presented in 4 major sections:

Understanding PowerApps UI and design elements which is mainly working with designer and learning about design posibilities in PowerApps
Learning to write code/expressions and adding functionality to the UI and bringing your UI to life
Learning about connectors and integrating the apps with external solutions (Excel on OneDrive, SharePoint and Power Automate Flows)
Security and deployment of PowerApps from Dev to other environments.

This is an all in one package with moderate pace that is slow enough for beginners to catch up and rich in content to keep the experienced students engaged.

Who this course is for:

Developers who are willing to use Power Apps in their next project
SharePoint consultants who want to customize SharePoint look and feel
Anybody who is looking for a quick and easy way to build cross platform apps in Microsoft platform

Microsoft PowerApps crash course - from UI to Integration

What you'll learn

Explore related topics

Course content

Introduction to Microsoft Power Apps5 lectures • 20min

Before we start3 lectures • 35min

Understanding Power Apps user interface elements20 lectures • 3hr 45min

Add functionality by introducing code to Power Apps18 lectures • 3hr 59min

Using connectors to interact with other solutions15 lectures • 3hr 40min

Security, updates, deployments and versions5 lectures • 37min

Bonus section - Lecture that you asked for them3 lectures • 41min

Requirements

Description

Who this course is for: