What is Power Apps?
PowerApps is 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.
Power Apps is a suite of apps, services, and connectors, as well as a data platform that provides a rapid development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your data stored either in the underlying data platform (Microsoft Dataverse) or in various online (One Drive, Azure, Google Drive, Amazon, Salesforce) and on-premises data sources (such as SharePoint, Microsoft 365, Dynamics 365, SQL Server, and so on).
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.
Curriculum
Introduction
What is PowerApps?
PowerApps Features
Why learn PowerApps
Course overview
Environment Setup
PowerApps account
Connecting to data – Onedrive
Connecting to data – GoogleSheets
Basic:PowerApps Concepts.
Developmet environment
Running your first application
Saving your Application
Basic functionality
Customizing
Beginner: Canavas Apps
Environment layout, views, elements and properties.
Introduction to galleries
Forms and data cards
Property assignments
Edit forms, updates, textboxes and triggers
Introduction to functions and formulas
Introduction navigation
Error checking
Run application on your phone
Intermediate: Canavas Apps
Create Canvas App from scratch, master, and documentations 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
Data tables
Lookup
Adding call functionality
Publish your application
Change screen order
Expert: Canavas Apps
Introduction
Documentation
User() fuction
Today() and Now() fuctions
Grouping elements
Launching other sevices
Cascading dropdown 1 & 2
Delete button
Popups for confirmations
Expert: Common Data Service / Dataverse
Introduction
CDS/Dateverse setup
Entities
Relationships in entities
Business rules and views
Forms, dashboards, charts, keys, and data
Creating an entity
Adding text fields
Adding calculated fields
Uploading data
Viewing the data
Creating custom views and forms
Creating business rules
Other CDS/Dataverse concepts
Advanced: Canvas Apps
Introduction
Input elements
Image elements
Combining image with pen inputs
Combining image with camera input
Combining image with upload photo input
Images in galleries
Charts and graphs
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
Create a Full App
Create an App from scratch to end as per industry’s practice
About Instructor
I am Praveen Gampa, trainer. I am specialized in SAP BW, BOE and Microsoft Power Apps, Power BI, Excel Pivot Tables, Power Pivot and Power Query
I am an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.
I have 20+ years of overall IT experience, I have been training learners on these powerful technologies for over 10+ years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
I have over 10+ years of Online, end-user training and Management Consulting experience. It brings this knowledge and skills to my training course showing Power BI users how to easily create sophisticated management reports, perform data analysis, and create amazing interactive dashboards without using any complex programming specialized tools.
I have consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Retail and Logistics industries across several countries and continents.