Learn to build powerful and effective solutions with ease with Microsoft Power Platform. Created in partnership with the Microsoft Power Platform team, this course will introduce you to efficient low-code solutions for data analytics, app development, and artificial intelligence. In this course, you’ll learn how to build a fully functional Android or iOS app with Power Apps. You’ll learn to build an app with a compelling user interface, use a datastore to implement app functionality, and create a workflow with Power Automate, and implement Azure AI Builder.

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 PowerApps as Microsoft Word, but instead of building documents you are building real-life applications.

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 PowerApps. 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, there’s something for you in this course.

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

Why Learn PowerApps?

• Create impact fast – PowerApps 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.)

Introduction – learn about PowerApps and how it fits into Microsoft’s ecosystem

Environment Setup – make a PowerApps 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

Power App Module 1 :  Introduction

• What is PowerApps?
• PowerApps Features
• Why Learn PowerApps?
• Instructor Overview
• Course Overview

Power App Module 2 : Environment Setup

• PowerApps Account
• Connecting to data – OneDrive
• Connecting to data – Google Sheets

Power App Module 3 : Power Apps Concepts

Power App Module 4 : 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

Power App Module 5 : 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 scree
• Data validation (ismatch)
• Data validation (variables)
• Connecting to multiple data sources 
• Connecting to multiple data sources 2
• Data tables
• Lookup
• Adding call functionality
• Publish your application
• Change screen order

Power App Module 6 : Expert : Canvas Apps

• Introduction
• Documentation
• User() function
• Today() and Now() functions
• Grouping elements
• Launching other services
• Cascading dropdown 1
• Cascading dropdown 2
• Delete button
• Popups for confirmations

Power App Module 7 : Expert : Common Data Service

• Introduction
• 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 view
• Creating custom forms
• Creating business rules 1
• Creating business rules 2
• Other CDS concepts

Power App Module 8 : Advanced : Canvas Apps

• Introduction
• 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

Power App Module 9 : Advanced :  Model – Driven Apps

• Introduction
• Environment setup
• Navigating the environment
• Site map
• Edit forms and views
• Applying business rules
• Site map complexities
• Introduction to business process flows
• Documentation

Power App Module 10 : Overview of PowerApps Portals

• Introduction to Portals
• Environment setup
• Database setup
• Creating a URL 1
• Creating a URL 2
• Environment layout
• Testing your changes
• Adding portal components
• Properties and columns
• Adding new pages
• Creating a list and view
• Populating the entity
• Adding portal forms
• Updating portal views
• Seeing portal websites in action
• Further reading on portals

Power App Module 11 : Reference Material

• Customers Data File
• Agents Data File
• Flooring Estimates
• Location Revenue