We may earn an affiliate commission when you visit our partners.
Henry Habib

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.

Read more

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

Enroll now

What's inside

Learning objectives

  • Navigate the microsoft powerapps environment
  • Become an absolute expert in microsoft powerapps, get valuable preparation for certification, and add the skill to your toolkit
  • Create real functional business application, on the web, tablets, and phones for businesses and organizations
  • Create both canvas applications and model-driven applications, that are responsive and structured
  • Connect to different sources of data (onedrive, google drive, sql, etc.)
  • Set up your own common data service using example data, with complex business rules
  • Leverage the microsoft ecosystem to expand your app building knowledge with developer tools
  • Read microsoft powerapps documentation and resolve errors for future application builds

Syllabus

Introduction
What is PowerApps?
Course tips
PowerApps Features
Read more
Why learn PowerApps?
Instructor overview
Ways to reach out
Course overview
Additional material
Watch in 1080p
Environment Setup
PowerApps account
Connecting to data - OneDrive
Connecting to data - Google Sheets
Where to find reference material
Basic: PowerApps Concepts
Development environment
Running your first application
Saving your application
Basic functionality
Customizing
Beginner: Canvas Apps
Environment layout, views, elements, and properties
Introduction to galleries
Forms and data cards
Property assignment
Edit forms, updates, textboxes
Triggers
Introduction to functions and formulas
Introduction to navigation
Error checking
Publish your application
Run application on your phone
Intermediate: Canvas Apps
Create Canvas App from scratch, master, and documentation screens
Customizing the look of the application, documentation links
Buttons
Galleries
Customizing galleries
Navigation
Introduction to variables
Contextual variables
Global variables
Collections
Adding a search field
Filter functions
Creating the Detail screen
Creating the Edit Form screen
Linking up navigation on screens
Creating the New Form screen
Data validation (ismatch)
Data validation (variables)
Connecting to multiple data sources 1
Connecting to multiple data sources 2
Data tables
Lookup
Adding call functionality
Change screen order
Expert: Canvas Apps
Documentation
User() function
Today() and Now() functions
Grouping elements
Launching other services
Cascading dropdown 1
Cascading dropdown 2
Delete button
Popups for confirmations
Expert: Common Data Service
CDS environment setup
Entities
Relationships in entities
Business rules and views
Forms, dashboards, charts, keys, and data
Creating an entity
Adding text fields
Adding calculated fields
Adding option set data
Adding other fields
Uploading data
Viewing the data
Creating custom views
Creating custom forms
Creating business rules 1
Creating business rules 2
Other CDS concepts
Advanced: Canvas Apps
Input elements 1
Input elements 2
Input elements 3
Image element
Combining image with pen inputs
Combining image with camera input
Combining image with upload photo input
Images in galleries
Charts and graphs

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Covers both Canvas and Model-Driven apps, providing a comprehensive understanding of Power Apps development, which is useful for different types of application needs
Explores integration with various data sources like OneDrive, Google Sheets, and SQL, which allows learners to connect Power Apps to their existing data infrastructure
Teaches learners how to read Microsoft PowerApps documentation and resolve errors, which empowers them to independently tackle future application builds and challenges
Includes a bonus lecture on PowerApps Portals, which expands the scope of the course and introduces learners to another important aspect of the Power Apps ecosystem
Requires learners to set up their own Common Data Service using example data, which may require a Microsoft account and potentially incur costs depending on usage and storage needs
Features content on connecting to data using OneDrive and Google Sheets, which may require learners to have existing accounts and familiarity with these services

Save this course

Save Power Apps - Complete Guide to Microsoft PowerApps to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Power Apps - Complete Guide to Microsoft PowerApps with these activities:
Review Excel Formulas and Functions
Reviewing Excel formulas and functions will help you better understand how Power Apps connects to and manipulates data from Excel spreadsheets, a common data source.
Browse courses on Excel Formulas
Show steps
  • Identify key Excel formulas used for data manipulation.
  • Practice using these formulas with sample datasets.
  • Review common Excel functions for data validation.
Read 'Microsoft PowerApps Cookbook'
Reading this book will provide practical examples and solutions to common Power Apps development challenges, enhancing your ability to build complex applications.
Show steps
  • Select chapters relevant to your current Power Apps projects.
  • Follow the recipes and examples provided in the book.
  • Adapt the solutions to your specific use cases.
Build a Simple Inventory Management App
Building an inventory management app will allow you to apply the concepts learned in the course, such as data connections, forms, and galleries, in a practical scenario.
Show steps
  • Design the data structure for your inventory items.
  • Create a Power Apps app with screens for viewing, adding, and editing inventory items.
  • Connect the app to a data source (e.g., Excel, SharePoint list).
  • Implement search and filtering functionality.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Explore 'Low-Code Development with Microsoft Power Platform'
Exploring this book will broaden your understanding of the Power Platform ecosystem and how Power Apps integrates with other Microsoft services.
Show steps
  • Read the chapters on Power Apps and its integration with other Power Platform tools.
  • Identify opportunities to leverage other Power Platform tools in your Power Apps projects.
  • Experiment with building solutions that combine multiple Power Platform components.
Document Your Power Apps Projects
Documenting your Power Apps projects will reinforce your understanding of the app's functionality and improve your ability to troubleshoot and maintain it.
Show steps
  • Create a document outlining the app's purpose and features.
  • Describe the data sources used and how they are connected.
  • Explain the logic behind key formulas and functions.
  • Include screenshots and diagrams to illustrate the app's design.
Follow Advanced Power Apps Tutorials
Following advanced tutorials will expose you to more complex Power Apps concepts and techniques, expanding your skillset and enabling you to build more sophisticated applications.
Show steps
  • Search for tutorials on topics such as custom connectors or advanced formulas.
  • Follow the tutorial step-by-step, building the example app.
  • Adapt the techniques learned to your own projects.
Contribute to Power Apps Community Forums
Contributing to community forums will reinforce your knowledge by helping others and exposing you to different perspectives and solutions.
Show steps
  • Browse Power Apps community forums for unanswered questions.
  • Share your knowledge and experience to help other users.
  • Provide clear and concise explanations with examples.

Career center

Learners who complete Power Apps - Complete Guide to Microsoft PowerApps will develop knowledge and skills that may be useful to these careers:
Business Application Developer
A Business Application Developer creates custom software solutions to streamline business processes. This often includes building applications with no-code or low-code platforms like Power Apps. This course is a perfect fit because it provides comprehensive instruction on Power Apps, Microsoft's primary no-code application development tool. The course covers everything from basic concepts to building complex canvas and model-driven applications, skills crucial for a Business Application Developer. Learning about connecting to diverse data sources, implementing business rules, and mastering navigation techniques will also heavily assist in creating effective software solutions for business problems. The course also emphasizes practical application building, which is exactly what a business application developer does by creating real life business applications. Furthermore the course teaches you how resolve issues that come up when building your own application.
Citizen Developer
Citizen Developers create applications for themselves or their teams, often using no-code platforms. This course is ideal for an aspiring Citizen Developer as it focuses exclusively on Microsoft Power Apps, a leading no-code platform. The course provides a thorough education on how to build applications from scratch, connect them to data sources, and customize them to meet specific needs. A Citizen Developer must be able to create impactful applications, and this course emphasizes building scalable applications, which is very important. The course covers both canvas and model-driven apps, providing the full scope of development using Power Apps. Furthermore, this course teaches how to leverage the Power Apps ecosystem to expand your app building skills.
Process Automation Specialist
A Process Automation Specialist identifies and automates manual processes. This often involves creating applications. This course helps to build a strong background in Power Apps, which is a highly effective tool for automating business processes. The course goes from basic to advanced topics such as data validation, data tables, lookups, and functions. These topics help to build the skillset required to create applications that handle and automate complex workflows. The course also covers integration with Microsoft's data layer. Using this knowledge helps to create automations that are scalable across an organization. The course also teaches how to resolve errors and troubleshoot which are required skills in this role.
Digital Transformation Consultant
Digital Transformation Consultants guide organizations in adopting new technologies to improve business processes. A consultant in digital transformation could leverage the knowledge of Power Apps which this course provides. Power Apps is a tool that helps organizations rapidly adapt to new technologies and digital transformations. This course teaches how to build applications, connect to diverse data sources, and implement business logic all of which are crucial for a consultant to advise a company on digital transformations. The course's focus on building both canvas and model-driven applications, as well as connecting to different sources of data, ensures that a Digital Transformation Consultant will be able to build applications that are suited for their organization's needs. The comprehensive nature of the course makes it a valuable resource for consultants.
Data Analyst
A Data Analyst examines data to identify trends and insights that help businesses make decisions. Often, data analysts use applications to access and manage data. This course helps a Data Analyst to work with Microsoft's Power Apps. Power Apps enables the creation of data-driven applications. This course shows how to connect Power Apps to a variety of data sources. The course will also help the Data Analyst by teaching how to implement data validation and create data tables. Additionally the course teaches how to integrate with Microsoft's data layer. This is helpful for a data analyst to understand the underlying data. Although this is not a data analysis course, familiarity with Power Apps will help a data analyst streamline workflows.
Business Analyst
A Business Analyst identifies business problems and proposes solutions. This may involve creating applications, which this course can help with. Understanding how to develop applications using Microsoft's Power Apps allows business analysts to create applications to test and implement solutions. This course explores data connections and provides the opportunity to learn how to work with data sources. A business analyst will also find it useful to understand how to implement business rules, forms, and dashboards, which are all covered in detail in this course. By learning both canvas and model-driven applications, a Business Analyst gains a tool to create applications that provide business solutions. This course emphasizes practical application building and teaches you how to resolve your own issues.
IT Support Specialist
An IT Support Specialist provides technical assistance to users. A key part of this involves helping users work with new technologies. This course offers a detailed education of Microsoft Power Apps, which will help an IT Support Specialist to support their clients using the technology. The course includes both basic and advanced topics which include data connections, canvas and model driven apps, and also troubleshooting. This allows an IT specialist to provide a wide range of support. By understanding how to build applications, the IT Support Specialist will be able to help internal users adopt this technology. This course enhances the technical skills of an IT Support Specialist. The course also covers working with various data sources and resolving errors, which are both important in this role.
Solutions Architect
A Solutions Architect is responsible for designing and overseeing the implementation of a technology solution for a business problem. Power Apps is one of many tools in a Solutions Architect's tool kit. This course will help a solutions architect by providing a detailed understanding of Power Apps from basic to expert level. The detailed course syllabus includes how to connect to data sources, build canvas and model driven apps, implement business logic and rules, and customize applications. The course emphasizes practical application, which is critical for a solutions architect who must understand how a solution works before deployment. A Solutions Architect may recommend Power Apps to a client, and with this course, a solutions architect would have the expertise to do so effectively. This course is especially helpful because it also shows a user how to resolve issues on their own.
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. This may involve managing a team that builds applications. This course provides helpful knowledge about application development in Power Apps. Although they may not be the ones coding, it helps to have a foundational knowledge of a tool that their team may be using. Project managers may also need to manage deadlines for development tasks, in which case understanding the complexity of the task helps. This course goes through the entire scope of the app building process. Additionally, this course teaches how to resolve issues, which helps a project manager by allowing them to better understand project timelines. This course also covers the Power Apps ecosystem, which is a necessary skill for a project manager to have.
Technical Trainer
A Technical Trainer develops and delivers training programs on technical topics, such as Power Apps. Having a very deep understanding of Power Apps is required for someone in this role. This course helps to achieve this as it provides a comprehensive guide from start to finish with Power Apps. It covers all the basic to advanced concepts including data connections, canvas and model driven apps, and troubleshooting. This allows a technical trainer to create effective programs. The course not only goes through the concept, but provides instructional learning as well, which will help a trainers approach to educating others. The course emphasizes practical application building and teaches you how to resolve your own issues. Both of these things are incredibly valuable to a technical trainer.
Application Support Analyst
An Application Support Analyst provides technical support for software applications. This course is helpful because it offers a thorough learning path for Microsoft Power Apps. A support analyst might assist users with issues related to data connections, canvas and model driven apps, and other basic functionalities. The course also explores troubleshooting which helps an analyst find resolutions to various problems. This course equips an application support analyst with a strong foundational knowledge of Power Apps, enabling to solve a greater range of problems more effectively. This course is a benefit because it gives a comprehensive look at all the features of Power Apps.
Software Consultant
A Software Consultant advises clients on selecting and implementing software solutions. This course can help a consultant by providing a deep understanding of Power Apps. The course covers everything from basic to advanced topics such as setting up environments, connecting to various data sources, working with Canvas and Model-Driven apps, and resolving issues, all of which are crucial for a consultant. A Software Consultant has to understand all facets of the product before recommending it to a client. This course emphasizes building an application from beginning to end with practical application. Furthermore the course emphasizes how to resolve your own issues so that a consultant can troubleshoot common problems.
Data Engineer
A Data Engineer designs, builds, and maintains data systems and pipelines. This course teaches how to work with data using Power Apps, which can be helpful in a data engineer's workflow. This course provides a strong foundation on how to connect to various data sources, which is key for a Data Engineer. The course teaches how to build both Canvas and Model-Driven applications, which may prove useful for quickly creating user interfaces linked to databases. Although this course is not primarily focused on database architecture, understanding how Power Apps integrates with data sources strengthens the data engineer's ability to create well rounded solutions. It would be especially helpful to understand how data connections work between Power Apps and Microsoft data tools, which this course covers.
Technical Project Manager
A Technical Project Manager is responsible for managing technical projects. This role requires a foundational understanding of the technologies being used in the project. This course will help a technical project manager that is working on a Power Apps project. The course goes through the entire scope of the application development process with Power Apps. This will allow them to better manage project timelines and deadlines. The course includes data connections, canvas and model driven apps, and troubleshooting. This gives the technical project manager a broad view of the technology. The emphasis on practical, rather than academic, application building will help in understanding the complexity of project tasks. Additionally, the course emphasizes how to find solutions for errors, which helps a technical project manager by allowing them to better manage project timelines.
Database Administrator
A Database Administrator manages and maintains data systems. Understanding how applications connect to databases can be useful for this role. This course teaches how to integrate Power Apps with data sources. It specifically goes through details on Microsoft's data layer. This enables a Database Administrator to better understand how applications interface with the data. Although this is not a database focused course, familiarity with Microsoft data connections may be helpful. This course provides a comprehensive look at the entire scope of the data application process with Power Apps, which will help round out the skillset of the Database Administrator. The course also provides details on how to resolve issues, which may be helpful when troubleshooting database connections.

Reading list

We've selected one books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Power Apps - Complete Guide to Microsoft PowerApps.
This cookbook provides practical solutions and recipes for common Power Apps development challenges. It offers step-by-step guidance on building various types of apps, connecting to different data sources, and implementing advanced features. valuable resource for intermediate to advanced users looking to enhance their Power Apps skills and build more complex applications. It serves as a useful reference for troubleshooting and finding creative solutions.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser 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.

Affiliate disclosure

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.

© 2016 - 2025 OpenCourser