Get ready to learn how to build your first Canvas Power Apps with low-code knowledge, the common functions that all developers must know in Power Apps and how to share the application after construction. In this video, you'll see a start to finish lesson on building your first Power Apps.

-------------------------------------------------
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - https://share.hsforms.com/1noEXJbAlSV...

🖋️Power Apps Cheat Sheet: https://pragmaticworks.com/resources/...

Power Apps Free Course for Life - https://www.pragmaticworkstraining.co...

0:00 - Intro
3:30 - Features of Power Apps
16:40 - Types of Power Apps
28:00 - Power Apps Cheatsheet
30:25 - Community Plan
32:00 - Environments
35:11 - Licensing Power Apps
37:45 - Where to store your data
42:10 - Creating the connection to SQL Server
47:25 - Creating a Power App from Data wizard
49:50 - Saving, version control, and publishing the app
1:03:55 - Creating an app from scratch
1:06:14 - Creating the connections
1:08:10 - Creating global variables for theming
1:15:34 - Creating the app title
1:17:24 - Creating the first gallery
1:22:12 - Creating the second gallery
1:46:19 - Using Filter on the second gallery
1:53:40 - Using Search on the first gallery
1:59:06 - Creating the second screen and form
2:17:07 - Coding the Submit button to insert data
2:28:34 - Editing data in Power Apps
2:36:50 - Deleting data
2:39:26 - Final touches
2:49:45 - Q&A

To begin this example, you'll need a connection to my database in the cloud. Go to https://make.powerapps.com​. Go to Data, Connections and Create a new SQL Server Connection. Here's the info you'll need for the connection:

✔️Type: SQL Server
✔️Authentication Type: SQL Server Authentication
✔️Server: pragmaticworks.database.windows.net
✔️Database: Demo
✔️UserName: DemoUser
✔️Password: DemoPW123 (yes, it's case sensitive)
✔️Gateway: None selected

Other code we use today:
👉Variable Creation for theming:
Set(varBackgroundGreen, RGBA(232, 244, 220, 1));
Set(varHeaderGreen, RGBA(53, 91,14, 1));
Set(varCoreGreen, RGBA(78,132,22,1))

👉Assessment Gallery:
Sort(
Filter(
'[dbo].[NursingWellCheck]',
PatientID = Gallery1.Selected.PatientID
),WellCheckDate, Descending)


Overview:
Power Apps is quickly becoming a go-to low-code platform for building applications for small companies and enterprises around the world. In this interactive session, you'll learn how to design and build an application from the ground up. You'll also learn the common functions that all developers must know in Power Apps and how to share the application after construction.

What You'll Learn:
✔️ How Power Apps is licensed
✔️ Where is the best place to store your data
✔️Best practices when creating your screens
✔️ User interface tips
✔️ Using variables
✔️ The 7 key must-know functions in Power Apps
✔️ Deploying and sharing your app

If you enjoy this Learn With the Nerds and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use the code "Brian30" to get an extra 30% off at check out when purchasing our On-Demand Learning classes from https://pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/lwtn-trial

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/


Let's connect:
✔️Twitter:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.works  
✔️LinkedIn:   / pragmaticworks  
✔️YouTube:    / pragmaticworks  

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]

#powerapps, #canvas, #tutorial, #hands-on

**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.