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!
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.
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!!
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.
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?
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.
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
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?
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...
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
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?
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!!
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
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?
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?
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
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
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?
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
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.
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.
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
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)
![Power Automate Beginner to Pro Tutorial [Full Course]](http://i.ytimg.com/vi/1p5kI7SYz4Q/mqdefault.jpg)
![Power Automate Beginner to Pro Tutorial [Full Course]](/img/tr.png)
![Microsoft Fabric and Power BI - Developer of the Future⚡ [Full Course]](http://i.ytimg.com/vi/ohKpl80obzU/mqdefault.jpg)
![Model Driven Power Apps FULL COURSE for Beginners [UPDATED 2024 Edition]](/img/1.gif)
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!
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
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!
I like the way you explained and gave the why of every move. Thank you.
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.
Thank you Sir... Learning a lot from this video... thanks again from Pakistan
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!.
You humans are life savior......
Thanks for watching!
You are the best! Thank you so much for your TIME!🙏🏾
Happy to help!
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!!
This was amazing video and very easy way for learning. thanx
Thanks Brian, best training for a beginner
Happy to help!
Great content .... This is exactly what I needed ..... Thanks
Glad it was helpful! Thanks!
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.
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!
Thanks. I work for Feeding America !!!
Hi Brain, Thanks for your session, it was very interesting and helpful.
I was also excited to be your first
Great course. Thanks for sharing
Glad it was helpful!
I enjoyed every bit of the video. Thanks, BK
Glad you enjoyed it
This was a fantastic tutorial! Thank you very much!
You're very welcome!
Incredibly helpful for a PA noob. Thank you, Brian!
Bless you, sir! Helping with my project.
Glad to help
Great Intro, I started watching a few mins ago and Im already learning many things, thanks!
Glad to hear it!
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?
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.
SOOOO helpful!! thanks! really great instructing and step-by-step guide.
Glad it was helpful!
Thanks for this. I needed it.
You're so welcome!
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
great introduction! a lot of useful news defined very well!
Where did you pull the well Chek date from (1:25:20)? Thank you for the informative training.
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?
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...
Amazing tutorial!
Thanks for watching!
One of the best online tutorials I've seen. Really well done!
Glad it was helpful!
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
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.
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.
Great video Brian but i wan't to know how you added data in sql server.
I am very thankful for this session it is very informative! Kudos Brian!
Glad it was helpful!
OMG that picture has me dying XD 17:30
🤣
Nice Video, I am followin the course in 2022. Is the database still available for?
Yes, it is
great stuff. thanks
Can you have the same functionality in a canvas app as you do in a model app.
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!!
Great tutorial, thank you!
Glad it was helpful!
WHat an awesome video, thanks very much. I will check out your playlist. Tim (Australia)
Thanks for watching Tim! Glad you enjoyed!
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
Great tutorial! Thanks a bunch for this!
You're very welcome!
Thank you verymuch for this insightfull tutorial.......This Men is the best :)
Glad it was helpful!
Hello Brian - I am coming in now but I am unable to access the database to follow along. Can you kindly help me out???
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?
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?
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
Good job :) nice overview for beginners
Great video, Brian,
Thank you! Glad you enjoyed!
Thanks!
No problem!
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 video ! Thanks !!!
Awesome
Nice video ❤️💚💚🥰💞🌹🌹🌹
Thank you for watching!
"Rule #1, nobody talks about Gallery club because nobody cares!" ahhahahaha Nice!
Found it under live chat thanks
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?
well,none of the database is working to fill the gallery with patient names etc..
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!
A lot of us read all your books!
great
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)
*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.
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.
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!
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.
Is there a db dump available which I can import on my instance of SQL Server to follow along with this video?
Can you migrate from Sharepoint to SQL if record number goes above 5000
Do you know how 1 can make a scored survey?
Check out my inspection video where i show you how to do that. ruclips.net/video/Kl6LqNfhGRY/видео.html
Reviewing the video again but I can’t see everyone’s comments and you had some good comments in there
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!!!
Gary Busey😜
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
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
Fantastic tutorial! Thanks very much
You're very welcome!
Great video ! Thank you so much.
You are welcome!