Build Your First Canvas Power Apps Tutorial [Hands-On Course]
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 2024
- 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 - share.hsforms.com/1noEXJbAlSV...
🖋️Power Apps Cheat Sheet: pragmaticworks.com/resources/...
Power Apps Free Course for Life - 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 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-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️TH-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#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.
![Azure Synapse | Azure Synapse Analytics [Full Course] ☁️](http://i.ytimg.com/vi/lLrjaVdBuM0/mqdefault.jpg)
![Power Pages | Power Apps Portals Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/FMv-Mbmz9o4/mqdefault.jpg)
![[Full Episode] MasterChef Junior Thailand มาสเตอร์เชฟ จูเนียร์ ประเทศไทย Season 3 Episode 5](http://i.ytimg.com/vi/g5wpgeAIzMs/mqdefault.jpg)
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.
I like the way you explained and gave the why of every move. Thank you.
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, - 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!!
Thank you Sir... Learning a lot from this video... thanks again from Pakistan
great introduction! a lot of useful news defined very well!
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!
Great job Alex! Thank you for learning with us and we are so glad you liked the video!
SOOOO helpful!! thanks! really great instructing and step-by-step guide.
Glad it was helpful!
You are the best! Thank you so much for your TIME!🙏🏾
Happy to help!
This was a fantastic tutorial! Thank you very much!
You're very welcome!
Thanks Brian, best training for a beginner
Happy to help!
Bless you, sir! Helping with my project.
Glad to help
Hi Brain, Thanks for your session, it was very interesting and helpful.
great stuff. thanks
Great Intro, I started watching a few mins ago and Im already learning many things, thanks!
Glad to hear it!
Fantastic tutorial! Thanks very much
You're very welcome!
Thanks for this. I needed it.
You're so welcome!
This was amazing video and very easy way for learning. thanx
Thanks. I work for Feeding America !!!
Great content .... This is exactly what I needed ..... Thanks
Glad it was helpful! Thanks!
Great course. Thanks for sharing
Glad it was helpful!
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.
I enjoyed every bit of the video. Thanks, BK
Glad you enjoyed it
Amazing tutorial!
Thanks for watching!
You humans are life savior......
Thanks for watching!
Great tutorial! Thanks a bunch for this!
You're very welcome!
Excellent video, I'm starting a new job and needed to learn the basics of Canvas apps, your content saved me! :) Cheers!
Glad we could help!
Good job :) nice overview for beginners
I am very thankful for this session it is very informative! Kudos Brian!
Glad it was helpful!
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...
Great video ! Thanks !!!
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?
Thanks!
No problem!
Great tutorial, thank you!
Glad it was helpful!
I was also excited to be your first
Awesome
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
Nice tutorial. Very useful.
In my case, I have a Yes or No response. Assuming am to write a code to show a check icon if ts a Yes or a Cancel icon if it's a no, How do I go about this?
Great video! I kinda miss the flexibility of VBA in Access; dynamically building SQL-statements (with joins), validate against query results when entering an input field, passing variables to stored procedures and so forth. Is this something Power Apps can tackle?
Where did you pull the well Chek date from (1:25:20)? Thank you for the informative training.
Can you have the same functionality in a canvas app as you do in a model app.
One of the best online tutorials I've seen. Really well done!
Glad it was helpful!
Hi Brian: I am following the example in the amazing video above. But, I have a SharePoint list as my data set and my Assessor is a person/group data type from my organization and part of my SPO list security group. I am unable to get the name in the vertical blank Gallery. It says expected Text value. What could be the work around for it? Can you advise? Thank you for your consideration.
great
OMG that picture has me dying XD 17:30
🤣
Great video Brian but i wan't to know how you added data in sql server.
Great video ! Thank you so much.
You are welcome!
So you say you're a Fast talker?
Man I like that....
I'm about 5 minutes in and I'm thinking..."man this is best dataverse explanation Ive heard yet...
not too technical
Nice clear voice
Native English
Good pacing
5* so far
I'm heavily dyslexic and LDD
Low level schooling- and I'm getting this dude straight off the bat in the sweet spot!
Thanks for you're "ugly face " lol...
I'm doing this cause this m 365 came onto my desktop a few months ago...
We has windows 7 I think?
tried to do the Microsoft learning...
Man it's like watching paint dry.
Love the speedy delivery
Maybe that's my LDD
I Can't learn from slow talkers...
They put me to sleep
Great video guys. Can you please add timelines to the video to use as reference due to the length of the video? Thanks
Ask and ye shall receive. Thanks for the idea. I just added them.
I created a PowerApp from an existing Sharepoint List, when I want to create more screens or edit the main screen that was created from the SP List, how come the inserts i add are locked? i cant move them around or enlarge or shrink, etc? TIA
Found it under live chat thanks
WHat an awesome video, thanks very much. I will check out your playlist. Tim (Australia)
Thanks for watching Tim! Glad you enjoyed!
Great video, Brian,
Thank you! Glad you enjoyed!
Thank you verymuch for this insightfull tutorial.......This Men is the best :)
Glad it was helpful!
Nice video ❤️💚💚🥰💞🌹🌹🌹
Thank you for watching!
am doing the application and I copied the code the thing is i only see on message not on start and that why when i do run on start the color green isn't applying
Hi @PragmaticWork Do you have a tutorial on the "Contract Request" Model Driven app that is demo'd at the start of this video? Or a similar model driven app how to video ? Thanks
We do that contract request app in our bootcamp but I'm about to start a MDA series that I'll try to incorporate that into.
Great tutorial!! I'm scheduled for your App In A Day - can't wait. NOTE: at 59:50 you mention FILE SAVE, but that not an option for those who are not on Desktop version. Noticed in comments some others had the same issue. For those using the Cloud version, you have to click the Settings icon (in the white ribbon - not the one by your initials) to Save and the screen looks slightly different than in the video. I know I'm late to the game, but figure if I'm watching others probably are too. Thanks!!
Thank you pragmatic for amazing tutorial .I Built my own app but its not working smoothly. 1 )when i edit the row it is making 1 more new entry .2)when i want to add new accessor it opens in a edit mode for that patient .3) i can't see entries right away in my table on screen 1.Any suggestion please?
You'll need a form for each Edit and Insert and set their mode to their respective mode likely.
Hello Brian - I am coming in now but I am unable to access the database to follow along. Can you kindly help me out???
Nice Video, I am followin the course in 2022. Is the database still available for?
Yes, it is
"Rule #1, nobody talks about Gallery club because nobody cares!" ahhahahaha Nice!
I got delegation warning when tried to perform this search function. I used a SharePoint list as my data source that possess 500 rows of data. Is this delegation thing won't be bother if I use SQL as my data source?
is there any way we can use a button in canvas app to turn off internet or wi-fi connection in the System or PC?
Since a Power apps app runs in a browser allowing a browser to modify your computer's internet connection is a horrible idea from the security perspective.
*me with youtube already at 2x speed by default* WOW THAT GUY'S FAST
:) Ya, for this video, I knew I had to cover a lot fast so you caught me jacked up on Mountain Dew drink.
Hands to the heart, how many of you that have invested time in learning Power Apps, BI, Automate are actively developing Apps, BI, Automate for clients or own organisation?
Is there a db dump available which I can import on my instance of SQL Server to follow along with this video?
Hey Brain , how to show a form if i do not want any galley ?
You can just create a form and point it to the data source. Then make sure it's in New mode (shown in video) and no gallery required at that point.
Great instruction.
Glad you enjoyed!
The Version I am running on a Mac in Chrome there is no "Action" top tab and "Navigate" Option at 2:26:30 where can this be found in the newer version? Thanks
You'll now find it on the side bar for Power Automate. It's gone for things like Navigating so you'll just have to type the code there.
@@PragmaticWorks Thank you for the reply, very much appreciated. I used OnSelect property formula =
Navigate( Screen2, ScreenTransition.CoverRight)
Can you migrate from Sharepoint to SQL if record number goes above 5000
A lot of us read all your books!
well,none of the database is working to fill the gallery with patient names etc..
I am new to Power Apps, can I sign up for Power Apps community plan without using a work/school email address?
You can signup for your own free subscription also to create an empty tenant.
Reviewing the video again but I can’t see everyone’s comments and you had some good comments in there
Do you know how 1 can make a scored survey?
Check out my inspection video where i show you how to do that. th-cam.com/video/Kl6LqNfhGRY/w-d-xo.html
Gary Busey😜
A firewall rule is preventing me from accessing the Demo database. I tried to access the database on multiple computers, with and without VPN.
Hi George, the firewall should be wide open from Power Apps to the SQL DB. some reasons why it might fail might be a VPN connection that you might need to turn off.
Dear Brian I have actually created a presentation of your video in PowerPoint step by step can I have copyright for free use? Using my PowerApps environment and the code is exactly yours.
If it helps others in your community, go for it :)
Thank you!
Are these database credentials still valid? Will not work for me and I'd like to follow along...
They are. The biggest issue that people might do is not scroll down, be logged in with VPN or mistype something.
the database isnt opening
dont know about you guys, this first Set Color varialbe already not working for me,Set(varBackgroundGreen, RGBA(232, 244, 220, 1));Set(varHeaderGreen, RGBA(53, 91,14, 1));Set(varCoreGreen, RGBA(78,132,22,1))
Yi, that command still works. Make sure you're putting that on the App property OnStart, not StartScreen. That's where I see people generally make a mistake. -Brian
@@PragmaticWorks Thanks so much for replying, you are right, it was startscreen I put in!!!
I found that the sample sort/filter code did not work for my app:
Sort(
Filter(
'[dbo].[NursingWellCheck]',
PatientID = Gallery1.Selected.PatientID
),WellCheckDate, Descending)
I had to change it to:
Sort(
Filter(
NursingWellCheck,
PatientID = Gallery1.Selected.PatientID
),WellCheckDate, Descending)
Yes, When I originally filmed this, they used to add the schema name (dbo) on the table name. They no longer do that :). Good catch!
Delegation issue seems to have been fixed, it worked with only User().Email as a filter.
Yeah, i was super excited to see that fixed a few months ago. -Brian
hey! ThisItem.WellCheckDate and ThisItem.OverallHealthRating are not responsive and not doing anything for me :( can someone help pls