
This is a brief introduction to Power Apps. I cover what Power Apps is, why it's useful to know, and why you should enroll in this course.
Before you can start using Power Apps, you will first need to sign up for an Office 365 account. In this lecture I go over how to do this and what type of subscription you'll need in order to get access to Power Apps.
There are many different databases available to use within Power Apps, with one of the simplest being Microsoft Excel. In this lesson, we'll go over how to set up Excel as a database for our apps.
Power Apps makes it very simple to set up your first CRUD app, and that is what we'll do in this lesson. It will be a 3-screen app that has a summary page, a detail page, and an edit page.
Running a Power Apps application in the browser is as simple as clicking the play button. In this lesson we'll run this app for the first time, and go over all of the main features of the app.
In this lesson, we'll begin to add our own style to the app we've created. Power Apps makes this very simple by providing properties that we can edit to customize our app to suit our needs.
Before we get to far in building out our app, it's important to gain a solid grasp of the editing environment in Power Apps. We'll go over tree view, as well as many of the various elements and properties that are available to edit in the Power Apps environment.
Many of the same functions and formulas that exist in Microsoft Excel are also available in Power Apps. We'll go over how to start using functions and formulas in order to make our app more dynamic.
In this lesson we'll go over the elements in the detail screen of our application.
An overview of forms in Power Apps.
An overview of the edit screen of our app as well as more discussion about forms in Power Apps.
In this lesson we will go over triggers in Power Apps, and we'll update a trigger in one of our forms.
How to publish an app in Power Apps as well as how to run it on your phone using the Power Apps mobile application.
An overview of the golf scorecard app that we'll be building in this section.
How to create a cohesive theme in Power Apps, so that you don't have to style every new screen that you create individually.
How to create templates in Power Apps, so that each time we create a new screen, we can simply duplicate one of our existing templates rather than having to create the new screen from scratch.
How to create custom navigation in Power Apps using links.
We will add all of the pages for this application, but we will not yet add any content to those pages.
How to add a gallery to an application in Power Apps.
The Search function is one of the most important functions in Power Apps and is one of the ways you can filter a list. In this lesson we'll go over how to use the Search function and then we'll connect it to our gallery so that we can filter it by a search term.
We'll add a detail screen so that we can see more information about any particular record than what is available on the main screen.
When building an application in Power Apps, often times one data source is not enough. In this lesson, we'll cover how you can add additional data sources to your application.
Similar to the VLOOKUP function in Excel, the LookUp function is a very powerful function that can be used in Power Apps. We'll go over how to use it, along with an example.
Here we'll build out the edit screen of our app so that we can edit individual records.
A brief overview of variables in Power Apps.
We'll go over context variables which are variables that have a limited scope within Power Apps.
We'll discuss global variables, which are variables that can be accessed from anywhere inside your Power Apps application.
Collections are variables that can store an entire table and can therefore be used as a data source in Power Apps. We'll go over how to create, manipulate, and reference a collection.
How to use the Remove function to delete a record from a Power Apps data source.
The default 3-screen app that Power Apps generates doesn't offer the best user experience when it comes to deleting a record, so we'll improve that by adding a modal.
How to create a new record in our database using Power Apps forms.
We'll go over how to add a data table, which is a way to display a data source in Power Apps, if you don't necessarily need a way for your users to edit that data source.
Similar to the Search function, the Filter function can also be used to filter a list in Power Apps. We'll go over how to use this function along with an example.
We'll go over how to make updates to our Theme screen in order to change the look and feel of our entire app.
An overview of the app we'll be building for managing contacts.
We'll go over the data source we'll be using for this app, then we'll build the initial application.
We'll cover many of the most common functions available for working with dates in Power Apps.
This lesson will cover how to launch external applications from within Power Apps using the launch function.
How to populate a Power Apps dropdown by referencing a table and how to fix issues that arise.
How to create a Power Apps dropdown whose values are dependent upon the value selected in another dropdown.
We'll connect the dropdowns from the previous lesson to our gallery in order to complete this application.
GET CERTIFIED TODAY!
After completing this course, you will receive a certificate of completion indicating that you are Power Apps Certified, and you can add this certificate to your resume, LinkedIn, or other online profiles.
What is Power Apps?
Power Apps is a tool created by Microsoft that enables users to create useful applications quickly, without needing to know how to code. Since it allows non-programmers to create applications, it has quickly become one of the most popular frameworks for creating apps that improve business efficiency.
Why Power Apps?
It’s Microsoft: Since Power Apps was built by Microsoft, it has a familiar and intuitive interface for anyone that has used Office products like Excel or Word
Easy to Learn: Power Apps is a low code framework, which means you can create sophisticated applications using a simple drag and drop environment
Rapid Application Development (RAD): Power Apps allows you to create applications in a fraction of the time it would take using other popular frameworks like React or Angular
Valuable Skill: This highly sought after skill will make you an attractive candidate for a job or could even help you get a raise in your current role
Cross Platform: Power Apps can run on any device, Windows, Mac, Linux, Android, or iOS, so you don’t have to worry about building out several different versions of your apps
Connect to any data source: Whether you prefer Excel, SQL Server, Google Sheets, or PostgreSQL, Power Apps has you covered with built in connections to almost any data source
Why take this course over another?
Crash Course: Have you ever started a course and noticed that after watching an hour or more of content you still haven’t learned anything? Well, not this course. There is absolutely no fluff, just valuable content
Top Rated: The reviews speak for themselves, but if you’re still not convinced, there is also Udemy’s 30-day money-back guarantee, there is literally nothing to lose
Expert Instructor: With over a decade of experience working in technology, and expertise in a wide range of topics from analytics to software development, you can rest assured that you are learning from the best
Hands-on learning: No boring theory, just hands on learning building an actual application right from the start
What is covered in this course?
How to generate your first app in minutes: That’s right, within the first few minutes of the course you will already have built your first app
Running your app in the browser: Whether you’re using Chrome, Firefox, Edge, Safari, or something else, it doesn’t matter, you will learn how to run your app in the browser
Connecting to Excel: Using the built-in connections, we will go over how you can use Excel as a database for a full-fledged application
Customizing your app: The built-in styles of Power Apps are nice, but we’ll go over how you can make your app truly your own, by changing the theme and customizing it however you like
Formulas and Functions: Much like Excel, Power Apps also makes use of formulas and functions to help with displaying data, and we’ll cover this critical topic in detail
Triggers: We’ll go over how to respond to specific user events in Power Apps, such as the click of a button, using triggers
Forms: No software development course would be complete without covering forms, we’ll go over the specifics of how they work in Power Apps
How to publish your app: Many other courses fall short here, they show you how to build an app, but not how to publish it so that others can use it, we’ll go over how to publish an app with Power Apps and how to run it on your phone
Creating a Power Apps Theme and Templates: You will learn best practices for how to structure your app so that future changes will be much simpler
Power Apps Navigation: We will build out a navigation system for a website with an intuitive look and feel, all from scratch
Adding new pages in Power Apps: We will go over how to duplicate pages using the templates we’ve created so that everything in our app is linked to the theme
Adding and Customizing Galleries: We will add and customize a gallery to display data in a logical way
The “Search” Function: This is one of the most powerful functions in Power Apps, and we will use it to create a search bar to search within our gallery
The “Filter” Function: This function allows us to filter a data source in Power Apps according to any criteria we specify
The “LookUp” Function: Similar to the VLookUp function in Excel, Power Apps provides the LookUp function so that we can look up values from a second table
The “Remove” Function: This is the function used to delete a record from a data source in Power Apps, we will go over how to use this function and will integrate it into our app
Adding multiple data sources: In Power Apps, you are not constrained to simply using one table as your data source, we will go over how to add more data sources so that you can create complex applications
Variables in Power Apps: We will go over how variables work, how they are different in Power Apps compared to other programming languages, as well as the 3 main types of variables 1. Context Variables, 2. Global Variables, and 3. Collections, we will go over examples of how to use all three
Building a Modal: We will go over how to build a modal from scratch in Power Apps, which will improve the user experience drastically
Date comparisons in Power Apps: Using the function DateDiff, as well as other date functions like Today, Date, Year, Month, and Day
How to open external apps from within Power Apps: We will go over several examples of how to use the Launch function to open applications like phone, email, websites, and other Power Apps applications
Populating dropdowns from a table: This can be a tricky topic because by default, Power Apps doesn’t filter out duplicates, so we’ll go over how to do this the right way
Cascading dropdowns: By learning how to implement this advanced feature, you will take the user experience of your apps to the next level!