
PowerApps provides a rapid development environment and data platform to build custom business apps by connecting to and storing data from sources like Excel, SQL, or Amazon servers.
Create apps quickly with a no-code, drag-and-drop interface. Run them anywhere and connect to any data source with easy connectors, offering extensive customization.
Learn PowerApps to quickly create impact and boost productivity by replacing Excel and paper processes with apps, a growing Microsoft tool used by Fortune 500s alongside Azure and Power BI.
Follow a structured journey from basic to advanced power apps, focusing on canvas apps, common data service, and model driven apps with hands-on practice, setup, reference materials, and further reading.
Connect to data sources in Power Apps by linking OneDrive or Google Drive and importing an Excel file; format as a table to create an app from it.
Explore the power apps development environment, a drag-and-drop low-code tool that builds apps from data sources like Excel, OneDrive, Google Sheets, or SQL.
Explore configuring detail screens in Power Apps with data cards, formatting dates with the text function, and building a dynamic title from the selected record’s first and last name.
Learn how the Power Apps edit screen uses an edit form and data cards, where update properties submit changes, enforce validation, and support read-only fields like passport and customer numbers.
Explore how to use Power Apps formulas to manipulate text and dates with the formula reference, including concatenation, text conversion, short date formatting, and month-year formatting using ThisItem data.
Use the navigate function to switch screens with transitions from data cards, navigate to detail or edit screens, and leverage the back function to return to the previous screen.
Learn to detect, identify, and resolve errors in Power Apps using inline error indicators, app checker, and targeted fixes across screens, plus consulting online solutions.
Create a canvas app master screen with a title label at font size 40, white title color, and a light gray background, following the documentation method.
Explore building galleries in a canvas app by connecting a OneDrive table, configuring title and subtitle, concatenating first and last names, and displaying location and VIP level, with tablet-mode layouts.
Add a top navigation with a white home icon, connect its onselect to navigate to the view customers screen, and use back or navigate to return to the home screen.
Explore how contextual variables work in Power Apps, creating screen-scoped values with update context, such as first number and second number, and compute their sum and counter increments.
Create and manage collections in Power Apps using the collect function to store two-column records, dynamically add items via text inputs, display them in a gallery, and remove items.
Learn how to implement data validation in Power Apps using the isMatch function to prevent digits in names, display a validation error, and optionally disable the submit button.
Add a new Excel data source named agents, save to your drive, convert to a table with headers, and connect it to Power Apps for multi-source data integration.
Publish your Power Apps project by choosing file, save, then publish this version to push updates to all users and enable native opening on devices.
Set the app's first screen by moving a screen to the top, replace the master screen with the home screen, then save, publish, and refresh to see the change.
Discover how to use Microsoft Docs to master canvas apps, navigating design, control references, and formula basics, then apply relational data and accessibility concepts in your applications.
Explore cascading drop-downs in a Power Apps app. Create dependent location and VIP level filters using distinct, sort by columns, and filter functions to reveal matching records.
Add delete button on detail screen to remove selected record from table one with the remove function and Gallery2.Selected, then navigate back to view customer screen with cover transition.
Learn to implement a delete confirmation popup in power apps by updating a confirmation variable, showing a grouped popup with yes/no buttons, and navigating to the view customer screen.
Explore how entities use fields and relationships to connect accounts, users, sales, and discounts through many-to-one, one-to-many, and many-to-many patterns.
Add fields to the customer entity, such as first name and last name, choose text data types, set optional, recommended, or required, and explore calculated fields like full name.
Explore viewing and editing data in Power Apps by inspecting the customer table, viewing all fields, and creating a calculated full name by concatenating first name, space, and last name.
Create custom views in Power Apps to display a subset of fields from the underlying data. Sort, filter by vip level, and publish views to tailor presentation for model-driven apps.
Create and customize forms in Power Apps by building a main form, adding fields and sections, and configuring properties to add or edit customer records.
Explore other common data service concepts and leverage dataflows to automatically load up-to-date data into common data service; connect sources, use gateways, and see views and forms in model-driven apps.
Learn how to use the image element in Power Apps to display, customize, and upload images, making logos or icons clickable and replacing default icons on screens.
Learn how to integrate a camera control in Power Apps, capture photos, and bind them to an image or gallery across screens to create a professional app.
Open Power Apps, create a new model-driven app named FirstModelDrivenApp, optionally add a description and customize the icon, skip the welcome page, then click done to create the app.
Edit forms and views in Power Apps by configuring which views appear for users, then customize forms, charts, and dashboards tied to the entity in the Common Data Service.
Configure a central business rule that validates VIP level and location on the form, preventing submission when conditions fail, and ensuring the rule propagates across all data and forms.
Set up a new Power Apps environment called PortalTester, create a database for portals, select USD and English, and prepare the common data service layout before building a portal.
Navigate to data and select entities to create a new entity named Agents, then set the primary field to ID and click done to finalize the entity.
Add portal components by selecting a section, insert a text title, adjust font size to 36, bold it, and apply blue color to customize your page.
Populate a Power Apps entity by connecting it to a data source such as OneDrive Excel and adding a form to enter records like first name, last name, and location.
Learn to add portal forms in power apps by creating a new agent form on the agents entity, configuring quick view and main forms, and publishing changes.
*** BONUS lecture added: Overview of PowerApps Portals
*** Note that the terms PowerApps and Power Apps can be used interchangeably
Learn from more than 7 hours of relevant instructional video content, with many resources and further reading at your disposal!
Build powerful, impactful business applications with no code. PowerApps is a development environment and data layer created by Microsoft to quickly create applications for all organizations. Think of Power Apps as Microsoft Word, but instead of building documents you are building real-life applications. PowerApps is quickly growing to become the number 1 no code development environment.
PowerApps is quickly growing in demand and is currently the highest adopted system is medium-to-large companies and one of the most sought after Microsoft skills. We have seen freelance consultants, analysts, and managers who use the knowledge from this course to get paid more, create impact, get hired, and become successful.
This is the complete guide to Microsoft Power Apps. This course is not only comprehensive (it covers everything you need to know right from the start / beginner level) but is also instructional in nature, meaning that as we learn new concepts, we are also integrating them in the application. Don't just learn concepts, learn how to actually apply them. That also means that whether you are a beginner or expert in PowerApps, there's something for you in this course.
This course also expands your knowledge and explores further concepts such as the Dataverse and integration of Model-Driven Applications. If you are familiar with other Microsoft Power Platform items, then you need to add PowerApps to your arsenal. Power Apps is especially useful in combination with Power Automate.
Again, this is the complete guide to Power Apps - you won't ever need another course. We will also update the course if there is a newer version of if newer features get released!
What is PowerApps?
PowerApps in a Microsoft tool used to develop data-driven business applications. It serves as both a development environment and data layer that allows users, analysts, and managers, to build scalable applications with no code. Almost all manual Excel / paper processes can be replaced by Power Apps. PowerApps is quickly growing to become the number 1 no code development environment.
What are the main features of PowerApps?
Microsoft ecosystem - Power Apps is similar to other familiar Microsoft applications, like Word or Excel. It has the same ribbon structure and similar design, which makes it easy to learn and transfer knowledge. PowerApps is the Microsoft's way to build applications, similar to how PowerPoint is Microsoft's way to build presentations
Easy to use - No coding necessary or even required. Similar to other Microsoft applications, it's a drag-and-drop system which makes thing easy, and has an amazing user-friendly interface
Build it once, run it everywhere - Once you build a PowerApps applications, it can be run anywhere with no further development. This means that your application can easily go from phone, tablet, and web without any more effort, and can be run on all systems (Windows, Mac, Linux).
Connect to anything - Microsoft's in-built data connectors allow you to easily connect to any data sources, whether it's in OneDrive, Google Sheets, SQL, RedShift, your computer's filesystem, S3, you get the idea (every data source)
Customize to your heart's desire - PowerApps allows you to build your app your way. This means that you can build the application in your vision - your imagination is your only limitation!
Why Learn PowerApps?
Create impact fast - Power Apps allows you to build applications fast, so if you're looking to quickly build scalable applications, this is for you
Increase your and your organizations productivity - Do you have a process in your organization or with yourself that is currently that is managed by shared Excel files or, worse yet, paper? PowerApps allows you to replace this with a data-driven application
Get hired / increase your employability - PowerApps is one of the fastest growing tools in medium-to-large businesses, and is expected to be the top sought after Microsoft skill. Put this skill on your resume to boost your chances and pay rate.
Improve your toolkit - Add this to your list of Microsoft skills - this is very powerful in conjunction with other Microsoft products (Office, PowerBI, Azure, 365, etc.)
Why Take This Course?
Complete guide - this is the 100% start to finish, zero to hero, basic to advanced guide on PowerApps. There is no other course like it that teaches you everything from start to finish.
Fully instructional - we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the PowerApps features, but a course that actually builds applications with you
Learn to learn - During the latter parts of the course, we go through situations where we encounter new features or errors, and work through how we would use the documentation to resolve them. In this way, you not only learn about Power Apps inside and out, but learn how to resolve your own issues as they come up. You will become a PowerApps master.
Teacher response - I have a response time of <8 hours, so if there's anything else you would like to learn, or if there's something you cannot figure out, I'm here for you!
Great resources - Example data, resources, and further reading can help you in your learning journey
Course and Module Overview
Introduction - learn about PowerApps and how it fits into Microsoft's ecosystem
Environment Setup - make a Power Apps account and import data
Basic: PowerApps Concepts - build and run your first application through data loader
Beginner: Canvas Apps - learn Canvas App concepts (layout, galleries, forms, functions, formulas
Intermediate: Canvas Apps - build your Canvas App knowledge (navigation, screens, variables, filter, lookup, data validation, multiple data sources, phone calls)
Expert: Canvas Apps - take your Canvas App knowledge to the next level (grouping, complex functions, cascading, reading the docs)
Expert: Common Data Service - learn how to integrate your data with Microsoft's data layer
Advanced: Canvas Apps - master your Canvas App knowledge (image inputs, camera, videos, option sets, charts and graphs)
Advanced: Model-Driven Apps - build Model-Driven Applications for your organization
Reference Material - sample data and other items used in the course
Further Reading - resources to help you expand your knowledge
If you want to learn Microsoft PowerApps / Power Apps, this is the course for you. We're looking forward to having you in the course and hope you earn the certificate.
Music: Bensound