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

[@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

[@markjsc]

I'm very late to the party. This video was GREAT! I'm a seasoned developer of Model-driven Apps, but have never taken time to learn Canvas Apps. This video was an excellent way to learn the basics of Canvas Apps quickly. Thanks so much for your hard work to create it!

[@gates1978]

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

[@alexheer85]

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!

[@PragmaticWorks]

Great job Alex! Thank you for learning with us and we are so glad you liked the video!

[@geofffaulkner9832]

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.

[@erindietrich7458]

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

[@Sameer-oy1bd]

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

[@trunks3576]

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!!

[@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.

[@d3c40o]

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

[@PragmaticWorks]

Glad we could help!

[@zahir4215]

You humans are life savior......

[@PragmaticWorks]

Thanks for watching!

[@leikune]

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

[@PragmaticWorks]

Happy to help!

[@hassanwaheed1]

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

[@PragmaticWorks]

Glad it was helpful! Thanks!

[@tongaitysonmadzoro4097]

Thanks Brian, best training for a beginner

[@PragmaticWorks]

Happy to help!

[@bzflowerbee]

Where did you pull the well Chek date from (1:25:20)? Thank you for the informative training.

[@virtualburaq]

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

[@LeftwardElk]

Great course. Thanks for sharing

[@PragmaticWorks]

Glad it was helpful!

[@ketorah.developer4330]

This was a fantastic tutorial! Thank you very much!

[@PragmaticWorks]

You're very welcome!

[@logiman]

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

[@newmbz9585]

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

[@PragmaticWorks]

Glad to hear it!

[@Horlyrocks]

I enjoyed every bit of the video. Thanks, BK

[@PragmaticWorks]

Glad you enjoyed it

[@goshudegefe3776]

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

[@sathiya4516]

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

[@keenanlakey3161]

Thanks for this. I needed it.

[@PragmaticWorks]

You're so welcome!

[@oliverwan1520]

One of the best online tutorials I've seen. Really well done!

[@PragmaticWorks]

Glad it was helpful!

[@Damadedatos]

Bless you, sir! Helping with my project.

[@PragmaticWorks]

Glad to help

[@tigertigerp8371]

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?

[@atabiabani6076]

Amazing tutorial!

[@PragmaticWorks]

Thanks for watching!

[@sueamin2788]

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.

[@Blomiley]

SOOOO helpful!! thanks! really great instructing and step-by-step guide.

[@PragmaticWorks]

Glad it was helpful!

[@nasarazam]

Thanks. I work for Feeding America !!!

[@nodlegit3953]

I was also excited to be your first

[@ThomasBaxterSoutar]

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

[@blessingclaudio4777]

I am very thankful for this session it is very informative! Kudos Brian!

[@PragmaticWorks]

Glad it was helpful!

[@serieslimited9064]

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?

[@ogndz]

great introduction! a lot of useful news defined very well!

[@prititawade5458]

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?

[@PragmaticWorks]

You'll need a form for each Edit and Insert and set their mode to their respective mode likely.

[@frankmcleod2503]

Can you have the same functionality in a canvas app as you do in a model app.

[@HinaGeo]

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

[@stacyt.9883]

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!!

[@howardcallahan1054]

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?

[@1981toola]

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

[@PragmaticWorks]

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.

[@1981toola]

@@PragmaticWorks Thank you for the reply, very much appreciated. I used OnSelect property formula = Navigate( Screen2, ScreenTransition.CoverRight)

[@petefritz5397]

Great tutorial, thank you!

[@PragmaticWorks]

Glad it was helpful!

[@samuelmyanga1587]

Thank you verymuch for this insightfull tutorial.......This Men is the best :)

[@PragmaticWorks]

Glad it was helpful!

[@imanali8797]

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

[@peresha5531]

Great tutorial! Thanks a bunch for this!

[@PragmaticWorks]

You're very welcome!

[@RoyAliKhairan]

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?

[@VK5AV]

WHat an awesome video, thanks very much. I will check out your playlist. Tim (Australia)

[@PragmaticWorks]

Thanks for watching Tim! Glad you enjoyed!

[@leelarthaophialuang8299]

Nice Video, I am followin the course in 2022. Is the database still available for?

[@PragmaticWorks]

Yes, it is

[@JasonEala]

great stuff. thanks

[@juliemanceau1194]

Great video ! Thanks !!!

[@MikeKerul]

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

[@sagargnoolvi4896]

Great video Brian but i wan't to know how you added data in sql server.

[@natashajohnson6517]

OMG that picture has me dying XD 17:30

[@PragmaticWorks]

🤣

[@jrdtechnologies]

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

[@PragmaticWorks]

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.

[@fanyntrmny8521]

Nice video ❤️💚💚🥰💞🌹🌹🌹

[@PragmaticWorks]

Thank you for watching!

[@gregcalvert4645]

Great video guys. Can you please add timelines to the video to use as reference due to the length of the video? Thanks

[@PragmaticWorks]

Ask and ye shall receive. Thanks for the idea. I just added them.

[@jameshouchin5086]

Thanks!

[@PragmaticWorks]

No problem!

[@espendelange1995]

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?

[@kofi-tawiahagyeman]

Hello Brian - I am coming in now but I am unable to access the database to follow along. Can you kindly help me out???

[@myeonlvr]

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?

[@MetsisJ]

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.

[@ranjanroy1623]

Hey Brain , how to show a form if i do not want any galley ?

[@PragmaticWorks]

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.

[@VighneshVarma]

well,none of the database is working to fill the gallery with patient names etc..

[@dstrome]

Great video, Brian,

[@PragmaticWorks]

Thank you! Glad you enjoyed!

[@MoTheSeeker]

Good job :) nice overview for beginners

[@hi_vishy]

Awesome

[@tracywillis4118]

Found it under live chat thanks

[@ChetanSachdev]

Is there a db dump available which I can import on my instance of SQL Server to follow along with this video?

[@bradj229]

"Rule #1, nobody talks about Gallery club because nobody cares!" ahhahahaha Nice!

[@chaffee007]

Great instruction.

[@PragmaticWorks]

Glad you enjoyed!

[@BryanSeigneur0]

*me with youtube already at 2x speed by default* WOW THAT GUY'S FAST

[@PragmaticWorks]

:) Ya, for this video, I knew I had to cover a lot fast so you caught me jacked up on Mountain Dew drink.

[@fishstaku]

Do you know how 1 can make a scored survey?

[@PragmaticWorks]

Check out my inspection video where i show you how to do that. kzbin.info/www/bejne/gZ2ZfaSEm816iLs

[@frankmcleod2503]

Can you migrate from Sharepoint to SQL if record number goes above 5000

[@LuckyChubby-sv1xe]

great

[@SquillMovieMaker]

A firewall rule is preventing me from accessing the Demo database. I tried to access the database on multiple computers, with and without VPN.

[@PragmaticWorks]

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.

[@Asian_Miracle]

I am new to Power Apps, can I sign up for Power Apps community plan without using a work/school email address?

[@PragmaticWorks]

You can signup for your own free subscription also to create an empty tenant.

[@blessingclaudio4777]

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.

[@PragmaticWorks]

If it helps others in your community, go for it :)

[@blessingclaudio4777]

Thank you!

[@josephmorgan3058]

A lot of us read all your books!

[@MegaJonkelly]

Gary Busey😜

[@yimcbond7918]

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))

[@PragmaticWorks]

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

[@etang88888]

@@PragmaticWorks Thanks so much for replying, you are right, it was startscreen I put in!!!

[@tracywillis4118]

Reviewing the video again but I can’t see everyone’s comments and you had some good comments in there

[@xcruzx54]

Are these database credentials still valid? Will not work for me and I'd like to follow along...

[@PragmaticWorks]

They are. The biggest issue that people might do is not scroll down, be logged in with VPN or mistype something.

[@ponsydeep]

the database isnt opening

[@wildahunden]

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)

[@PragmaticWorks]

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!

[@jdchannelviewer]

Delegation issue seems to have been fixed, it worked with only User().Email as a filter.

[@PragmaticWorks]

Yeah, i was super excited to see that fixed a few months ago. -Brian

[@nidafarooq8215]

hey! ThisItem.WellCheckDate and ThisItem.OverallHealthRating are not responsive and not doing anything for me :( can someone help pls

[@craigjones1237]

Fantastic tutorial! Thanks very much

[@PragmaticWorks]

You're very welcome!

[@rozitajack7778]

Great video ! Thank you so much.

[@PragmaticWorks]

You are welcome!