A Hands-on Guide to PowerApps & The Power Platform
- Description
- Curriculum
- FAQ
- Reviews
In this course, we are going to dive deep into PowerApps and the Power Platform by creating our very own full-fledged application that can be used in College Projects and Resumes. We are going to discover Microsoft’s Power Platform by creating industry-grade apps on it while using minimal code.
We are going to create a Leave Approval app from scratch which is going to capture leave requests by employees and then forward them to the HR and Manager for approval and their comments. The employees can add, edit, and track the status of their leaves.
No prior programming experience is required. But you need to ensure that you have a device with a stable internet connection and running any modern web browser. No additional software installation is required.
At the end of this course, you will be able to:
· Get the basics and application of a No Code Low Code Platform
· Utilize SharePoint lists as a database
· Create blueprints and designs for apps
· Get an in-depth hands-on with PowerApps
Inside PowerApps, you will be able to:
· Create Forms to get data from the user and modify existing data
· Create Galleries to show data to the user
· Use Collections to increase the robustness of the app
· Fill data dynamically for the user based on the user’s login
· Validate data entered by the user
-
1
Why PowerAppsAfter completing this lecture, you will be able to:
Define PowerApps and Microsoft Power Platform
Diffrentiatiate between low-code and no-code platforms
Define the features of PowerApps
-
2
Who is this course designed for?
This course is designed for Students, Professionals, and Freelancers. However, you are free to take up this course even if you are just curious.
-
3
Prerequisites
At the end of this lecture, you will be able to get a list of requirements and recommendations before starting off with this course.
-
4
How to get maximum output
In this lecture, I have shared some tips and tricks which you can apply while moving through this course in order to maximize the output generated by this course.
-
5
What we are going to cover
In this lecture, I have covered the course syllabus in very brief. You will also get a high-level idea of what each of the modules of this course is all about.
-
6
Getting Started with Udemy & its controls
At the end of this lecture, you will:
Be able to navigate your way across Udemy
Be familiar with the video controls on Udemy
Be able to ask questions and view announcements
Be able to access the entire course playlist and jump across videos
Learn how to take notes during the course
-
7
PowerApps Developer Plan
After completing this lecture, you will be able to apply for Microsoft PowerApps Developer Plan from Microsoft's official website.
-
8
Microsoft 365 Developer Program
At the end of this lecture, you will be able to get a renewable 90 days trial of the Microsoft 365 E5 license through Microsoft 365 Developer Program.
-
9
Microsoft 365 E3 and E5 licensing
After completing this lecture, you will be able to,
Differentiate between Microsoft 365 E3 and E5 licenses
Apply for Microsoft 365 E3 and/or E5 free trial license.
-
10
Why Blueprint
After completing this lecture, you will be able to appreciate the use of a blueprint and planning before starting with anything new.
-
11
Components of App Screen
After completing this lecture, you will be able to design the UI of each screen of the Leave Approval App on paper.
-
12
Designing Lists and Columns
-
13
Why SharePoint?
At the end of this lecture, you will:
Get an idea of different databases that can be utilized.
Know exactly why we are preferring SharePoint here.
-
14
Provisioning a SharePoint list for data
After completing this lecture, you will be able to,
Provision a SharePoint site
Create lists in SharePoint
Crete columns in the Sharepoint list
Utilize SharePoint lists as database
-
15
Saving an App
After completing this lecture, you will be able to use the Save As and Save functions within PowerApps to save apps.
-
16
Sharing an App
At the end of this lecture, you will be able to share a fully or partially created app with your team for testing and further development.
-
17
Publishing an App
At the end of this lecture, you will be able to publish an app from PowerApps so that a user can use the app.
-
18
Playing an App
At the end of this lecture, you will be able to interact with the app as if you were the intended user for the app.
-
19
Restoring an App to a Previous Version
At the end of this lecture, you will be able to restore apps to their previous versions inside PowerApps.
-
20
Help
At the end of this lecture, you will be able to:
Ask questions in Udemy
Look for solutions on the internet
Access official Microsoft Power Platform documentation
-
21
PowerApps Studio Walkthrough
At the end of this lecture, you will be able to navigate your way through the PowerApps Studio and learn about the various functions of the PowerApps Studio.
-
22
App Settings
At the end of this lecture, you will be able to modify basic settings such as changing the screen resolution, icons, and name of the app created in PowerApps Studio.
-
23
Getting Started with Forms
At the end of this lecture, you will be able to add a Form to the Leave Approval app and take user inputs.
-
24
Repositioning Data Cards in Form
At the end of the lecture, you will be able to set the position of individual data cards according to your requirements inside a form in PowerApps.
-
25
Resizing the Data Cards
At the end of the lecture, you will be able to set the width and height of individual data cards according to your requirements inside a form in PowerApps.
-
26
Customizing Data Cards
At the end of this lecture, you will be able to customize the type of input accepted by Form Data Cards.
-
27
AutoFill Data Cards in Forms
At the end of this lecture, you will be able to dynamically pre-populate existing Form Data Cards with details depending on the logged-in user.
-
28
Using Drop-Down controls
At the end of this lecture, you will be able to add and configure a dropdown control inside a form in PowerApps.
-
29
Renaming Data Card Keys
At the end of this lecture, you will be able to modify the name of data card keys inside a Form in PowerApps according to your requirements.
-
30
Navigating Across Screens, Submitting and Resetting the Form
At the end of the lecture, you will be able to program buttons and icons to:
Navigate across different screens of your app
Submit Forms
Reset Forms
-
31
What is a Gallery
At the end of this lecture, you will be able to,
Define galleries in the context of PowerApps
Appreciate the use and importance of galleries inside PowerApps
Creating different types of galleries inside PowerApps
-
32
Adding a Gallery to Screen
At the end of this lecture, you will be able to Add Galleries inside a PowerApps Screen.
-
33
Sorting a Gallery
At the end of this lecture, you will be able to sort a gallery based on any of the columns of its parent database.
-
34
Searching through the Gallery
At the end of this lecture, you will be able to search through the contents of a gallery using a dedicated search box.
-
35
Adding controls to the Gallery
At the end of this lecture, you will be able to add icons and buttons to the gallery which can perform specific functions with respect to the selected item from the gallery.
-
36
Introduction to Collections
At the end of this lecture, you will be able to:
Define a Collection
Appreciate the benefits of using a collection
Learn about the limitations of collections and how to overcome them
-
37
Dynamic Gallery Items based on logged in user
At the end of this lecture, you will be able to display items inside a gallery based on the logged-in user.
-
38
Check value(s) stored in Collections & Variables
At the end of this lecture, you will be able to view the data stored inside collections and variables using different means.
-
39
Set up Start Screen for the App
At the end of this lecture, you will be able to define a landing screen for the users of your app.
-
40
Validation: Set up Start Screen for the App
This lecture checks if different users are able to view different items in the gallery or not.
-
41
Disable Submit icon for HR and Manager
At the end of this lecture, you will be able to check the designation of the logged-in user and dynamically disable the Submit Icon if the logged-in user is HR or Manager.
-
42
Validation: Disable Submit icon for HR and Manager
This lecture intends to check if the SUbmit icon is actually getting disabled when HR or Manager is logging into the app.
-
43
HR and Manager Comments and Approve Button Functionality
At the end of this lecture, you will be able to add two icons that will be visible to only HRs and Managers and they will be able to use them to approve or reject a leave.
-
44
Validation: HR and Manager Comments and Approve Button Functionality
The lecture intends to validate whether the Approve and Reject buttons are working as expected.
-
45
View Comments added by HR and/or Manager
At the end of this lecture, you will be able to add some additional fields to the Leave Form so that the user can view the comments provided by the HR and Manager on his leave.
-
46
Validation: View Comments added by HR and/or Manager
This lecture checks if the user is able to view comments added by HR and/or Manager on his/her leave(s).
-
47
Configure Form height to be dynamic
At the end of this lecture, you will be able to set the dynamic height for the Leave Form.
-
48
Validation: Configure Form height to be dynamic
The lecture validates if the Form is actually changing its height depending upon the number of Data Cards visible in it.
-
49
Change arrow color in Gallery for Approved and Rejected Leaves
At the end of this lecture, you will be able to set the color of the Arrow Icon in the Gallery dynamically.
-
50
Disable Submit Icon for Approved or Rejected Leaves
At the end of this lecture, you will be able to disable the Submit Icon for leaves that have been approved or rejected.
-
51
Use Notify Function to validate data entered by the User
At the end of this lecture, you will be able to use the Notify function of PowerApps to send in-app notifications to the users and check if the data entered by them is valid.
