are you guys ready to do some even more advanced stuff with the gallery control on power apps I know I am Lou how you doing are you ready to do some some Gallery stuff today yes I am what about you Kurt always always always well I'm gonna bring up the notes here and I'm gonna show everybody where we're at in all this let me see if I can fit us all on the screen so um this is actually the third Saturday in the row right where we've been talking about some really cool Gallery stuff um so last week we did the dynamically adding of blank new row so this week we're definitely gonna what's that did we get that solved last week yeah right at the very end we finally did I it was going really long I was getting a little bummed out and we finally figured it out um so we left on a high note and I see uh people joining us there in the chat I see Patty I see Rick Rick you really should be on here as a panelist by the way and Patty you're you're also welcome to be as on as a panelist um and uh so so anyway so this week we're gonna be doing some inline editing with the gallery and uh I don't think it's going to take us long but it's something that a lot of people want to do with a gallery I mean let's just throw uh the the form to the curb shall we Kurt and Lou and maybe we'll just do all of her editing inside of a gallery you know we could people like Excel spreadsheets you know like got a little grid you know back in our day Kurt and VB6 we had something called a data grid and we set it up so people could edit that stuff um so that's what we're going to do today and I bet you that we're gonna have enough time to talk about nested Galleries and I think that might be near and dear to uh one of our favorite students Patty and uh oh also Ellie Ellie I'm expecting to see Ellie here because I know that she's working with uh nested galleries hopefully that's meaning her use case um I love all my accelerator students I I feel like I've got a a little tribe A little I don't know uh group of people that that don't live well Lou actually uh lives probably the closest to to me than anybody but you guys are my accelerator students are all over the world but I feel like you guys are sort of like my family so yeah definitely they are don't make me don't make me cry here okay so there's a couple things I want to say before we get too far off of this thing you know I it's I'm just amazed at how much the gallery uh how much interaction we've had with the gallery and how much um attention and and and popularity these Gallery uh live streams have been I just the numbers are just amazing me so that tells us that there's a lot of this is a pretty important topic that this is being used I mean really could you imagine powerups without the gallery I me L Lou could you imagine it without it oh Lou by by the way guys look look let me tell you Lou is one of our star accelerator students this this this programmer here has got an app that she started off and now she's taken it to unbelievable uh levels she's dealing with SQL Server now um she's automating a business a company's processes and doing a wonderful job on it so I I've seen I've seen her grow I've seen her program grow and I'm glad to see you in here on this live stream you have a lot to offer here so I'm excited and so back to my my first question was what do you think could you imagine galleries with or powerups without galleries Lou no no I use them in probably almost every screen I have they are almost more important than forums aren't they really I mean really you know so yeah so this is a really good topic there and I'm glad that we're spending a lot of time on this yeah so guys if you're an accelerator student come on in now what I have said in the past and I'm going to address uh what Patty said here um I just sort of take it like if you don't show your video I'm thinking to myself maybe you don't want to be on on that moment but Patty if if you if you're willing to come on and talk to us as we're building uh working on the gallery I yeah I'll bring you on uh you don't have to show your face yeah and we promise not to ask you any questions about the bouncing ball we promise people are people have been traumatized by this bouncing ball Kurt would you like to explain to our audience what what the whole bouncing ball thing is about they it's just un I can't believe it so you know I just threw this in we have a lab in the accelerator program and I said you know just as an afterthought I'm going to go ahead and put this bouncing ball in there because I really you know you guys we've talked about this before you guys have seen Karate Kid and you know Mr Miyagi and the wax on wax off and I kind of feel like that balancing ball is kind of like that you know if you can do the muscle memory and the fundamentals of of controlling a bouncing ball around the screen and make it hit the the walls and hit the sides and things and and make it respond to that well then there's a lot of control that you have in your app that you actually can do you got control over everything especially like if you're doing Dynamic placement of your of your uh controls if you're doing responsive apps that kind of stuff so important and so simple animation really is a great way of controlling your program and I've said this many times I don't want to sound like too much of a broken record but if I can't teach anybody anything else I want to teach people that you must be in control of your programs at all times don't ever luck into anything and so this makes you uh have to think outside of the box and get that done now now interesting I did this video as a hint to people that were struggling with that bouncing ball you know so anyway I like it so Lou did you ever get the bouncing ball done no I hadn't gotten that far you know me I move on to my big projects and I just keep going well and and that's something that a lot of the accelerator students bring too so you know we have Labs that teach the fundamentals but oftentimes they're bringing their own Labs into the into the thing Lou had her own lab and as as did Patty so but um yeah so I really appreciate you guys taking the time to try to do this because it re it it teaches you things you know so I'm G to try out different formats here I think five might be now I can have up to 10 panelists here on R stream but I think anything over five it doesn't show everyone but um yeah I definitely want you guys on here with us and engage with us um and it's it's one of the benefits you guys get as accelerator students so I'm going to go back to this Gallery over here and um so what we're gonna try to do here there is no try and we get to make the accelerator students Superstars superstar superstar superar so this is the gallery that we worked with last week and um now this thing is actually based on a collection there and and uh this is a little different because once we save it this is meant for like a lot of data entry and it hit save and it's going to save it to the database and then clear out the collection so if they're trying to enter thousands of Records there's no need there's no reason or need for them to see the hundreds or thousands of Records in the gallery they just want to input the stuff so this is going to be like almost like a different use case so I'm going to duplicate this screen and just sort of modify it a little bit okay I'm going to rename this to inline editing screen and guys if if powerups ever does this to you or it's it's zoomed in too much or zoomed out too much you hit control zero and it should uh give us just the right size there okay um okay before you get going too far oh you're doing it you're going there already go ahead Darren I wanted to talk about the panelist or the the comment yeah so a good project would be to make a game in power apps um and and I want to reinforce what Curt said a few moments ago there were a lot of things that I was doing we we actually had a a great Workshop yesterday um and we were doing some fancy things with Galleries and I was making things really Dynamic sized and positioned um and if it wasn't for Kurt's lab that he had back in 1998 1999 where he was teaching a level two Visual Basic class we actually wrote in Visual Basic a windows program that we could use instead of Windows Explorer and to this day we still have a Windows Explorer right a place that you can see all your drives and your files and your folders it was actually much better in my opinion than the Windows Explorer and we did all that in V Visual Basic and we dynamically created uh buttons with pictures on them to for for the different drives on your system and um I learned so much about positioning and moving stuff almost you could almost make your app really responsive without using responsive containers and stuff so that was drilled into my head back then and this is something with the bouncing ball once you do the bouncing ball there's going to be situations While You're Building business apps that you're going to be able to handle and you're sort of going to stand out if you work at a organization where there's maybe five or 10 other power apps developers they're going to be looking you cuz you could do probably almost anything if you ride a good game or two or do this bouncing ball and work through some of the examples that we do here we're trying to teach you in a way that not only you're going to be good at power apps but you could take these skills and these mindsets and these patterns and take them to other platforms languages you know exactly what do you think about that Kurt that's my that's my goal you spoke it very well I mean I almost I almost want to cry you know I mean I mean he he he was listening to me all those years ago I feel like they were listening to about every third word I said you know but sometimes I feel like I can regurgitate some of your sayings better than I think youve forgotten uh more than sometimes what I know about technology and general programming stuff yeah um but uh yeah I've got so much little I've got a little Curt on my shoulder uh over the from those years of working with you now now Rick he'd probably tell you that there's too much Kurt already but I'm gonna just tell you that you can't never get enough Curt so I'm glad there's a little Curt on your shoulder so let's go down let's go down these comments real quick Darren just to to touch base with everybody absolutely so so uh I can't really see that you know what let me try to move this so I can get to a big bigger screen well I see a lot of hellos and good mornings which I definitely appreciate guys let letting us know where you're from uh that is really cool um now somebody said treeview yeah now I don't know now I guess what we could do we could create like a tree view with uh nested galleries I think you can only have uh one nest of gallery I never tried a third level galleries G whiz he might have been referring to the might have been referring to our Explorer comment when we were talking about Explorer doing doing the tree view on the Explorer might I think we actually did have a tree view control didn't we oh yeah we did do that yeah yeah um very cool right Jeff Ross by the way I'm going to announce something for for you guys uh Jeff and I were sort of partnering we're taking the ticketing you guys remember my ticketing system course um he is taking that project and building on it and what I'm going to do is I'm going to plug plug it endorse it and Mark it and he's going to support it so guys if you really like my ticketing system course I did in in power apps how I I taught it there's over 40 hours of instruction uh it's a course that I sell but um he wanted to take it and build on to it and resell it software as a service right and um so just let us know send me an email support at nus if you want to know more about that project it's something that um uh Jeff and I are working on together so I just thought I'd mention that is uh a tree view the same as a gallery it is not so a gallery is something that repeats a record either vertically up and down or horizontally left to right okay so if I were to go up here to uh the top try to insert a control okay and I said Gallery you'll see six of them I recommend that you never use these first three they're they're trying to help you out and give you like two labels and a image in my opinion you always want to start with the blank okay so you got the vertical horizontal if you want to know more on the basic side of things with the gallery look go to my channel go to the live tab and it should be just two weeks prior and so this is really the third video in a series about the gallery we are thoroughly doing a deep dive comprehensive uh coverage of the gallery control so if you want to know more of the basics um of what the gallery is and the types here we go over that very thoroughly there and a tree view is more like um you could have branches and branches could have branches and it can go on definitely sort of like Kurt is that called a linked list yeah it represents a tree view is a tree or a binary tree it represents a linked list very cool now Patty is that Elvis I'm looking at her little picture there yes it's Elvis of course of course but Elvis is King you know it's so funny because I remember back you know you were talking about back in the 90s I was in an office and I had up on the thing but Elvis is King you know because we were talking about who's yeah that was my thing now we know that data is kinging not but not the Patty no no nope nope so what I'm G to do here I'm GNA go over to the data source let's look at what we have we have a SharePoint list called raw data and I'm going to click on these three dots called an ellipsis and I'm going to click on edit data and it's going to give me the SharePoint list where we've got this data at okay and I just want to show it to you guys so you're aware of what's in there okay now what I want to do over here um I really do like working with an inmemory collection so we uh for for many reasons which I'll be D I'll be talking more about here in the next few minutes so what we do here we do a clear collect on on this button at the top now we can put that on the screen on visible so whenever we come to the screen it's going to load the data up into this collection why working with the collection is so important is that you can call a patch function tell the data source always the the first parameter of the patch function is always the data source and then the second parameter now you you think a patch function well there's three parameters well you could just give it two parameters and it will still work the second parameter could be a collection and it's going to take that data now that the schema of the data source and the collection that you're trying to patch into they should have the same schema the same design the same types okay same column names and all that um and with inline editing you might want to have the user edit five records whatever and then have a save button at the top and it will call Patch along with that collection and it will be one round trip to the server okay so when you hit that save button it's going to reach out to that data source say hey here's five records go save it and then it will come back uh my friend Matthew uh Dean says that it is 10 times faster so um and and I I it's it's very fast I I I'll just leave it at that so perhaps that is the preferred way uh of of patch if I mean if you're just trying to patch one record it's no big deal but if you have a lot of them uh it's it's great I mean it makes sense if you guys if if you guys watched last week I think it was last week we talked about the the all the different gateways and what happens every time power apps has to go into another and access a data source out there I call it the persistent data source every time you do that think about all those gateways and everything else you got to go through and and open up and close and sockets so when he says you know it's just one one trip that's just but if you're doing that for each each record in a loop you know that's every one of us is gonna be another trip you know at least one trip sometimes it's even more so just just based on that little demonstration we did a week or maybe it was two weeks ago I don't know but um that just it makes sense right just to do that collection as one thing I I got to practice that a little bit more on my own uh I I struggle because there's certain things that it does well and then there's certain things it doesn't right like we were going over that and maybe we need to do that in a live stream at some point too talk about that collection um doing it the way talking about because if you're trying to update things it works well right um if you're needing to add a new record it seems like it works well but if you're trying to delete something that's where it struggles right a little bit Yeah so absolutely uh guys if it ever seems like I'm a little distracted as as the the person running the live stream I've got things happening over here things happening over here I'm thinking what I'm going to talk about I'm thinking about how if I'm I'm following the outline if I'm not following the outline if if there you know people are sticking around and they're not sticking around so there's a lot so if it does seem I'm distracted it's because I am but I'm I'm trying my best you're saying so you're saying it's because you're bored right yes Saturday mornings are are uh yeah do these these live streams it's it's a big highlight for me in the week and Kurt says every day feels like Saturday so I know these are really important for for him um so if you guys look at what we have here we have this button and I'll probably get rid of this button and actually put this code in the uh the screens on visible so nobody has to click on a button to get the data so we've got all this raw data and you see I filtered this why did I do this Kurt why would you ever filter a data source and say false first of all what does that do if we just say false I just love this I love it I love this this code right here so false just means it's not going to get anything right if you put a filter that second parameter of your filter function is going to be an expression that's going to have to result to true for it to perform something right so it's going to perform whatever is in that true section so if you put true there it would get everything in that data source really and if you put false in there it would get nothing right so and if you put an expression in there like we're saying ID equals a specific ID well that that has to result to a true in order for it to go get that ID right so when you say false which is what you're doing here it's getting no records and you think why why would you do that but that doesn't even make any sense except for I love this and this is why I love it because before I saw this and and I always knew that you could do that but I never really saw it in practice until Darren did that once and I'm like well that's just silly you know but what was I what's the alternative you have to create a collection with that structure so you go out there and collect and get it and then you have to remove all the records out of it so so that that way you would have the structure so so this saves a lot talk about trips talk about trips to the to the server you know if you're doing a remove over and over again you know so this gets rid of that and we're just want to capture the structure so this is going to go ahead and create the structure when I say the structure that means all the fields and all the data types of those fields they're going to be in that in that collection without the data which is exactly what we want you know how to how how to initialize an empty collection with your data structures there might be a better way of doing it but I don't know it yet that's that's the slickest way I've seen so far absolutely and remember people pay big money for this and and Yan up there says the the schema that's that's right I come I come from the old days you know the data structures you know I'm a I'm a yeah but but the schema that's exactly right very cool so what I'm going to do so I change from false to true now if I were to run this hit the button okay it gives me all the data here okay I like that um what is in this field is there anything that should be in there that looks a little weird oh we put a GD in there now is it the same GD every time these two look almost identical now a GID should be unique that's that's a little weird okay so I think something was in there maybe when we first started off where it was doing two at once and maybe we fixed that bug so you guys realize if you ever have a bug in your application sometimes bugs can cause bad data and then you'll fix the bug so that your app doesn't do that but the data is still out there yeah so um yeah uh am so the reason am I I took you off just for a moment and I can sort of Shuffle you guys around here um ammer says so basically give it a false value gets the fields from the data source without any data you have a skeleton of the SharePoint data source did I get it correctly yes absolutely yeah um so the the most I can have on the screen at once is five so if you guys uh have anything to say um let me know in the private chat and I'll bring bring you on if if you're not already on um okay so we're going to do some inline editing here now what I'm going to do I want to work with all the data and I want to work with this collection and we've got this Ico new row that Ico new row I think is this thing right here if I'm not mistaken oh it has an underscore three there we go it goes over here what's in the code here okay well it's supposed to say uh notify and it creates a new record to the collection so we should have a blank row somewhere so if I scroll all the way to the bottom does it give it a new GD okay so 1702 that so that's today now the format looks a little off 1021 it does give it a new GD and I think inside of our um our text entry control I think we give it some type of a hint text if I'm not mistaken um let's actually sort this I want the the the newest data um to be at the top okay so we're going to do that um yeah let's add a sort in here and let's do a sort from uh the date so created okay that's going to be a date time and we'll say descending and let's see what we get here okay now because the new record doesn't have um anything in created yet of course it's going to be at the bottom but if we want so the the newest ones are going to be at the top so how are we going to sort this in a way so the sort function is a really simple type of of function isn't it Kurt it is um and if you want any type of complicated stuff you need to upgrade your your usage of what sort function you use you you have anything to say about that at all well I've done some research on that okay I like to hear thats like if you want to do if you want to do a sort function like if a complicated thing like if you want to do more than one field you would just do a nested sort and the nested sort should bring back the the thing now if you want to do something with with uh when you're changing the the variables on it um or you using a variable sort then that that sort by columns is going to really work um it'd be a good a good uh exam you know maybe maybe we could even actually try to put both of them up there and see what happens if we do one versus the other yeah um so if you think of like a big list of let's say employees um if if a as Kurt would say if you work for General Motors you're probably working with bigger data than than you then perhaps your Mom and Pop's ice cream shop on on the local Corner in your small town right different types of data um so if you want to sort on two columns the sort function just isn't going to cut it so if you want to sort on last name John smiths in the organization you're gonna have a lot of Smiths and you might have a lot of John Smiths so then you want to sort on the first name and then you might want to sort on the middle name you can't do that with the sort function you got to use something like sort by colums and there's all kinds and Kurt just alluded to it he says there's some Dynamic things you can do like with variables so maybe you've got a a gallery you got all these column headers at the top and when you click on a header it changes that that variable is that where you were going with that Kurt well that was one of them um okay but I was I was actually uh I I was actually contesting the the part where you I think you can get the same nest if you want to sort like last name and first name you can actually do a nested sort and make that work I think okay I I I think you can now if you want to do the the like you were saying you're wanting to uh sort by different things and you want to keep that a variable a variable uh items like like say maybe I want to do the last name maybe I want to do the address maybe I want to do the city that's where you gotta do the sort by columns absolutely now you could do the sort by comms will work either way though as far as uh sort by comms or the nested sort I think you can you know pick your poison at that point um yeah I like that I I did actually incidentally did a a a PPC video on on the the the differences with the sort and the sort by columns uh functions PPC sounds weird what's a what's a PPC yeah what is that what is and you know what Lou do you even know what PPC is so we have this we have this thing out there we' decided to do called the personal pocket coaching and it is it is pretty cool stuff so what we're doing is we're saying hey we're gonna we're going to throw a video every day in your mailbox you know a small video of some topic could be just about anything you know and um and the the cool thing about that is is that after and it's for a year right I think you do it for a year right Darren um oh yeah you could do it for a month or a year whatever but if you did this for a year you'd have 365 videos of clean concise to the point stuff so it's basically a reference you you'd be building up your reference this way and uh even even on holidays um now there they're uh what you'll see here but we'll try to do them ahead of time so we're not actually working on Christmas Eve but you see here's December we started that we actually threw in um some bonus ones if anyone wanted to see them where we covered modern controls we went into animations I mean you're G have 365 different videos of topics to to watch so if you like I mean Kurt and I we we can't you're going to ask us to talk we're going to talk between one and three hours right it's not for the faint of heart right Lou but um you know some people just need like a little bite-size a five or 10 minute video uh maybe you're sitting on the toilet maybe you're riding in a car and it's a long car ride and you can find out all kinds of little things five five to 15 minutes at a time uh people really like it I mean look at this there's the lookup function um and I'm sorry I do want to say too that sometimes if you'll might see that looks like we've gone behind we fall behind like three or four days but then we C we catch up and we get it you know week's worth ahead of time so get ahead yeah it fluctuates but it's gonna average out to a video every day and they are well worth it okay to me it's a great idea because I sometimes I just need to help with one tiny thing and I'm like oh I can just go right there and there's my this is what I need a refresher on right so so here's here's the thing you know Darren Kan Darren came to me and I don't want to digress too far off the thing because otherwise it turns into something else but I you know Darren came to me one time he says you know I've been running this YouTube channel for a long time and I'm getting lots of people in were were were these live streams and and and but I just don't feel like I'm teaching people anything I feel like they're just cutting and pacting my code you know and so that's what happens a lot of times when we're out there looking for something how to do something we go on YouTube and I call it the univers of YouTube and we go out there and we look for a solution we try to cut and paste that thing to make it work in our thing just make it work we're just trying to get by try to make work but the problem is we're not learning the fundamentals as to why you know and so the accelerator program we spent a lot I spent a lot of time talking about the why as you guys know Lou and and ammer and Patty you guys know man I I can go on and on and sometimes you're like what the will he just get to the point you know but because there's just so much information in there right so but if you want to find out how to do St you know I can't remember that that function what I just need to see that function I don't need the 45 minute Spiel on why you're doing theun function Kurt so that's what that's that's what this does it gives you that reference so there's a balance between the two because I really don't want anything to be a cut and paste type thing man because I I want people to be empowered by programming I want people to know why they're putting these things in you know why do I put that button in there why am I using this formula versus that formula yeah I want people to know I don't want people just to cut and paste oh it worked it worked for that person but it didn't work for me you know so anyway that that's why I love this PPC it's a great it's a great uh go between those two places you know yeah am ammer said uh no no Darren I don't cut and paste I learned so much from your videos thank you ammer amer's ammer is one of my favorite students and you might catch on all all of you are my favorite students I I love you all um but yeah I just while you were talking there Kurt you said you know you sometimes you talk about your references you need a good reference library back in our day we had like 12 or 20 books sitting on our on our desk about the technology we're using now we can just go to the school and type in something like lookup and look at all these materials that you can learn the lookup for you know and there's a second page here's some more your app a dbms what's up with that Kurt yeah that was one of my uh one of my my ppcs and I guess I just wanted to put to put the period and get it back to where you were at the the I had a video on that the difference between the sort by and the sort by uh columns um so that's in the PPC so I like it yeah fantastic um Rick I don't know who this Rick guy is I love you man all right man he seems like a stalker no Rick's one of my guys uh what else we got here we got uh okay let's let's and and Mark says wow that is uh slick so I think uh Mark you might might have been talking about the sort by columns yeah it's much more flexible than the regular sort um yeah Tony says confirmed a suspicion I had I think maybe I learned that and I I forgotten it but you can't do three levels of galleries so I'm hoping to eventually get to the nested galleries you can only do two um levels so that sort of keeps you from doing a tree view because a tree can just go on and on and on and break off on more and more brain is are twigs and leaves so um Daniel asks do you prefer a SharePoint list as a location for data or data verse my personal preferences neither I prefer Big Boy SQL Server now I I think it that's my opinion now probably the best data source for a Power Platform is always going to be dataverse okay because Microsoft has created and designed it for the Power Platform SharePoint on the other hand has been out for over 20 years was not designed for the Power Platform it still works great but it wasn't even designed to be a database right right it was just supposed to be something where you could do your grocery list or or have a list of tasks or whatever you know yeah yeah um you know what SharePoint is tons better than using Excel spreadsheet Kurt do you have any idea what are the amount of people that actually use SharePoint you think that's a pretty low amount of people using SharePoint in on the Power Platform for a data source yeah I've i' I've heard this at least a thousand times 70% 70% of Darren's 70% of Darren's uh businesses that he deals with use SharePoint based on a poll that he did and and I only say that because he forgets that he tells me this sometimes I remember one time I said Daren you know you realize that's about the 12th time you told me that going seile going seen all CT so great and Patty says I work miracles with my SharePoint lists and you know what I I've really grown to like SharePoint a lot more when I first started mess with SharePoint as a data source I said this is crazy you know but I I'm telling you I kind of like it it's it's okay you know why you know what the best thing about SharePoint is it's free it's free so it's already out there you know so that's what's so great no additional charge right no no right it comes along with the stuff right so it's usually out there if you have if you're a Microsoft shop you've already got it you know you don't have to worry about it and there's a lot of things you can do with it now there's some there's a lot of problems in there that you got to be careful of but if you're just wanting to do something simple a simple app that's not doing a whole lot of lot of going to the tables all the time and you ain't worried about security too much sharepoint's not bad you know but if you want to do anything slick slick you need to go to dataverse and then if you want something that's really robust and and at a corporate level you it might be good to behoove you to to go to SQL Server you know behoove you and and the cool thing I like about it the cool thing I like about power apps is it doesn't matter it doesn't matter if you're doing SharePoint or data verse or SQL Server once you have that data that data backend set up it's almost seamless when you're doing a lookup a lookup function works just as well in in in SharePoint as it does in in a SQL Server once you get everything set up right you know that's what I like about power apps it just does doesn't matter I've dealt with some C some C stuff and some net you got man for this data source you got to jump through these hoops for that data source you got to go over there to GitHub and get this firmware you got so many things you gotta deal with you don't have to do that in power apps that's what makes it so nice you know good question from Tony is there a way to send a table to a collection make edits and then patch back to say a SQL server without using a for all absolutely that's what we're going to do today yeah yep that's what makes it so powerful um yeah fact Jen J said answered that seems to like a good quick bootstrap yeah good deal okay so let's get back to this now did I achieve what I wanted to do with my sort so um if I scroll up to the top and um what what I want to be able to do is edit these things and this is a label pretty much what we want to do is um make some of these and I I made these little um you know for the for the labels or the text entries to have a border to make it almost look like an Excel spreadsheet okay uh so you can do inline editing so here's the GD I'm going to take this this uh text input I'm going to copy and paste it here we go and for this one let's allow them to modify Now the default is quidd my GD okay and let's look at let's only look at the rows that actually have some GD data okay well this should be easy if we go look at our data that brings it in instead of saying true let's go look at my GD and um we could do not is blank okay now I used the bang operator and now we've got a delegation issue everyone has left me guys look at this look at this Kurt's gone Lou's gone I don't see Patty does anybody love me I'm still here I feel okay I'm keeping you on Patty okay okay came back there she goes I'm taking Kurt off I was still listening okay I got I got a bam in issues here um okay so U I'm not serious of course I'm just trying to have fun um Rick still loves me well why aren't you on here as the panelist Rick I don't know um so uh Rick I I I sort of need you to have a backup dad joke for me um there are times when I do need a good dad joke by the way guys I keep all my dad jokes in a dad a base oh you've already heard that one okay so we got a bang operator to say not now what if I say not here I still have a delegation problem okay so sometimes I do things like why' you do it that way Darren why don't don't you do the is Blink you know um so if I left it as this look I've got a delegation problem well what if we do a length does that get rid of the issue and we'll say over zero okay um that's not helping us out so how can we write this so we have no delegation issues at all um any ideas guys um one [Music] thing what about a starts with we do a starts with and then say something like empty string that still might give us everything so let's just try this out okay icon just selected okay um so it added that new record at the bottom now if we look at at this open up this collection see what we what we got back here I forgive you Kurt for leaving me I I saw the delegation and I had to leave delegation issue I couldn't stand it I do see uh Joshua on here welcome Josh um okay so do we have any rose with blank gids and we do okay so Kurt I'm sort of wrestling with our with how we get the data okay I only want data where there is a GD in the field my GD and I started doing the starts with and um well it still gave me everything because even a GD starts with empty string right then it's got some characters right after the empty string yeah so I'm trying to figure out how to bring back stuff that actually has gids without having a delegation problem do you have any suggestions for me here and you couldn't use not inside your filter and it didn't work what about not well we get a we get a delegation issue with the not so for example if I said um is would you say is blank and then say not you could y now if could you say could you say is blank no no see we got that um that the delegation issue on that because in order to apply that bang operator it's got to go get all the data so it can actually do that what about the length can we test the length equal greater Zer delegation on that too yeah so if I say length is greater than zero I'm sure it will work but again we have delegation issues okay so we got delegation there we go Jan's got it boom okay let's do this I love it when a plan comes together uh uh oh still delegating yeah is blank is not delegable um so Jan I'm I'm saying my GD is other than an empty string now these delegation issues they can be different from data source to data source and we are in fact using SharePoint which most people use anyway okay so that doesn't seem like it's going to work either now the other the other situation is is if you're if if you're sure you're not going to go through that 2000 limit then you really don't care right so if you're doing an inline editing table how are How likely are you to do that that's the other question um that's true yeah sometimes you ask you a question like what's the practicality of this are we working with more than 2,000 that type of thing uh my bet you should use equals well that would give me the records that I don't want so if I said not then it's going to give me the um says incompatible incompatible types Boolean okay so if I were to do something like this again we have the delegation okay and I didn't necessarily want to make this video All About delegation but these are the things that you encounter as you're building apps right okay so then there's there's a perhaps there's another thing you could do where you I don't know so now I'm tempted to go into doing some ad columns and having a having a billion variable over there whether or not it's been um input or not whether or not something's now I don't know if that's going to encounter that trying to load that in but if you do an ad columns and have a bullion set somewhere in your flag so you could have a load maybe you could have a a a a a loading a load field to says if this is true load it in you know so so set that up in your filter yeah so in order to so we'll we could use add columns we'll have a column there we can do our own expression by which we can filter by but won't it need to get at all the records to to actually populate that column to know if we want to filter it further I believe the answer is yes can you use first Daren I'm sure we could uh the first function will just give us the first record though the first record the answer I got the answer Darren what you got Kurt load the whole thing load the whole thing into a collection and filter The Collection well this is a collection but you're but you got you're you're taking it from raw data so load load load raw data all of raw data into a collection and then filter that collection so in other words do all of your access from that so that way you beat your delegation to load it all in a memory right y now you're not dealing with the data source right so this clear collect that's essentially what we're doing here so um now what people do with delegation sometimes I don't really like doing this but let's say we got 4,000 records and we want all of them why would you ever want to have 4,000 records to display on a screen is beyond me but maybe so you could say you look at the IDS okay give me all the all the records that have an ID less than 2,000 you might have 2,000 records or less than 2,000 maybe somewh deleted then you could say give me data from this to this you know um yeah hey Karen nice to have you on here yeah I so I guess I'm kind of hung up because we're not really doing the same thing that I'm talking about so we are loading everything into a collection but I'm saying load it into a holding collection and then do that filter from that collection okay yeah let's do that clear collect will that work that's what I want to know okay so we've got let's call it um a holding yeah collection okay and then what you want to do is you want to to do a filter like we have here no I just want to do raw data okay or not your call the actual raw data that raw data that's what I meant to do there we go oh okay there you go and then now we go in here to this clear collector we do and and you filter from call holding okay does that beat our delegation you think well we don't get any allegation warnings but if this raw data has 5,000 records it's getting truncated after after the 200,000 records right I'm I guess I'm putting here this with the assumption that we're not gonna have 2,000 but okay so oh in that case I would probably stick with this and just ignore the de delegation I thought that's what we were talking about in originally you know just to get rid of the warning but yeah you would just ignore it right yeah so um so here not GD so this should give us exactly what we want and then and um it is true I did I didn't want to make it all about delegation but that's something that I want to Circle back maybe we could have a whole session on delegation and and we delve into all different types of Delegation issues working with all the different data sources I'm going to click on this button and we're going to get some good data here okay and uh want to click on the button here and I'm going to click on Raw data I'm going to move this up a little bit and look at the data here I'm gonna have to zoom out a little bit 200 is a bit too big 150 is probably about right and I'm going to go look for the grid here uh for some reason I can't find it um I know it's in there but um yeah yeah she'll be called my GD so there it is and if I filter by that and say there's all the empty ones so we should have I'm looking for a count here you guys see a count looks like I don't know maybe 10 or 15 so that's what I'm expecting um so we get that collection there say not equals that you know what I bet is if we said is blank that might give us exactly what we're what we're looking for there okay there we go and uh what I'm going to do is I'm going to click on this icon and I don't want to see that mod that notify anymore it's annoying all right I'm G to save I'm G to run okay so now we can actually change this so I see two records here that the same one and I'm going to change this up and say XX or XY okay now when I hit the save button I wanted to save everything that has changed okay and so the save button the save button does do a for all now this is left over from we were doing something quite different last week okay so I'm going to switch this up quite a bit in fact I'm GNA rip it all out and uh what I'm going to do here the data source call Raw data so in the save I should be able to say patch raw data comma there's our collection so I am ZZ at the end I'm gonna hit oh see where it says XY there okay we need to get rid of labels and we want to make sure everything is a a text box not a label but the thing is the label's going to show us the data in the database and as we change it here we can see if it's different or not okay so this is sort of a cool thing um okay says 46a so that actually is the same but if we go in here and change it these last four and say a a a a okay what we could do this is something cool to do guys with the with the gallery to to communicate back to the user like hey you got some unsaved rows here okay so if I click on my my gallery and let's go find template fill and what we can do we have a label here called label GD one and then a txt title 2 okay look back on the gallery I'm going go and template fill and I'm going to say if uh Windows the Windows key on the keyboard V for paste and I've got everything I've got on my clipboard going back so there's my label. text if this is the same as Windows V the text box. text if those are the same then I want to treat it just like it's normal okay and it's going to be white or yellow based on if it's if it's selected now if these if those things things are different then I want to do something like um color. Peak it's not quite red it would be a little Annoying if it was pure red look at this I can go in here and just change this up AA BB now it's funny is when I moved off of it it changed last week did we do anything fancy on this on this gallery to save it automatically we were doing a lot of stuff in there messed with that so okay um let's look at we got a gallery on select and that's that's this I think when we went off the road when it changed on the on change I think we did some kind of pwor in there let's check if I remember right so we do have this guy over here so this is a title and on the unselect we did a select parent unchange o we did a patch yeah okay well I don't want to do any patches here so I'm gonna comment this code out I want this little save button at the top to take care of all that okay so let's let's see if we can fix this up a a BB uh okay okay so there is a default value here and it's looking at the underlying data I need to make sure there's nothing patching this on change on select and there's a patch there that's what's going on okay so now you can see we have three records that need to be sa saved now this button here that I'm about to click on is going to update the data source so you click on it what it's what's it doing look at how simple this code is here we have two parameters typically you've got three parameters on a patch I'm going to say hey here's the data source update that data source with this collection now what's going to happen is it's going to give SharePoint this collection hey update that what sharepoint's going to do is actually going to delegate it over and it's like hey I'm going to I'm going to update you has anything changed on this road no has anything changed yeah this has so it's not going to really update everything if it's the same it's not even try to edit it so that's sort of a cool thing so what do you guys think of that is that anybody impressed by how you're able to do that because I know um up above somebody who saying you mean we don't have to use a for all yeah right now there are there are some caveats right so if you we it seems like we went through this and I get confused in this all the time I just want to make sure I've got it clear in my head Darren well I tell you what Kurt if you're confused I I know somebody else is confused so let's let's break it down well okay so in in this case where we're just doing Simple edits that's going to work great because you're you're just basically updating what's already there but if you're adding records now adding records it seems like it handled that pretty good but if you're deleting records it's not going to handle that very well am I right on that that is true that is true so if you try to do a patch like this and let's say we we did a remove so there is no delete function within PowerUp but there is a remove which essentially deletes stuff you try to delete records out of our collection and those records are actually in the SharePoint data source and you go do the patch that is the drawback to this it's not going to because what it's doing is matching up IDs and if you delete something out of the collection it is gone out of that collection that collection doesn't keep track of oh there's a phantom one here that was deleted nope so that that's a very good point but it does handle the ads so if we added a bunch of Records in there it it would put those extra records in there right it says oh well these records weren't found in there we're going to go ahead and put them in there right it would yeah can't we can't delete so it handles ads or inserts really well and it also handles edits well okay so we got three out of the four I mean obviously we read the data in we got crud which are the four operations right yeah Kurt always told me if you can read a record write a record process a record you could work beside me so this is this is good stuff to learn guys so I I have a small question here so because I am dealing with a situation of I have a set of data and I mean you can have it on Excel uh SharePoint whatever and I actually want to put it into like my SQL Server table on another table can you do that same scenario but just not go back to the original one just or does it have to be a for all as well just to from one table to another table um Kurt did you did you under uh sometimes I'm GNA let everyone know my brain works differently sometimes I'm not understanding uh okay so if you put it all in a colle you put your raw data into a collection from your SharePoint and you actually wanted to patch then all that data to another table in SQL Server yeah okay yeah that would work doing it that way or would you have to do it for all oh it will work the schema needs to be exactly the same if the schema's different especially that primary key um that's what it uses so yeah that that could actually work just just great just make sure the scheme is the same and da and I wasy look at the comments when you were going through that Dave Savage asked will will this act the same for data verses or SQL as data sources so that kind of answered your question to that right um yeah this is a great way of like let's say you're moving from one data source to another load all your data up into a collection and a collection can go over 2000 and and boy Yan just brought up something and this goes right into our wheelhouse why we don't ever delete records Darren I don't like deleting records out of tables unless I absolutely have to okay I like to just mark them for deletion you know and then and then somewhere some down where down the road 20 years from now they can do a purge if they need to but I'm not I don't like deleting them or have a power automate flow that so we could have a column called delete me sure and it's a Boolean okay true false yes inactive and what we could do is we could do an update I like okay you want to delete these three just going to change that field to say delete me to yes you got a power automate flow that once every few moments every five minutes it's going to go out there and look for any records of that and it's just going to delete them and now on the application side on the front end you don't have to worry about it now back in the old days when they had real rdbms's not these fake ones like they got now with SQL server and all that when they had when they had dbas going on out there you had you could delete things and then you had a pack you actually had a pack statement they would actually pack your database tables with all those deletions you know all for the for the old days right all for the old days Nostalgia is a wonderful drug I remember that do you remember that Patt where you I do I do you had to make sure you packed your databases yes yes now I bet you I bet you SQL server has some kind of an equivalent a pack out there you know they probably do yeah I haven't worked on SQL server in a long time very long time so uh but yeah so that's that's exactly right so if you did a if you did that if you just marked it for deletion like let's say you got a trash can over there and in your trash can you just did a you just basically uh just Mark that set that field to to true or is deleted field to true then you could just go ahead and still do that uh that that patch the same way Darren that would work the same way as as Yan was trying to say up there he was he said it Yan originated I just made it profound that's what happened okay so Joshua said um could you set that on date time for the deleting record say two years for absolutely sure absolutely uh you want to check with your legal department and determine what is your record retention policy um and that's probably set by law and maybe your company has a policy like well we go back farther even more two years just in case the laws change you know that we're still covered you know but um good stuff so let's do some um inline editing here and I I sort of want to use a better example let's let's do some um some stuff like like I said a giz that's not very a very good use case I almost want to uh do something fresh and new um let me go find a good data source that we could use real quick here um let's see we got bookmarks we got um currency list you know what why why don't we um try to use data verse um let's see here because I feel like we we have some leftover stuff from last week that doesn't apply to this week and um I'm gonna go in here I'm gon to create an app and dare I create an app that will make everyone cringe and I think I might do it just for the cringe factor I want to keep track of all my wonderful dead jokes yeah that is a cringe Factor you're right right here we go guys get ready for some fun I used to like Dad jokes until Darren started telling us dad jokes uh and we got a rating here okay um you know what I want to do huh a rating yeah look at that I don't like the decimals in the rating because I might want to use a rating control in there and we could have like five stars I don't really want to do like half I don't know can a rating control work with like a half of a star maybe we should leave that decimal and answer that question sure you can you do have stars just check Amazon check Amazon Amazon does it yeah give me 20 more dad jokes in there let's let's see what it can do um back when I was trying to create sample data with this tool here um it would only do 20 at least at a time you just see what Rick did to us what he what he do which days are the strongest Saturday and Sunday the rest are week days oh my goodness we gonna have to add that he probably had that from his friend chatty probably gave him that one the other day I was watching one of your videos in the bad joke thing came up and I've got my headphones on Dave sitting over there and I'm like going and all a sudden I turn to him and I start telling him these and he's just like oh goodness oh goodness because he can't hear you right he goes so this is what you guys do on those on those H those group calls yeah we're learning a lot of dad jokes we're learning I especially like the toad one no no I'm sorry the frog one parallel parking what is that on the screen no no so there was one that uh I think um Kurt said the other day is like what happens when a frog parallel Parks uhuh he gets towed away oh no that wasn't me that was terrible I say good things good yeah more let's see let's see if it gives me more I thought I thought you know telling everybody that chickens can fly but they don't thought that was the good one that's my favorite one yeah because they're chicken yeah they chickens can fly they just don't because they're [Laughter] chicken all right I'm gonna create the app here so we can start having some fun with this and I want to do inline editing with you guys so we're GNA go from uh SharePoint to data verse which is essentially a SQL server with a bunch of features added on to it and then uh is it gonna give me a phone app what's going on here it's gonna be handy dandy you pull it out of your on your phone say your dad jokes pocket dad jokes Pocket Dad hold on I got I got something for you for the price of a cup of coffee a cup of coffee yeah you can you can recover a Curt from his you can recover him from his oh he's back who's got the power Darren who's got the power I got the power where did that come from that you change your your clothes real quick and put on sunglasses that was a little weird all right let's you know you know what the craziest thing about this it never gets old for him it never gets old it never gets old never gets old never gets [Music] old blank vertical Gallery sounds great dad jokes here we go here we go so what I'm going to do is I'm going to add on text pits for these we have seriously digressed here I'm I'm trying to get us back okay all right so I am going to go into H template fill and I'm Gonna Change oh no have you guys ever seen power apps do this to you before you're trying to set something and there's just grayness there I'm gonna hit save on this because it makes me feel like it's about to uh crash on me maybe so it me my it's been happening quite a bit here lately yeah Microsoft's in there just trying to tweak and fix and make things better and sometimes it feels like you're working on a alpha or a beta yes thing right um so yeah in these cases what I do is I just go back to yeah I'm going to leave and I've got hopefully dad jokes show up at the very top so we don't lose anything and by the end of this we're going to get to nested galleries so just hold on we're g we're gonna get there I just want you guys to come up with some ideas of a nest maybe we could have a gallery that says hey here's all these categories and then within that boom here's all the dad jokes for those categories what type of categories of dad jokes we have I don't know maybe could group them by the rating maybe ah there you go so that way if you wanted to I like that if you only want to see the best of the best dad jokes you start at the top and go down okay so what I'm going to do here is I'm clicked on the gallery now I'm I see this weird grayed out thing and that concerns me yet again so if I go down to template fill it's not going to allow me to do it so what you could do I got I just came up with a pretty good use case so you could have one data table being the dad jokes and another data table being judges so you can have these different judges of these dad jokes and each judge so you can have Darren Kurt Lou Patty Karen David all these people be judges and then you just and that could be going across the line and you could put numbers in you know one through five and then you could do an average of of of what the judges did and have that totaled it up at at the um on the left side and that becomes the real rating that becomes the real rating yeah let's do it that let's do it not all your ideas are good but man when when you have a good idea it's really good what so so then you could you're you're scrolling across with the different names so you could have like you know yeah names going across right absolutely there we have it I'm a little sad I think we last we we lost Amer there on the side um well so this is where where I almost need to find a different platform because I can only have five panelists on at a time and I'm always going to give priority to those that show their face because it's more engaging on a video type of Channel but um but maybe he's still here with us um okay so I'm hoping that this works now looks like it's going to work template fill okay now we can change template fill so it did it to me twice and I had to bring it up a third time isn't that funny so color. white and if I go look at the data let's go let's go oh we got space the final frontier These Are the Voyages of the Starship Enterprise okay I'm gonna go into the database tables I'm going to go find my um yeah jokes incidentally there is a space in dad jokes may or may not be good there um so we got joke and punchline so those are the two things I want to see joke this item okay do joke and I almost want to hide the punchline until it's time to reveal it I think that would be a good good thing to do for a dad joke yeah you could either do a timing on it you could do a timer on it or you could um you could do a click on it for the answer right okay click on it and have a little popup Box come up with the answer you know maybe yeah um Kurt loves his popup boxes I do love my popup boxes let's do two let's let's give it a nice great color like we have and you know what I should be doing guys I should be giving it text inputs here because we might want to maybe we find a really bad dad joke and we upgrade it make it better maybe we'll say hey chbt here's a dad joke that's really awful rewrite it to make it awesome or you could just delete it well Kurt I'm I'm I'm I'm trying to show people to do inline editing so I I I forget back to task back to task it's okay Kurt when I when I was a child growing up uh we were so poor we couldn't pay attention well you know what's funny is I started this whole thing as a child growing up and as I'm going out of life I feel like I'm a child growing up I still don't know what I want to be when I grow up and I'm almost 50 oh boy yeah hope nobody's rolling their eyes hope hopefully everybody's enjoying this people done past the rolling eye stage there a long time I'm in the same boat with you Darren totally in the same [Laughter] boat um okay so now we could theoretically change this the that could have been a good one it probably was the best one Lou um yeah so I'm going to need to do a uh a reset here we actually did this yesterday in the um in our in our Workshop what did we do yesterday in our Workshop Kurt because we're going to make that available um eventually for people if they missed out on it and still wanted to get in on that Workshop what was our topic that we did oh we did a decision tree oh that was awesome yeah and um perhaps we want to reset controls okay um so I've got this little reset icon so somebody clicks on this on the on select what I want to do is an update context okay I'll do parentheses I'll do curly brace I'm say l reset all controls and I'm going to set that to True uh a better thing to do would be just to reverse it whatever it was and we'll do the bang operator to accomplish that and I believe we've got to call we got to do it again if I'm not mistaken so if I use this little variable here I go into a control good controls will have a property called reset okay you start messing with those modern controls trying to be all popular be be with popular kids you're not going to have that property okay and I'm hoping that they they put it in there uh so this is a normal control hopefully and I go find the reset property and I set that to be that variable okay I'm going to save I'm going to run I'm going to click on this reset there we go why did the bicycle fall over so now we have a way to if we start editing it and we want to reset we just click on that and then we'll be good so what I want to do here I'm I'm going to copy and paste this text I'll put it here and I think I might want to make this a little bigger maybe how about if we made that a little Slicker Darren how would we make it slick how about if we put that little reset but button that reset button on when you start editing it put it make that thing visible on the line that you're in so that way you could just reset that line I guess you see what I'm talking you mean reset just that one is just that one line yeah you're gonna reset just that line and it would only be visible for that line right well Kurt let's do it let's do it there let's do it this is what we do all the time we always challenge it let's make this thing do this let's make it I want this thing because I don't like it to be all like cluttered if it's on every single row so a lot of times what I'll do what do I normally do Kurt well we're make we should make it only visible on that row but we should should also only make it visible if they're editing oh you're stepping it up here okay so I'm gonna say this is selected so if the record is selected um and only if we're editing it okay yeah um so we're gonna be looking for oh my goodness Kurt now you're making me like really think really hard here it's just a little bullion check right well what's going to hold the Boolean we need to add a column now don't we or a variable tell me how you would do the variable okay so you would set you would set it in the when you go into the um onselect right of of the the the text input box right well which one we could edit the question and the answer it'd be the this item oh yeah right well either one right it's either one that you want so you'd put it in both of those you'd put it in both of those you'd put a local variable in both of those right you g put a you're G to put a variable for both of them so we got two variables per row right so how am I going to create a two variables per row you you put one variable per row of this item of this item so how do I so how how would I go about that I don't know you're the I'm up here just throwing ideas I haven't thought about it yet we got to think it out here we got we gotta we can create variables we can create variables all day long but if you want a variable for every well then that we could have five rows we have 500 rows no have to create 500 or you know it's not that hard I don't think I think you just need one variable I think you just you would do it um and I agree with you it's not that hard and how I would go about doing that how I'd go about creating a a variable for each row is you're the one who got me going on with this add column thing add columns we're going to add a column to dad jokes and we're gonna say now you're really familiar with the you probably know this better because Kurt you did an amazing job with your module three on your practical labs and assignment assignments you have done amazing work on the collection module uh what is the second parameter here what how do I add column here just go ahead and put a double quote there okay and then and put some kind of column name in there and then you would hit comma and then put false because you probably want that just to be um whatever your formula is but then in this case you're just going to put false there right yeah false for now there you have it um yeah you're doing this a little bit different than I would so this is going to be this is kind of cool too I like the way I like where you're going with it yeah so what we would do so we've got two text boxes text inputs okay and both of these have an on change so how are we going to change the column for the being is edited we could probably do I don't know I know I can use a patch dad jokes we're going to patch dad jokes yeah and we're going to say edited what did I call that thing um is edited is so I wonder if it'll allow me to do that it's this this item yeah there you go oh but of course we need to do curly braces and and we set that up to be true does that work no why doesn't that work I don't know what let's see what the red squigglies tell us the specified column as being does not exist you got to probably run it first it probably doesn't see it yet right maybe yeah what I think I would like to do um I like to work with collections not the real data so what I'm going to do is I'm going to I'm G to cut that out yep and for this screen on visible I'm GNA create a dad joke collection okay so I'm G say clear collect boom and then that dad jokes and now I don't have to put little apostrophes before and after because there's a space in dad jokes right nice so we've got this there's our our data source along with our extra little column we created that's the way to do it right there there you like that yep and that's the reason why I like calling you scooter C you get her done I'm gonna click on a different screen and then I'm gonna come back to the screen and it's gonna fire that code that's GNA invoke the code okay so now we're good now for this Gallery here we're going to say C dad jokes okay now we're now we're getting there so whenever these text boxes change we are going to it's looking for the column there okay it still says it doesn't exist well because it's not in D yeah we need to be uh The Collection okay there we have it there we have it now what we do here on this guy is number one is selected and is being edited I like it you like that let's see what let's see if it works now something something I always like to do for the template fill I I like to know what select what's being edited all that type of stuff so like if absolutely um this item dot is selected is selected then we want light yellow well we have to say color. light yellow now oh come on you know I like the old intellisense and it better for navigating but I kind of like what this does the information this one gives you and I just wish they kind of combine the two that different maybe I just don't know how to use it yeah maybe I'm just not knowing how to use it right yet I'm still not used to it they they like change it on it sometimes it's a tab sometimes it's an enter to pick your whichever is selected um and every time I get mad at it I'm trying to be careful not to to complain because otherwise they're gonna mess my teams up again because Microsoft's listening to me and so they're gonna say oh you complained about us or I'm G to mess your teams up yeah your teams does not like you Kurt so guys I I went up there uh after Christmas or I was Bing on his door as a surprise Christmas day wasn't it Kurt and uh I'm like let's figure out your teams I go in there I could not figure it out I'm like well yeah because he goes he goes a noob you're such a noob you don't know anything about this stuff let me go over there and figure it out for you Kurt because I gotta do everything and then he couldn't do it he couldn't do it either there there you go all right so I'm going to make it Pink if it's being edited otherwise allow that I've got got things messed up I always got to indent things yeah oh it's got the color. white down there I I gotta I be right back I gotta check on something we have a little baby we have a little baby puppy in here and if it's would you mind bringing the puppy over here it will actually increase my my ratings of the show yeah if it's if it's quiet it's either sleeping or it's in something I gotta make sure it's not in something just like a toddler just like a toddler yes all right so you can tell that this row is selected now if I go in here and start changing it um it's not making it okay now it is pink okay there we go and then for these text boxes what I'm going to do is I'm going to find the uh Phill for this so I need to go into Phil and I'm gonna change that little one to a zero which makes it uh transparent okay here we go gonna work great for my depositing app that I've built for the my because that way they can go in and change the amount if they didn't give them that amount much they can literally change it and update it and let me know how much they've given so I like it very good okay here we go look here baby can we see her look at the baby she oh she so good yeah she's just a good girl hold on hold on I'm trying to all right I might there we go there we go that's a pretty girl she just a pretty girl yeah okay oh we're g we're gonna hide everything here there we go there we go she's so tired usually she's climbing all over me yeah she's tired oh she want's down okay camer shy camer shy right Patty I love your photo on your thing I love Elvis too oh great thank you another fan Kurt y y okay Darren s can we get onto this thing now come on I think I've watched that new movie like four times already oh I bought it what movie is that the new Elvis movie The Elvis movie oh I didn't realize that hey I saw a Tik Tok today that says um supposedly there's some guy that looks like uh like he had to go he had to fake his death in order to avoid the mob and that he's really alive and he pastors a church and he sings all the time he's a great singer I don't know I'm not saying it's true I'm just saying oh I don't know okay go the aliens took him all right so what I want to do is I want to show the answer okay so I'm going to put a button in here I think that almost looks like a a modern button but hey I'm going to go with it and I'm only gonna show this thing if this item is selected and you can double click a button and you can just type show Punch now is punch line one word or two words does anybody know I don't know we don't have our English guy major on here today yeah where's where's uh uh Jeff where we need him um yeah he abandoned us I think I'm GNA go with eight there okay I was looked to Dave because he he majored and he he did English too so okay I haven't proof readed all of my really big uh emails that I want to send out and get my point across Google says it's one word Google says it's one word okay yes now I'm gonna go in here and I'm going to take out that oh ctt's back yeah I need to find a platform where I can show everybody so I'm I'm apolog apologies uh to you Joshua you guys you guys can go ahead and uh I can I can sit off the side I don't need to stop it stop it okay stop okay so I want to do another um I want to do another add column here Kurt do I have to Nest my ad columns if I want to add another column NOP no just just do another a list just do a parameter list your next after the false you put another comma okay we're GNA go with Kurt's popup box yeah and then put and then put a put a a name a field name and then and then put a yep there you go there we go so we got show punchline okay now I need to click on a different screen and then come back and all that stuff for it to be there and then when they click on this on select I'm G to patch this the cold dad jokes I'm going to say this item and then we got brace you're gonna show it in the uh in the gallery inside the gallery is that where you're gonna show it yeah okay I mean we we could do it both ways you know um but one of the main points is to do inline stuff right in in a gallery so what we could do is well I'm going to click on this thing and then over here what I can do for the uh the default is say um punchline and then I'm going [Music] to make it visible based on this item show punch line now is that going to work it doesn't seem like it is well the label is definitely has disappeared on us um show Punch Line well what what is it right now do we have a value here um maybe I got to go off to the other screen and come back have it recreated then click on show Punch there now what do you guys think of that now if I go in here and try to add something to this if I if it loses focus it fires that change event and now we can say what reset that it reset it before you even it didn't keep the change on there yeah res set there there it went okay what do you call a fake noodle an imposta I think what I want to do is if they click on a new record let's go to on select and um what I want to do is I want to do an update if on the collection of dad jokes okay and what I want to do is if um the show columns is true then I want to update show columns no show punchline if that's true then I'm going to say show punchline false it doesn't like it where did I go wrong Kurt I'm doing an update if on the whole collection I'll hover over this update if is an unknown oh I misspelled update if yeah so it's showing in both Row one and two if I click on the third one it's gonna cover them back up what do you call a bear without any teeth a Comey bear key all right so so now okay so by the way guys if if you like the uh the the popup what do you think a container or a group how do we do a popup Kurt I I would if this was Kurt's doing this I would have just put that up in a a a popup okay so container there you go container oh I'm sorry a container yeah I said popup I'm sorry I got yeah so if I were to go in here and set let's I I sort of like the blue colors let's go with a dark blue like this but Kurt I want to Center this how am I going to Center this container here any well you could you could use the tar method grab that and drag it into what looks like about the middle of the screen and drop it there that'd be a way to center it there looks pretty centered there right Mouse click you could do that do that are you satisfied with that I mean uh for the purposes of this exercise do you want to do a formula is that what you're wanting to do what do you guys want to do is does that satisfy I'm looking at the comments guys this is a live stream do you guys wanna you want to use a t what is a tar method Kurt it's it's a scientific method it's called this that looks about right it's highly scientific Yeah okay or what we could do is we could do a userdefined function because I get tired of having to Center stuff right that sounds interesting sounds like a a PPC video actually doesn't it but yeah well let's put the answer into a label okay so the name of this Gallery is Gallery one okay and C we could still Center this with a formula um for this this label because I mean are we going to use the tar for that I'm not seeing the dotted line so maybe that that would be a good use case here um inside this I'm going to say the gallery. selected dot punch line okay we might want to have it centered horizontal horizont horizontally and vertically can we do that it's in the middle okay let's put it in the center there and we could put some good um padding in here and then if we click on this where's the click event we've got an on select okay so we could say patch a collection where the gallery do selected that's the record and we'll say show Bunch line false now does that work that doesn't even look like it's centered does it right now no doesn't in fact if we boom Oh I don't even see it let's make it a uh a tablet okay that's this is interesting if I turn it on its side see it's not centered all right I see Jan down here has got some got some good stuff right so if you want to Center that based on what you're doing right there with responsiveness you've got to you're gonna have to take your um scale to fit I think down right so that way you can you can set it and uh Center it based on the app. width yeah if you wanted to do it that way okay so um let's so we got the container here I like what we did yesterday in the workshop and we we created a user defined function and I'm sort of tempted to do that but realized that we've got like five different steps to enable it right with all these settings to enable and disable sure but um this is looking good so let's go to the X and we'll say parent dowith minus self. width divided by two but of course uh Division and multiplication happens first so you got to use parentheses to force something to go first right that's correct and let's copy that and then for the Y we're going to look at the height 50 okay now if we click on it I was EXP expecting it to [Laughter] disappear uh canvas size window size okay if I clicked on it I was hoping that it would go away so why isn't it going away if we look at the on select show Punch Line false got any ideas for me well but if you got what you got set in the unvisible property on the visible property here of this container uh for the container you got to set that don't you the visible property that's true okay so the label should always be visible true okay but the container's visible oh okay what did I H okay so here we should have Gallery 1 do selected. show punchline okay there we go I said show Punch Line why did the tomato turn red because it saw the salad dressing all right now do we feel like we've we've covered inline editing really well here uh up to this point unless you must start doing an inline editing with a with a nested Gallery as well yeah but we have done the inline editing to that point yeah pretty well I think yeah well let's go look at our data over here is there anything else that we would want to oh rating I at least want to put the rating in there right now if you're wonder I was thinking we would say that rating for the um the nested Gallery part and then it would just be an accumulation of what people put yeah you see what I'm saying yeah I like that um the um what was I thinking and does it power apps have a Stars don't they have stars for so we can actually use the uh yeah that's exactly what I want to do um okay um yeah let's do the let's do the rating thing here um I'm going to insert let's see if we can find a rating control oh look there is one I'm going to select it and we got five stars okay so let's put the rating I don't want maybe right here I'm going to select this one show the punchline here and maybe we can make this a little bigger okay now whenever they click on this on the select okay let's do a patch we're gonna patch the collection and we're GNA say this item and we're going go look at the rating rating um oh self. value how about that now we should set up the default what is the default well it should be this item do rating okay and I should be seeing these change this item. rating because look at these ratings we have decimal places let's go look at the value of that of the rating what's it holding what's it expect what's it expecting the decimals might be messing it up that's true this item. rating you know what Kurt remember when you try to go get some data try to put it into a collection data verse doesn't always or or power apps doesn't always get all the data that's correct yeah so I'm gonna click on a different screen and then I'm gonna come back and see if it actually does it now we've got we did we didn't clear collect it after you uh updated it yeah there we have it so it's not giving us part like this is 3.9 I would almost expect most of the star to be well let's go look at the control properties maybe there's there a maybe there's a property for that okay maybe there's an app for that like it maybe I don't know you know what I'd like to do in the tool tip is actually give it hey this is you see three but it's actually 3.9 so I say this item dot uh rating and I sort of I I almost don't want to show the rating here I was just doing that to troubleshoot okay right yeah so we got three out of five I hover over it and it's going to tell me uh my my cursor's in the way it's so big it does yeah cursor size K pointer size you about to say something can we go back over and look at the advanced properties of that I just kind of want to see what properties are available in that I've not really played with this before so yeah I I expect everything I do to be perfect so I don't you know need a rating system well we do have a Max we could multiply we could make it 10 10 stars and then multiply that decimal so we can but I don't know look can we look at the Advan real quick to see if there's something there that does it maybe Max no looks like it's all whole numbers only doesn't it well I should Amazon does it [Laughter] so show value well that's interesting so it's telling me that it's going to show the value oh look at that okay so it's show gonna show the value and see the second line says three out of five five I like it but it's really 3.9 it's not really showing the value is it it's not it's showing the rounded okay here's a question for you Kurt is I sort of like this let's round it I know that you know round really well here do we just say round yeah and then we say what zero decimal places yep y okay so look at this so a 3.9 becomes four I like that four becomes four 3.7 becomes four I like that let's go see a really bad joke is there anything that's close to a one all of them are either fours or fives it doesn't want to make anything anybody feel bad what do you call a bear with no teeth a Gummy [Music] Bear all right I'm gonna move this back up I feel like I feel like our panelist left us here they got tired um okay so if I click on a one here I want it to patch it now is that true yeah we do a patch now here's something Kurt like if I make make this a one I've changed that in fact if I I say boom boom some dots okay this has become edited like it needs to be updated what we need is a save icon would you say yeah why is the save icon this weird Square do you even know what that is like why why does that mean save I I don't know I was born um after that so I don't know I I wouldn't even know what that means we used to have floppy drives so you don't even know you're you're too young for that huh yeah so we should be able to patch our dad Joe oh come on dad jokes with our call dad jokes and be done with it but it just doesn't like it does it there's an error in the formula I wonder why doesn't like this cannot use a nonrecord value in this context oh you you've got you've got add columns in there right maybe yeah but are we gonna have to do a remove are we gonna have to remove stuff do a drop just do a drop columns on your patch okay so you're wanting to do drop columns and then uh drop the ones that you created that's all really yeah lose back or bring L back oh I can have S I can have more people it just makes the screen a lot [Laughter] smaller okay so let me let me see if I can or not drop you could do a hide columns I'm sorry hide columns may maybe you got to drop columns though you might have to do a drop column yeah and now I'm curious what drop columns does well it's it's gonna remove the columns okay so I I don't have to name them off I guess I do have to name them off you gotta name the ones that you want to drop yeah Okay so we've got um is edit remember what it was is being edited yeah okay you got it that there yeah SNF that one yeah to do that to do that join successfully you've got to do a drop columns in it um so that's how you learn that so okay so what's wrong with it comma yeah comma double do they have to be in um they might have you might have to put quotes in there I think maybe yep seems like it doesn't it hey looks like it's gonna work how you like that Tada all right so guys have what kind of value have you gotten have you guys learned how to do inline editing if you're getting anything helpful out of this a comment or even a like really helps the channel and that's people like you know this is a good content much appreciated what do you think I think practice that edit actually see it edit again oh you want to see it edit again I I didn't I don't know if I actually saw it save it and actually come back as the edited version let's see what it does okay so I'm going to change it here um oh you know what I need the code for this unvisible I'm GNA copy that code and put it right after this so it sort of redoes it okay so save so no it does not work oh you know why because if we drop the columns it dropped the columns all the way so what we probably need to do is have a dump those into a collection and then but we add them back right here okay could be there why doesn't that show up well the ratings are working fine I wonder if it's going to show me the punchline [Music] yeah okay this takes us into like another another thing that we need to figure out what's up with a joke um okay let's get rid of that okay so this is a text box I wonder if we were to reset it so I'm hit reset what is going on here we do is that safe huh I hope it didn't lose all of our jokes oh my goodness wouldn't that be a disaster like what what would have caused that no we got our jokes and we got 40 additional ones all right that's unfortunate but okay I'm gonna click on a different screen and comeback so that that's really weird Okay so let's um let's give this a rating of two we'll hit save oh and now it's fine okay it was it was the mic it was the the the memory problem that we were run into memory problem remember sometimes everything I'll just go blank on you okay maybe that is it want to hit uh I'm GNA click off of it and then I hit save and I'm expecting those dots to be there um okay but the question is on the change event are we patching that no we didn't we didn't update that we did not okay so we should be doing a joke and say self. text and we should probably be able to modify the uh the punch line as well this guy right here that. text and then we need um got that and then we put this one down here just in case that one is um changed got to go click on that go to on on change okay I'm going to click show Punch Line now I can go in here and let's do away right now with the um I'm gon say false okay show Punch Line we see it here so and then when I try to click in it it goes away that's interesting show Punch Line I click in you know what's going on is we are saying select parent and the there's a un select event and it's selected yeah and it it does this so what I need to do is on this button here is on the on select well we don't have a select parent there but when I clicked on this button yeah we have an on select so I'm I'm going to take that out and then we should be good what do you call a fake noodle an imposta all right so I'm gonna put some dots in here I'm G to put some dots in here of course it's gonna hide it I think that I don't want to do that anymore because if we want to show one then why hide it we've already seen it right okay what do you call Bear no teeth gummy bear but let's update it dot dot dot click here dot dot dot all right we're going to save it show it again there's the dot dot dot let's change the ating to a one star save it okay and it reloads it I go back in here show punchline there's the dot dot dot so we' have effectively completed the uh inline editing what do you guys think of that I like it like it very good good job there now there's a difference between liking like if you really really like something you say I like it Picasso I like it Picasso I like that I'm I'm gonna use it how's that sound dang now that's that's really good that is true how do you know your program is a good program guys come on somebody answer it you use it you use it well yes very very true if people are using it that's what makes a good and and guys I I've got a short message for you here it might be a minute or two but we will we'll be right back after this okay power apps has been the key ingredient for the hundreds of people that we've helped dominate in the organization with this one skill you're able to simplify processes for countless tasks like tracking leads doing inspections logging attendance booking desks in a shared office generating reports tracking employee performance and the list goes on if you have a project that you need to get done or you're an IT professional or a developer or if you plan to eventually do some freelancing work with Micosoft power apps I am literally the only person you need to accomplish your goals spreadsheets and all the old ways of doing things are becoming redundant and the people who are able to build power apps are going to accelerate the professional career so much faster than everyone else who's okay being average I have over 20 years experience as a software developer and have been working in power apps for over 3 years we have lots of course material for you but if you're eager to accelerate your expertise with power apps at a much faster pace and want to work directly with me this this is what me and my team are going to do for you number one we're going to figure out exactly what projects and skills you're working on and the overall end goal number two we're going to get clear on exactly what data sources are needed for your projects if it's a particular project with a deadline we're going to work with you to make sure that you meet that deadline and number four we're going to work with you to make sure that you master the platform so not only can you finish any project that you're currently working on but the projects that come up in the future and you might want to take those skills and become a freelancer in the future if that sounds like something that you're interested in and you want to expedite the proc process of being able to build abs that can literally be used for years and you want to be an important asset to your organization in any future companies you work for click the button below and we can have a 15minute chat about what you're needing and how we can help all right Kurt do you have any burning questions I I just want to know what everybody's gonna be watching next you know pretty much yeah for some reason YouTube thinks you're going to like this video next let's see if they're right or you can select this playlist which I've selected for you based on the content you're currently watching guys got to hurry click one of them otherwise YouTube's going to autoplay some other video
