Build Your First Canvas Power Apps Tutorial [Hands-On Course]
362,731
Published 2021-02-11
-------------------------------------------------
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - share.hsforms.com/1noEXJbAlSVuV3L-UNoU3_g8xue
🖋️Power Apps Cheat Sheet: pragmaticworks.com/resources/cheat-sheets/power-ap…
Power Apps Free Course for Life - www.pragmaticworkstraining.com/on-demand-learning-…
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 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 pragmaticworks.com/pricing/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-ent…
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: twitter.com/PragmaticWorks
✔️Facebook: www.facebook.com/pragmaticworks/
✔️Instagram: www.instagram.com/pragmatic.works
✔️LinkedIn: www.linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/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
All Comments (21)
-
I like the way you explained and gave the why of every move. Thank you.
-
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
-
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.
-
Incredibly helpful for a PA noob. Thank you, Brian!
-
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!.
-
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?
-
Thank you Sir... Learning a lot from this video... thanks again from Pakistan
-
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!!
-
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!
-
Thanks Brian, best training for a beginner
-
Great Intro, I started watching a few mins ago and Im already learning many things, thanks!
-
You are the best! Thank you so much for your TIME!🙏🏾
-
Bless you, sir! Helping with my project.
-
This was a fantastic tutorial! Thank you very much!
-
Hi Brain, Thanks for your session, it was very interesting and helpful.
-
SOOOO helpful!! thanks! really great instructing and step-by-step guide.
-
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.
-
great introduction! a lot of useful news defined very well!
-
This was amazing video and very easy way for learning. thanx
-
Thank you so much for the detailed video. It helps a lot. Can you please guide if its possible to have 2 different new items screens which can be called from 2 different buttons in the canvas app? Thanks in advance
