Build Your First Canvas Power Apps Tutorial [Hands-On Course]

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:

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

✔️Type: SQL Server
✔️Authentication Type: SQL Server Authentication
✔️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

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

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

[gates]

I like the way you explained and gave the why of every move. Thank you.

[ManuelBerfelde]

no fluff, no bs - just truth on often glossed over stuff like licensing and use cases for the different app types and data sources - just great videos in general here

[geofffaulkner]

This video was really the overview I needed. I have taken the "app in a day" several times and had trouble staying focused on the content and learning as it wasn't really at my level (someone who has been coding event-driven apps in VB and Access for years). This helped me understand the development process much better than the app-in-a-day class ever did.



I added a "delete confirmation dialog box" by dropping in some controls like a few labels and buttons, selected everything and grouped it all together. Then set the visibility of the group to a variable. Delete then sets that variable to true. Cancel on that sets it back to false. OK on that deletes the selected item in the gallery, and then sets it back to false. Pretty slick. Show/hide based on variable. I think I'll group the other controls and set them to disabled while the dialog box is visible, forcing the user to interact with the popup first.

[erindietrich]

Just went back to this video for a refresher. My favorite line is, "You forgot the rules of gallery club" at 2:30. Great laugh to start my day!.

[alexheer]

First video I’ve watched where I’ve actually been able to get a grasp on building a canvas app. Went away and built one based off a SharePoint list!

[Sameer-oybd]

Thank you Sir... Learning a lot from this video... thanks again from Pakistan

[leikune]

You are the best! Thank you so much for your TIME!🙏🏾

[trunks]

Hey Brian, - Thanks for 3 hours straight making this helpful video. I am a beginner with Power App and you save my afternoon with your video. Thank you so much.
From Vietnam with love!!

[hassanwaheed]

Great content .... This is exactly what I needed Thanks

[tongaitysonmadzoro]

Thanks Brian, best training for a beginner

[ketorah.developer]

This was a fantastic tutorial! Thank you very much!

[Damadedatos]

Bless you, sir! Helping with my project.

[logiman]

Incredibly helpful for a PA noob. Thank you, Brian!

[virtualburaq]

This was amazing video and very easy way for learning. thanx

[dco]

Excellent video, I'm starting a new job and needed to learn the basics of Canvas apps, your content saved me! :) Cheers!

[sathiya]

Hi Brain, Thanks for your session, it was very interesting and helpful.

[howardcallahan]

Hey Brian - Thank you for this video. I'm very new to Power Apps/Automate and I've been through, what seems like, hundreds of videos on this subject and feel like I haven't learned a darn thing. Watching your video(s), I'm learning something, finally. You are appreciated. I'm sure I'm going to have questions as time goes by. Looking forward to reviewing your video library. Will you or have you done a video like this one using Sharepoint list data?

[newmbz]

Great Intro, I started watching a few mins ago and Im already learning many things, thanks!

[DonCurrier]

I had to use ResetForm(Form1), at 2:27:52 NewForm(form1) would not reset the values to blank. if i went back into New assessment the old values would still be there. So ResetForm is what worked for me. This was a great video though. This is exactly what I needed.

[goshudegefe]

Your excellency Mr. Brian !!!- Thank you for your sweet presentation!!! showing various options how to be working with power app. I'm very new to Power App "but"" you opened my appetite just with a single presentation!!! Sir, please keep empowering the community! I'm looking for you...