OpenCourser
Learn skills that shape your future
Visit OpenCourser.com
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.
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.
Let's see what Power Apps is and have a quick demo
Let's see how the course is structured and what we are going to learn in this course.
Learn about Power Apps licensing that you need for this course.
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.
In this lecture we review the features of Power Apps portal
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
This quiz includes basic JSON knowledge test and basic understanding of the Power Apps online tools.
Let's set the expectation on what we are going to learn in this section.
In this lecture you will learn:
Adding control to App Screen
Changing control properties
Adding basic functions to controls
In this lecture you will learn:
Set screen as start up screen
Working with container control
In this lecture you learn about control grouping.
In this lecture we learn about two basic expressions that we need to work with controls:
- Understanding If expression
- Understanding contextual variables
Let's learn about Text Label and Text Input
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
In this video you will learn about using Images and Videos in Power Apps
Do we really need buttons in Power Apps?
What is the difference between Shape and Icon?
Just a quick review on these simple controls and their important properties
In this lecture you learn about the controls that allow users select one or a few options from a given list of selections.
Let's review simple controls
Our complex controls work with Records and Collections and we go through these concepts before we actually start with complex controls.
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
In this lecture we learn how to create a Pie chart from a collection
Not that much of training. We just clean up the app we developed so far.
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.
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)
No comments. Just watch this lecture and I am sure you enjoy it.
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.
In this lecture we design the form that captures the values to be added to our collection
In this lecture we add code to implement insert functionality
In this lecture we learn about below formulas:
Text
Value
Table
User
In this lecture we create an edit screen for single record editing and then we use Patch function to enable single item update.
Using remove function to delete a record from a collection
In this video we will learn how to add calculated columns to a collection based on the values in other columns.
In this lecture we start with aggregate functions (Average/Min/Max/Sum) and the we learn how to combine aggregate functions with filter.
Please watch this lecture carefully and make sure you have a good grasp of every single topic before you go to the integration.
As mentioned before, this lecture covers the ways to share values across different screens in one App
Power Apps integration with
MS Excel
SharePoint
Power Automate
Complex Controls
Edit Form
Display Form
In this lecture we learn how to replace a Text input inside a Data card with a combobox.
In this lecture we create lists that we need to connect and work with them inside SharePoint.
In this lecture we understand the difference between Filter and Search, review delegation in search and learn how to resolve delegation warning.
In this lecture you will learn how create an email connector and send e-mail directly from Power Apps.
Understanding Security roles in Power Apps:
1. Owner
2. Co-owner
3. User
Connector security and user license
In this lecture you will learn about environments and how to create them in the Power Platform admin center
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.
Importing and testing the deployed app in the new environment.
This is how you can get your get your next course for free.
This lecture covers creating and adding components to the PowerApps screens. We also cover creation of custom properties for components.
SaveOpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
