Project Oakdale Tutorial - Building a School Achievements Power Apps Teams Solution

children get a lot of satisfaction from getting achievement points at school and in this module what i'm going to do is show you how you can build a solution will enable you to track achievements for the children in your school and also to send emails to the parents to tell them that their child has achieved something special so to that end we are going to use the common data service for teams or oakdale for teams formerly known as dataflex and we're going to do that and see how far we can go to making a cool product so just to give you an overview of the module i'm going to show you what we're going to build so effectively i'll go all the way through the building process and then i'll show you the final product then what i'm going to do is i'm going to go on to a lesson where we talk about the data model that is necessary to support what we're trying to do we're then going to build the entities that we need entities are just tables of data we're going to build the entities using teams we're then going to separately because that's our current way of doing this add image fields into one of the entities there's a little trick for that then we're going to go on to a little bit more detail on app building mechanics and we're going to build a gallery essentially a list from scratch and we're also going to build a form from scratch as well now out of the box you will get a form and a gallery but it is nice to know how to do these things yourself i'm then going to show you how to do a gallery and a form shortcut so out of the box you'll get a gallery in a form and actually you can just do a straight copy paste but it'll always look at the original entity so i'm going to show you the tricks that you need to perform to make those work and then we're going to really move things forward so that when that achievement has been raised an email will go out to the parent or guardian to say that their child's achieved something special that day finally i'm going to show you how to publish the app uh if that will have done that before the uh the email stage and and once we've done that we're just going to do a review of the solution so now we're going to do is we're going to switch over and take a look at the final solution so we're now in our team and if we move to the feedback app tab then our app will start to fire up now we can make it a bit bigger we can go like this we can do lots of things in fact we can even pop it out and i'm going to show you a couple more things if you add and hide nav bar equals true then we'll lose the purple bit and if i just go and click f11 i'm gonna go full screen if i click f5 now it's going to go full full screen so this is a teams app but i think that what i'll do is i'll still just show you um that that we can actually see this app just in its native form this is how most people are gonna see it so what i can do is i can click on add student and i can add new students in i can click a new record and type in the name i can add a picture and then pop that person's picture in and then that will create me a new record and then i can move back off there and then i can also influence the categories we've got here so i can pop a category in i can make this a new category of of um of uh over and above expectation and i can maybe say that's worth four points click submit and then if i then wanted to go into record achievements that would then become available to me i could hit the plus icon here pop the event date i can pop the student's name in and if i go novak djokovic and i go and put in over and over expectation i can do a testing demo and then click submit then what we'll see is sunday 4th of october should appear in between roger federer handwriting and participation so i'll click testing demo uh in fact so you can see that this this entry has gone in there we can actually we can see that that's gone through we've also got the ability to send an email and when we do this uh it will compose an email for us and if we click the send button it will actually send an email through to us or rather it will send an email through to the the carer of that child and it will send it from our email address as well and we can actually make changes to the email as well so this is quite a it's you know considering it takes you know took maybe about it's about two hours of work to put this together it's just not bad and and i can see lots and lots of possibilities uh as to using the powerapps teams integration for solutions that will work in lots of organizations i think the way in which it brings in images is absolutely fantastic and and and the data limitations really aren't that significant you know you've got a million rows to play with that that that for most organizations and most teams will be plenty of rows to to be successful what they're trying to do so that's the demo let's now move over and start building out this solution from scratch let's move on to the next lesson hi everyone good luck with this course i wanted to show you there's actually another way of you consuming it and that's by signing on for the course in a different way i'm just going to go through that process with you here so you need to go to powerplatformlearn.com once you're on powerplatformlearn.com then what you'll see is there are various menus just need to get the courses menu and then you can go to the powerapps cds odell for teams and then you can sign up on the course and what that does it actually splits the course up into its constituent parts so yeah it just means that you can um finish bits and then come back to it or you may can just you can just look at one specific part so that's just in the way of you consuming it anyway i hope you enjoy this content you're gonna watch it all the way through from here from now here on in good luck so i'm going to do now is describe the data model we need to support what we're going to do so the first thing is we are going to need a kind of central fact table and that's going to contain the achievements and i'm going to call it feedback because maybe maybe as well as achievements maybe if they've done something naughty that's another thing that they can that they can be informed of so we're gonna have a feedback entity now inside the feedback entity there will be relationships with i'm going to call it a people entity now it's possible that we could extend this to go beyond the beyond just the children and so this would be this could potentially have the teachers and it could even have the parents if we really wanted it to so i'm just going to make sure i've got that now what i want to do is i want to say there is going to be a relationship between the feedback and the people because there is only ever going to be one instance of a person a child within the people table but that child can have more than one element of feedback now as well as that i'm also thinking that we we might want different categories uh associated with the feedback so um we could go into the lessons and so on but i'm going to kind of keep it reasonably simple but i'm going to have i'm going to say well actually i need something like categories so it could be um it could be to do with an achievement i'm not quite sure where i'm heading with this but i think that i would rather have that than uh than have um one of these choice fields at this stage so i'm gonna say well what's the category and they could be like things like maybe achiever of the lesson or you know help the teacher i don't i don't know so i'm just going to do a little link there and we will only ever have one instance of the category and that table and we can obviously um use that category multiple times so that's that's pretty well where i'm going to head with this for the moment so we've seen the data model and in the next lesson we will use teams in order to start to build out the entities that we need so we know that we need three entities to make this solution work we need a people entity we need a feedback entity we also need a category entity so let's move over to teams in order to get those working here i am in office.com all i need to do is click on teams that will take me into teams if i don't already have a team i can join or create a team this way click on create team and then i can build a team from scratch that would be typically the way in which you would do this i'm going to assume that we've all got a team that we're involved in already at this point you would actually hit the three dots and then type in powerapps now if you don't already have the if you don't already have the icon that is showing on the left hand side so what you have to do is click on there and then what you need to do is you need to make sure that you actually pin this at the moment so i've got an option of unpinning it and the problem with that is that you can't then go and find it again so i'm going to click on there and i'm going to make sure i pin this here so now that i'm in this space i can then click on create an app because this is the best way of getting the ability to create a special database so i click on create an app and then it's going to say well hey which one do you which team do you want to add it to and at that point you then go and you choose whichever team you want to add it to now if this team doesn't already have um something set up for it then it will have to provision a database for you it takes about 10 minutes but i'm going to just click on one where the the database has already been provisioned so i'm going to go into this learn database here and i'm going to click um create now it's then going to take me off to the the build part of um a part of power ups for teams and it's going to just spin around and get things ready now at this point you get a kind of a standard screen now it is a slightly odd feeling we'll see later on how we can we can change this around but the very first thing that i'll do is i'll just give you a little walk around here i can shoot where i can show you that we're actually different things on this screen we can click on them there are these funny containers and they've got little names for the buttons and so on and we we can we're actually going to do one of these we're just going to destroy everything on the page anyway but to start with we will borrow the functionality that we've been given and what we're actually going to do is we will go to this add data element here this is the part that allows us to create new entities so you can see here that there are some tables here already what i'm going to do is i'm going to create a new table now i think what i'm going to do first is create a person table and so i think i said it was people i'll call it people um right and i will then click create on that and then what it's going to do it's going to bounce me onto a screen which allows me to add the name and various other fields that we can add in so what we're going to do is i'm going to say well i'm going to do edit column and i'm going to say that this is the full name and there is a reason for me doing this it does get a bit confusing sometimes this is the primary column for this and so i'm going to say well this is the full name and i'm going to click save on that but i am actually going to do a first name and a last name as well not amazing from a database perspective but i'm going to do it anyway first name text and and then i'll do a last name as well and this is effectively going to be the you know whether or not it's a child or not now what i am actually going to do on this i'm just going to have a little play around with this and notice there are different things that we can do now one of the things that we can do is we can have a choice field because really they can only be one of three things they can either be a student [Music] they can be a teacher uh and they can be a parent and i guess they could probably be an assistant of some kind um uh school assistant because anyone could give these things away assistant there and notice here you can change the colors if you want to not a huge amount of choice um in color colors wise but i'm gonna not worry too much about that and then that's done in fact uh cancel that i need to oh i need to give it a field name um and i'm gonna say i'm gonna say type on there i'll say person type i know it's obvious but uh well i'm going to do it anyway um so it's the person type so i'm going to say uh this is now going to create the field for us and so we'll do um the person type the person will be um let me think of someone uh famous and we can have roger federer and he can be uh so we've got roger federer and he can be one of our students and so we select the option and he's going to be a student um whereas um i don't know we'll have uh um we have pete sampras pete hold on pete sam peras and i'll say pete i'll do sampras as well sam peras and he can be a teacher i may not end up using this straight away so we'll we'll see how this um with this one shakes out and that will that's created our very first um our first entity that we needed to create now later on we will add in an image field in here it's not actually that difficult at all um so they'll just sort of fill it out a little bit and once i click x on that what it's going to do it's going to make a big change this whole area here and it's going to um it's going to it's going to associate this uh gallery that we're looking at here with people and it'll also associate this table here this this this form with people as well so there's lots of things that are happening in the background now um what i can do is there's a there's a funny label here and you need to always send it to to the back because otherwise it gets in the way of things um so we've got this we can add new records if we want to um and in fact we'll just sort of demonstrate just adding a new record we can get preview new record and uh this could be even uh and it'll be evan [Music] and make the last name landl and the person type well he can also be a teacher because he's been around for ages and i'm going to click ok on that and we can start fiddling around with this if we want to so we can we can change this where it's this time created on and we've got the person type we could add in there as well and that would be quite a kind of nice to include that and maybe we'd also change the fill property to make the the color change as well lots of fiddling around that we could do at this point i'm not going to entertain that one too much because we've got other fields that we we've got other entities that we need to create now what i'm going to do is i'm going to now move on and go on to add data again and this is going to be our feedback entity so i'm going to go create a new table and then i'm going to say feedback and notice that we've got advanced settings and this is the plural of feedback i think plural feedback would probably just still be feedback so i'm now going to click create on that and it'll take us to the same screen that we saw before and so the name um yes okay well we can have a name for the feedback but i think um i think i'm just gonna have um i'm gonna edit the column and i'm gonna say um comment uh maybe maybe that's an okay way of uh of doing this i'm going to click save on that and then i'm actually going to do a lookup column and that was why i created the person so it's going to say well hey which one do you want to look it up in and i will i created this people thing and i'm now going to call this the uh i'm going to say well actually this is this is this is definitely student feedback so i'm going to say well actually it's the student here student and i'm going to click create on that and what that will allow us to do is to pick a student now what you will notice is that we do and you we do get to actually uh we we do get to choose from the uh the teachers as well and the assistants and so on but typically you wouldn't actually be entering the data here you would actually be entering it via your app and we can control these behaviors inside the app um i'm just going to say great work um and i'm i'm actually going to sort of maybe change my mind about the it could be could be the subject maybe would be be something that we could we could use so great work um and then i'm going to click on this and i can choose between the well it can only be roger because he's my only um he's my only student strictly speaking uh and so that's great work um and it's gonna remember the date that the um the work took place so notice that i've got created on and so on but you know what maybe it's the following day that you started to do it so um so i'm going to call it a date of record um uh and now i'll call it date feedback um i'll maybe even do called date event right so what i can now do is i can then go and click on date and then i can then click create so like that means i've now got a date on which that uh if that thing took place i can then double click on that and it will give me the option to choose the date now notice that will be in a us format at this point in time we can change the behaviors in the app more easily that we can change it here so that's that's useful to us now uh i'm now going to i'm just going to come out of this and what i think we'll find on this is that um we'll come out of this everything's happy but nothing happens in the app and that's kind of clearly it's not perfect so what i'm going to do is i'm not going to worry too much about it at this point in time what i'm going to do is i'm just going to kind of plow on ahead and just say well actually what's the category um so i'm going to create a new table on this and what's the table going to be well the table let's gonna let's call it feedback category and just because we could have categories for all sorts of things so i'm going to click create on that it's going to do us a new table and what i'm now going to do is i'm going to say what's the name of it well i can say um i can say um participation i could maybe do hand writing maybe all there could be all sorts of different things that they that they could be and maybe maybe there's some kind of points that you get for each one so we'll have points uh here and then what we'll do on that is we'll actually have a number that you get for that and to um it could be that actually people say how many points they get for it it just shows you there's lots of different options so maybe handwriting is worth worth one point and um and participation is worth say three points and maybe um maybe uh helping teacher uh and maybe let's make that as three points as well and we could just we can clearly we can go on and on in terms of the different things that we can do and so what i'm going to do is i'm going to kind of hit the x on that and now what i'm going to do is i'm going to go back to the feedback and what i want to do is i want to add those feedback categories into my feedback now i'm just going to click on the the data source itself now it is a little bit tricky to get back to this data source and what i am going to make sure that i do is i'm going to save this and it's saying saving to to uh powerapps already now it's got a really rubbish name at the moment let's call it feedback app um and i'm going to click save on that now it's got actually a name that's kind of reasonable and i'm going to click on bill again i'm pretty sure that's going to take us to the right place now i'm going to um i'm actually going to click on all onto the learn piece and because that's where we did the feedback app and you can see the different tables that are inside there so just note that if you actually click on see all you actually get to see more things that are in this uh in this space here so we can see different things like apps and chat bots and flows and tables and and so on so if i click on tables you can see the three tables we've got let's hit the drop downs you can see columns and so on now what i'm going to do is i'm going to go on to the feedback and i want to edit that and i want to add another field and the field will be something that is related to i can add the relationships in here in fact i need to go into the visual editor i don't have to there are other ways of doing it but i'm going to click on the plus and what i'm going to do is i'm going to do a lookup column and it's going to be the the the category i'm just going to type in the category now then i'm going to go into the related table and it's called feedback category and then i can click create now i'm pretty sure that roger did amazing handwriting that day which means i can double click on that and i can type in handwriting there and that's gonna look okay uh and you know maybe that's that's okay for us at the moment but we can start to see it's starting to build up as an app or rather we certainly have the data structure that's going to enable us to be able to build an app and in the next lesson we're just going to enhance a little bit further and we're going to bring in an image field into our data model next to next to our people so i'll see you in the next lesson in the next lesson we're going to add a simple image field into the people entity it's a slightly more tricky process that we need to go through but it's so valuable to be able to put images into our apps that i want you to see this in operation so let's move across to teams in order to see that working so this is where we left off in the last lesson i'm going to click out of here and now what i'm going to do is remember that we were in the build part here we clicked on the correct and we correct team and now what we're going to do is we're going to go on to the people entity that we've created and what we're going to do is we are going to add an extra column in here now we sh we won't be able to add that column using the visual editor and i'll show you that working now if i hit the plus and i then uh i then hit the drop down as to the different types that we've got you'll notice that we don't actually have the option of an image field but in fact it does exist so what we're going to do is we're going to go add column here and what you'll see is that we get many more field types available to us so what i'm going to do is i'm going to add this image field here and i'm going to say what the display name is and i'm just going to call it uh i'm going to call it image i think that's enough uh i might just change the name a little bit so it's a bit more obvious in the formulas uh when we when we're working with them i think it's i think it's okay um i'll because i think what we might end up with is something like image.image so let's just call it picture instead because i don't think that will show up to the same extent i will make it the primary image but it'll be the only image as well and then i'm going to click done on that and what i need to now do is i can i have to click save table because notice that it's in in bold down here and now when it's in bold it means you can go into it you can still keep changing it i don't want to do that i want to just save the table as it is at the moment and i i'll see if i can actually go into the visual editor go into the visual editor in fact you can actually see that you've got a picture option i'm going to double click on this but actually you don't actually have the ability to edit the the picture in in here but you will get the ability to edit it and when we do the app so now what i'm going to do is going to click the x there and then what i'm going to do is i'm going to go on to the apps and then i'm going to come to my feedback app hit the three dots here and i'm going to edit that app so now it's going to fire up the app in the editing experience and what we're going to do is we're going to add our picture stroke image field and get that one uh working so that we can actually add an image of roger federer into into uh into this so notice here that we're on the app and in that field doesn't exist yet we've got to tell it to to be added so i'm going to go on to edit fields i'm going to add field and then notice i've got a number of options around picture i'm going to click the second one here and then click add on that and that's added that one in i'll click the x there and notice i've got a picture option here i'm gonna go on to the preview in fact it doesn't have a pre a picture because we know it doesn't have a picture but now that i've hit the edit i've got an option to to click to add a picture so in order to get the picture on power platform learn here i've done some resources so you need to get go to github dot com forward slash power platform learn then what you need to do is click into the resources and then on to teams and then you've got the roger federer picture you can click on the picture and then you can click download on the picture now what i'm going to do as far as as far as my involvement is concerned is i've already got the picture so i can then click click uh to add the picture and what i can do is i can head over to the folder that contains that i can go to resources and then teams and then click on roger federer and then click on it and now that has added that in so i can click ok on that and the big sell of this is now we've got that picture roger federer notice that the picture that we have here is actually a thumbnail of uh dear roger and if we don't want it to be uh to be that thumbnail then what we need to do is we need to go to the image two and we need to go to advanced and then unlock to change the properties and then it would be um instead of being parent.default it would be picture uh this item.picture dot and it should be full because full gives you um the full version of the image and that by contrast if we kind of click over to here and we're in this image one thing here what we can do is we can go this item and we can say dot picture and what that will by default do is it will give us a thumbnail a much thinner image than we had before so that's a re i mean for me this ability to add images in is a huge huge benefit and what we'll see is that when we actually start to create the the feedback we'll be able to see those images coming up over and over again thanks for watching this lesson on adding images into your team's apps in this lesson we are going to carry on creating our achievements for schools app and what we're going to do is we are going to build a simple title screen so let's move over to powerapps to do that now here we are on the app in fact what i'll do now is i'm just going to go back and i'm going to go to uh just go to home and just say hey you know if we were on this app we needed to go back and build it what we would do is we would go to build and then what we'd do is we need to make sure that we're actually on this learn particular one and you need to be in the correct team and then once you're in the correct team then you need to go on to the correct app now i'm going to click on i'll go to see all on this because i wanted to make sure that i could hit the three dots and then click edit because i wanted to edit the app so here we are we're going to fire up the app it's actually at this point in time it is just a single screen app so what we're going to do is we're going to create a title page for our app it is going to be pretty straightforward and what i've done is i have created some resources that we can work with so here we are and if i go across here to this area what we'll see is if i actually click on the hamburger i get the option for the tree view and the tree view tells me what is in my app so what that means is now it's a little bit easier to see what's happening i'm just gonna change the the zoom down the bottom here so that i can see things a bit better and what i'm going to do now is i'm going to add a new screen in fact all i'm going to do is just click new screen new screen i can do a blank screen there are different types of screens that we can do but what i'm going to do is just going to create a blank screen now notice the screen comes at the bottom now the screen that first launches within your app is the screen that is the one that is at the top so i'm going to hit the three dots here and i'm going to move it up that's now done that um and i'm just gonna go and rename it and i'm gonna call it um i normally s do scr at the start and then do scr home that's how i would normally do this and then maybe on this one here that would make it uh that would make it uh scr people just because it's actually about the people in this case now as you can see scr home has nothing inside it so what we're going to do is we're going to use some resources that i've put together just to create a really simple a really basic landing page for us so what i'm going to do is i'm going to go on to this resources area so if you go actually go to um github.com power platform learn and i'm just gonna do that now then what you'll do is you'll see lots of resources you go to the resources part then you can click on teams and then you can see there are a number of things that you can look at so what you've got is one of the things is there's a teacher classroom and it's just an image of um our uh just an image of a teacher with some students we've also got uh the logo for the power platform learn so i'm going to make use of that and that'll be it's as if it's my school logo and then what i'm also going to do is i'll just pop on the screen here this is the sort of thing i would quite often do so i would go uh and i would do insert uh i'm on powerpoint here and so new slide and i can go blank then i can get a pictures then i can get a stock images and now i can go to something like backgrounds backgrounds now i won't put this one in here but say for example i wanted some fairly bland uh background what i might choose to do is put something like this in here and i can insert this into my app but the way i'm going to do it is i'm going to right click and save as picture and in fact i will pop it in here and i'll just going to call this um app background and you'll uh you'll be able to see that when you get there grand and i'll click save on that so what i'm now going to do is i'm going to bring those things into the app so what i need to do on that is i need to go onto onto powerapps here and i am going to now navigate to go to insert and if i can type in image i don't it is image and i can drag it onto the screen there's the first thing i'm going to do then it's going to say well what image do you actually want so on the right hand side here you can see there's an option as to which image that is now this is kind of the best and easiest way of putting an image in i can do add an image file and now i can see the different things that are available to me so i'm going to say well hey i'm just going to stick the app but in fact i'll do a slightly different thing for the app background i'm going to do this teacher classroom thing and pop that one in there that's gonna be my teacher and i'm gonna expand that out it's it's an okay image i think for some reason it's not actually the best image that um i've ever seen uh i suspect that the quality of the image isn't amazing so i'm just going to sort of pop that one down a little bit and and then what i'm going to do is i'm going to click on the screen itself and then i go back onto this tree view and then i'm going to see this drop down here in fact you can see you've got an option for background image here so that means i can now i can do that in a number of ways but this is a nice place to put it because i can now add an image file then i can go to the app background then i can click open on that and then it's going to put it into there now what you'll notice is it doesn't fill the screen correctly so if i you can see there's elements here and here that are white and so what i can do is instead of making it fit i can make it fill it and then now that's going to make it fill the entire screen and i can just carry on doing that but i can add another image in and i might as well just carry on with this pop that in there and i can i can add another image in so what i'll do is i will go to insert and i will type in image and i will drag it onto the screen because this time i'm going to bring that logo in that we were looking at before so i've gone to the image and then i go add an image file and then go to power platform learn logo then click open on that and then in it goes so i think what i'll do is maybe i'll just pop it there i'm not the most amazing at design so maybe i'll also maybe pop it top right there so that's okay that's how this thing is actually gonna land at the moment you can play around with that what i'm going to do is it kind of means a title so what i'm going to do is i'm going to insert a label and i'm going to drag that onto the screen and i'm going to make it go uh i'll pop it on and i will now need to sort of do some bits and pieces with it now i quite like having um the background black and the text white it seems to kind of come across reasonably well so what i'm going to do on that is i'm going to go on to the fill property of this of the label in fact they have changed some of the ways in which these things and these things work so i will need to just go on to there now color now color uh i'll just see what happens if i go black on this because it hasn't actually said anything there so color that is actually the color of the text itself so i could i could change that but what i'm actually gonna what i wanted to do was to actually bring in um and change the background fill which doesn't appear to be an option now i suspect this is just a timing thing and in in over the course of time we will actually get that as an option um because it certainly exists in normal um in normal power apps so what i'm going to do is i'm going to say well hey if you won't let me have that then maybe they'll let me have a rectangle it does let me have a rectangle um and what i can do onto the rectangle is and go and go onto the properties i'm going to make that black then i'm going to sort of make it a bit bigger go on to the label it says color and i'm going to make it white and and just type in white there and then i'm going to pop it over but notice that the notice that it doesn't actually fit correctly or rather the the one is in front of the other so if i right click on this and reorder it and bring it to the front then you'll see that that actually appears so i'm going to sort of move this down a little bit here and and all i'm doing now is just playing around with this to see how how best to actually make this uh make this appear on the screen so i'm going to bring that back there i'm just going to right click on this and bring it to the front and bring this across here and then move this to the top right and i will now uh i'll now kind of uh fiddle around with the font size so maybe make the font size something like 40 see how that looks that's certainly starting to look better and then i can just go full screen on this and i will just bring that so the text should align into the middle it doesn't appear to want to do that so that may be just um something that's kind of localized uh as in it it may fix itself over time uh as we i can see that i've got others there's centering yeah lovely now what i can do now is i can then go on to the text which is up on the right here we can also go on to the properties here so you can see that text is a property currently it says a label and now i'm going to call it school achievements and you might want to put a button here to to make it move to the next screen in fact you definitely will and so what i'm going to do is going to drag this onto the the screen here and uh and what i'm going to do is i can play with the size and and so on i'm not going to spend too much time on that i'm just going to go into there and the text says button and i'm going to say record [Music] achievements and although we haven't actually created our ability to navigate to another screen i will now show how you can navigate to another screen so now we've only got two screens at the moment so if we go into this tree view here we've got scr home that's the screen that we're currently on and we've got scr people so what i'm going to do is i'm going to it says button type standard and what what i'm looking for is the on select property what happens when you select it so on sled what happens and i'm going to say well navigate and i typically would click on navigate and where are we going to navigate to we're going to navigate to screen people but in reality we won't we won't do that um we would we would navigate to an achievement screen which is one of the screens that we'll be developing later on so let's just go screen people and then i can close the bracket then that means that if i go on to preview and click record achievement it's going to take us off to that screen so now that we've got that screen um we probably need a back button on this in reality so what i'm going to do is i'm just gonna play with this little thing here and i'm gonna go insert now believe it or not the eye if you type in icon it won't actually find it even though an icon actually exists so i'm just gonna i have to have sort of hunt these down and in fact it just appears here in this oops in this particular area here and all you do is you click add icon and it will pop one onto the screen now i'm going to move this across to the right hand side and then what i'm going to do is i'm just going to type the word back and what it's going to do is it's going to change that icon to be a back icon now it's a bit big at the moment by reference to everything else you can you can move into different places but notice you can't actually move outside of this space so what we'll see later on is that we will build a screen that will enable us to have more control over what's happening so noticed in when we built the when we built the navigation screen the home screen we had full control over where we could put things this is a different type of screen and so consequently we can't do the same sort of things and it just reflects and some of the developments that microsoft are trying to make in this space now i've what i need to do now is for this to actually work i need to do to change the formula here and there's a nice little navigation formula it's called back and if i do back open brackets close brackets that's exactly what it will do so if i go into preview now and click back it'll take us there click record achievements click back it just bounces between the two of them what we'll also do is um what we can do is we can um we can actually add another button here in fact maybe put this across here and i'm now copying just control c and control v and what i'm actually going to do is instead of saying text it's uh i'm going to say add um and i'm going to say add student because i think that in reality that's what what you're likely to be doing add student and and then maybe we'll do add category because there is a category screen that we will be making add category so there we are and that will then take us to the different um elements of the screen now what i am going to do is i'm going to move this up here and just show you if you click all three of these and then you right click on it and click reorder in fact it's a line and then you distribute vertically it will distribute it perfectly vertically according to you know where the top item is and where the bottom item is and all this is really doing is changing the x and y properties so if you actually go down and look at the x property there you'll see it's 905. it's an odd number but you know that's the number it's at um and you know this is all we've done is we've we've automatically changed the um in fact it wasn't the x property it's actually the y property it's the y property this one is 501 and the one y property is 393 here so these things are just distributed in that way so we've made uh it took us a little bit of a while but we've actually made a landing screen for our app and what i can now do is i can save the app and then i can preview it to see that it's actually going to work nicely for me i can now click add student in fact all of these buttons go to the same place at the moment so i would click add student and then it will take me to this page and then i can just click new record and i can start to add more students into this space so as a recap for this lesson what we did was we went on to we looked at the tree view we saw the things that were where in our app we created a new screen we moved the screen up so it was the first screen that we would land on we renamed the screens then we went and got some resources that we could add in we put in some labels and buttons and images and in fact on the buttons we also we also created a navigation experience for people to make use of so you can start to see that this app is beginning to take shape so in the next lessons we are going to be developing the app further so that we can do more things with it i'll see you in the next lesson in this next lesson we are going to start building out our app into some more details so we know that in order to record our achievements we're going to need to be able to have a form to record our achievements but as well as having a form to record our achievements we also need something called a gallery because a gallery is just essentially it's a list so i'm going to start with this list and then i will then move on to creating a form that relates to the list and we'll see how we can we can do that now later on we'll actually do a shortcut version of doing this but i want you guys to understand what it is you're actually building and how you can and how simple it is in reality let's move over to powerapps to start building that here i am in teams i'm in the powerapps app if you can't see the powerapp app make sure you just type in the power and then you'll get the app but when you've got it make sure you pin it here so you can get to this space what i'm now going to do is going to head up to build then i'm going to go on to learn then i'm going to see all and i think i can actually click on the feedback app here it's going to open the app but yeah and it has actually opened the app in a fashion that allows me to continue building this is not the uh we're not working with the data at this point in time we sort of are but it's not in a in a published um state so this is going to get things ready so that we can start editing we can start to see the whole of the canvas that we've got available to us here and what i'm going to do now is i want to show you that we can now add a new screen because at the moment we've got we've got screen home we've got screen people what we need is a new screen and then that's going to be our feedback screen so i'm going to click on new screen in fact i could do a copy of this screen so i'm going to write i can go new screen i'll show you how to new screen a new screen blank it's just going to create a new screen and it's going to be completely empty but i'm going to not do that i'm going to delete that i'm actually going to duplicate the screen and just because it's going to give me some things that that are kind of helpful now as far as these buttons and pictures and so on are concerned i don't really need them so i'm just going to sort of highlight them here and i'm going to delete them but notice that this is now it's you know everything is all in place and so on i may not keep the background in here um and notice all these strange names of things you can change all those just go on to them and change them i mean as i won't be using it in a formula i'm not too fussed about it at this point in time now so the purpose of this session is we've created a screen but what we want to do is we want to create a gallery here and and later on we'll create a form so i'm going to go back onto this screen home and i'm going to call it scr achievements that's going to be our um our the screen where we do where we record all our achievements the first thing i'm going to do is i'm going to insert a gallery so this gallery is going to be on the the left hand side i think that's what i'll do and so what i need to do is click the plus here and what you've got an option for is a vertical gallery so i'm going to click on that it's going to bring that in it's going to say hey where which information do you want in here and i'm going to say well do you know what i'd quite like you to give me the feedback and what i'm going to do is i can see that the feedback has come in already now i'm just going to squeeze this up because the idea is on the right hand side you'll be able to click in there and you'll be able to see some more details so that i mean we haven't actually put very much much details in here so what i'll probably do is i'll probably add a few more a few more um students in here uh so that we can we can get this thing working now the thing to note about a gallery is when you want to interact with with that small template you need to select on the actual and the very first item in there so you can do that in one of two ways you can either click on the top one that means you're there or you can click on the pencil which means you're there as well now what i'm gonna do is you need to just keep making sure that you can see everything that's going on here so in my gallery i have this rectangle three and unhelpfully that is at the front so it's in front of everything it's not what we want so i'm going to right click on that reorder it and send it to the back and notice that it goes down to the bottom it's a bit like moving it up and down so um that's now at the back uh and notice we've got this thing called subtitle two well that's got this this item.created on and in fact i don't want created on i want the there was there was a date that i added in so date event so this is the date it all happened on and then i can go on to i've got this image uh image five here it's not using the image at the moment um but we we will probably be able to use it if we want to so um but we might need to do some trickery in order to make that work now notice that it says we've got the comment which is great and these things are linked at the moment in terms of the the the two of them are linked together but just by moving it around means they won't be linked anymore now what i want to do is i'm going to just copy and paste that and and i want to know the name of the student so i'm going to do this item dot and see what options i've got available to me and because i i i've been doing this over a period of time so i want to make sure that i need to i need to see who uh who i've got uh with which fields i've got here and as you can see i've actually got a student field here so i'm going to click on the student field now it's not actually it's a field but it represents an entire record so that means just imagine an excel spreadsheet you've got so we've we've identified one row but in order to get something out we have to click the dot and then we need to say well actually what do we need to know about that that particular person and and what we need to do is we need to do and they'll be first name i think we've got first name first name is one of the options and we can also do last name so um in fact i can do first name and undo the ampersand and do the same again and i can just type in last name so that gives me first name last name in fact i'll need to just put in uh quote space quote space ampersand and that'll give me roger space federer great work great work roger now notice the other cool thing that we can do and this is why the common data service oakdale is why it's so amazingly cool because we can get out the picture by navigating the relationship so the way in which we're going to do it is we're going to say well it's going to be this item dot student and now we need to get the image now i can't quite remember the name of the we don't want the picture id i'm just going to type in image in fact i think i called it picture so if i click on picture then it's going to go all the way through those relationships and pick out the picture that is amazing i think that's brilliant uh so we've created a gallery it doesn't really look like a gallery in all fairness because we don't have much information here so what i'm going to do is i'm going to go on to this home screen of ours i'm just going to go preview now i'm i need to um i need to click on add student because that's going to take me to my student screen and now what i want to do is i want to add a new student because it's a bit strange having um only one student so they click new record then what i can do is uh no vac um i wish i hadn't spelt uh picked a uh giorgio corvich i think that's it and that's full name anyway so last name and i'm going to get novak vich there we are and i'm going to say that that person is a student and i'm gonna go and dig out a picture so i've gone and found a picture of novak that means i can go and click on novak and click on open and then click on the save icon here he'll become a student that's available to me and and then when when i've when i've built things i can actually enter more than one one student then then i'll be able to pick novak as a student and then the gallery will start to make more sense now as my app doesn't currently do that what i've done is i've gone to across to powerapps then i've gone to build and then i'm inside learn and now i can click on the feedback table so i'm clicking on the table and then i'll have an option to allow that option to actually start using the visual editor it's going to tell me all this sort of an interesting information about the table i can go on to the visual editor because then i can actually say um i can say wonderful pictures say and then i can click the date and i can put in a different date and so this one was on the 10th i'm going to say well that's actually um on the 28th of september who was the student i'm going to go on to novak and and what what was the category um uh i'll i'll just maybe say participation was uh was the category and then i will be able to um i think that's actually saved at this point in time so that should be okay and what that means is we can go back to our app and we can now hit the back button and we can go to record achievements in fact that was that was not actually navigating correctly and so what we can do is go on to okay on there and click on the button and then we'll go on to the answer we need to go on to the on select on select and what we're going to navigate to is s oops is scr and we're going to go to scr achievements so that means now when we hit the preview uh button at the top here we've gone to preview click on to record achievements in fact that's not refreshed yet so um we might want to pop a little refresh in there so i'm just gonna i'm just gonna uh pop a little refresh on there because i know i know that that's what this is uh this is what it's needing at the moment so i'm going to go on to insert and pop in an icon and put it up there and then i'm going to change it and i think refresh oh it's reload is the option here and what is it going to do it's actually going to refresh is the command what is it going to refresh it's going to refresh the feedback and then i'm going to close the brackets and then we're all okay so now i'm going to hit the preview and i should find that if i hit the refresh then we're going to have that come through for us that's nice that's great um and but but it's it's clearly not perfect yet now as it happens um they are in the order in which in which i'd like it um i would i would typically want the most recent at the top but not everyone's different so but what we can do on here is we'd actually change that so we can actually do sort and now we've got two options sort or sort by columns i'm just going to do a basic sort and we're going to sort what we're going to sort by and i think it's called date event and how we're going to sort it we're actually going to sort it descending and that means it's all going to be in the right order as far as i'm concerned um now if we called it ascendant then we would we would see these two will actually switch around but descending is is what i need in this particular space so there we are we've got a gallery and and nothing really happens in that gallery at this point in time i am going to just change this this format in here because actually it's not it's not very helpful it's in in a us format and it's not useful to everybody so what i'm going to do is i'm going to use a little formula on here wrap it in this thing called text pop a little comment in and then you just do this weird format here and it's kind of dd uh mm yyyy now i'm going to put the quotes around it in fact that's not very good at all um and i'll click close the bracket just give you an idea of how it actually works so dd space m m space yyyy and now i'm gonna do i'm gonna change it again i'm actually gonna say well actually it's ddd so that means it's gonna be the day of the week interestingly roger got his award on a saturday and in fact you could change the month to mmm and so that now changes uh to say october it's a much more readable format for us to be able to review the information here but it just shows you that the options we've got are pretty cool in this space so as a recap of this lesson what we did was we created a gallery in fact we created a new screen and called and we renamed it as screen achievements we did it as a copy from the screen home which is why it's got the nice background and so on then what we did was we introduced using the plus on the left hand side we brought in a a gallery it was a vertical gallery we then we then associated that gallery with our feedback entity and then we also sorted it by the the date that the event took place and made it descending to make it look a bit nicer now one thing i notice on here interestingly is that my image of the image appears to have disappeared uh and so what i'm just going to go on to the is the image here this item.student.picture not quite sure why it's actually disappeared um but it has in fact it is there it's it's happy but you can actually see it's now reached all the way through those relationships in order to pull out the the uh the face of the student in this case i hope you found this lesson useful and in the next lesson what we're going to do is we're going to add in the functionality that will allow people to introduce new achievements for their students see you in the next lesson in this lesson we are going to extend our students achievements app by adding in a form that will allow a teacher to record that one of the students did well in one of the categories so let's move over to powerapps to do that so as you can see i'm in teams here what i need to do is go to build i always go from this point here because i think that's where you guys are going to start so what we need to do is we're going to need to go on to our feedback app we just click on there need to make sure you're in the correct team for continuing to develop this notice though that you can have more than one screen open so you could actually if you wanted to you could add more information whilst this was all taking place so so maybe um we could say um maybe you could say uh handwriting improvement and what we could do on that is we could then pop in a little date so we could say that actually that took place uh on the 23rd and and who was that well that was roger and it was once again it was the handwriting well i'm gonna have to do that in fact i can always change this um and not make it handwriting i can say well um participation and and i can then uh then that you can notice on the right hand side here when it is changed it just moves to saved and so let's so that's looking good now um and also on the other screen this thing has actually woken up so we're now in our app notice that it started on our home screen so if we actually click on the the tree view we can see our three screens that we've got and we've got our achievements screen here now the achievement screen has basically got um has got three items in it now because we've only just finished writing one and notice that we've got the sorting is starting to make a little bit more sense because we had roger who did great handwriting on the 23rd of september and then on at the weekend on the 3rd of october he managed to do some great work which is fantastic well done roger so what i'm going to do now is i would like to add in a form now the form is going to do two things it's going to present this information slightly differently but it's also going to enable us to edit the information so this is one to really watch closely will with because there are some really subtle things that we will be doing so the first thing i'm going to do is hit the plus here and then i'm going to go on to edit form and i'm going to drag this onto the onto the canvas here it's dragged onto the canvas wonderful i can now change the data source now that data source in this case we want it to be the feedback we don't have to be the feedback but we are going to make it the feedback so i'm going to click on this here and then what it's going to do it's going to it's going to automatically bring in certain fields but it's basically going to guess the fields so notice here that it's guessed that we want two fields day event and comment and and notice that the comment has actually got a star beside it and that's a required field and that's because it is our primary field it is a field that we must have something in but what i need to do now is i need to add some fields in if i did that a little bit quickly so i can what i need to go is the right hand side here then click on edit fields and then click on add field then what we can do is we can tell it the field that we are most interested in putting in so what i want to make sure is i want to tell it the student that i'm interested in so that one's definitely got to go in and i think there's the category we should have category in as well and now in fact it was keep jumping off so i'm just going to click on the category and go down onto student and then click add and it's going to pop those in now although it's added those in you know we can shift these things around and it's not as obvious as it might seem as to how to shift them around so what you can do is you can either drag them up and down and now i would guess that the comment would have more writing in it and so that would be yeah that would possibly be towards the bottom in fact uh and then maybe the student thing is at the top because you'd want to pick the student first but notice it's not really perfect yet and there are some features here that that are not immediately obvious to us now the first one that's not immediately obvious is we've got this thing called width fit so that means that it kind of goes and stretches across the entire screen the second thing is like well isn't it strange that that the student is there on his own um but maybe the event isn't there uh so i'm gonna i'm thinking that what i would like to do is i would like to have the student at the date event and the category in the same place so what i'm going to do is i'm going to show you how to do that so looking on this date event here is if you look on here and you go down to the y property the y property is one so effectively what we're really saying is that this bit here is is zero and this is one and notice that in terms of x and y this is zero this is 1 and this is 2. and i can show you that now it is a little bit peculiar so um just be aware of that so i've just clicked on that and if i go on to the x property you can see that the x property is two and and so typically when i'm changing these i actually go on to the actual x property because i don't like moving them up and down i'm you know maybe i'm a control freak um but if i click zero on that it's now going to move it up and what i'm also going to do is i'm going to say well actually i want this it's going to it's done another whip fit here so i'm going to say off on that and then i'm going to go on to the x property of this and it and you might find the x property for both of these is actually zero so if i go on to the x property for the bit which says student and that's also zero so it basically just puts one of them in front of the other so what i'm going to do is i'm going to say well actually um i am i think i'll put the date first that seems to make sense then the student and then what i think i'll do i think i'll actually um i would then put the category so i will uh go on to the y our option here and click zero it's going to pop it on the right hand side it has got width fit but there's nowhere left to fit this width anyway so now what i'm going to do is i'm now going to drag this down in fact i need to make this a little bit bigger here because i think the comment probably needs to be a bit bigger and i'm just going to make the box for the comment uh so that i've got more space now one thing on this that that is not immediately obvious is the comment field will only take a certain amount of information so what i'm going to do is refer back to the back to the data model so i can see how much that can actually take so i'm going to go on to powerapps and i'm just going to these tables here and i'm just going to click on the feedback and i'm going to go on to comment and when i click on comment what it's going to go do is it show me under advanced options i've got a max length here so you cannot write a comment of more than 100 uh 100 characters now we might be able to um let's just see we can we can go to 200 that's fine but what you won't be able to do i think that you may find that your maximum option here is is i think it's 400 so if i do 500 and then click done in fact you can go you can go much more than that but clearly if it's the comment field you kind of want maybe a summary and then a comment um so you can you can change how much information can go in here so i'm going to click save table so maybe the comment here maybe maybe what we think is we actually think in this case that we think that actually um 45 characters um is the most that you can um that you can do in here maybe may need to be more so i'm going to click now click save table it's going to save that table do bear in mind if you start messing around with this it might start truncating information you've already put in now i've put in some quite small amounts of information but you may find that um things get chopped off and so this is comment here and and by default it won't really let you put in more information than than than you're allowed it might do that um and watch watch what happens when we preview it because it's just gonna disappear and that's really strange now the reason for that is because we haven't told it we haven't actually said we haven't said anything to make it appear so what we need to do is we need like some kind of plus icon and i'm not going to go into a kind of beautiful user interface to make that happen i'm just going to hit a plus icon and make this thing work so what i can do is i can go onto the plus i can go add icon i'm just going to drag it across here we know we can change the formatting and in this space here and i'm going to go add if i add is perfect for me i'm just going to check if i've got a fill property and i'm going to say well actually i'm going to make the fill property um let's make it white i'm only really demonstrating this just to to show you that you can do this sort of thing now what we now need to do is we need to do the on select property so on select on select what's going to happen we'll actually unselect what is going to happen we're going to do new form which form are we going to do we've only got one form in here yeah i mean in fact there are there are two as it happens uh this one is called form one uh and in fact i'm going to call it frm frn feedback there we are so it's actually got a name now and so i'm going to go new form frm and it's frn feedback and then close the brackets that's all we needed to do so um i've got a date event student and uh category now although these are system field names you can change them so we've actually gone to advanced and then you go unlock to change properties you've now got the ability to change it and and what you can then do is you can then say um event date that's just i'm just saying look this is an option you know maybe we should have put the correct field name there in the first place i was just making sure that i had no spaces in my field name because that can cause problems so i've now changed the event date here and what i can do now is i can hit the preview now i can hit the plus icon here and now i can add something so i can now go on to here and i can say well actually when did this event take place in fact i need to go to i wanted to go up here yeah that's fine maybe it's the 8th of september and i'll do my student and that's going to be novak and i'll do the category uh helping the teacher and then do great um great uh uh i loved that apple okay and in fact one thing we haven't done we don't have a submit button here so what i'm going to do on here is i'm going to show you that you can go onto here you can go to the properties and this is a trick that you know won't be immediately obvious to you at all what we're going to do is we're going to create a submit button what we're going to do is add a field but what we need to do is we need to add in fact we don't not going to add a field we're going to add a custom card it's going to be an empty card notice that it's empty down at the bottom here so what we're going to do is notice that this one is hasn't got a width fit but i would like to have a whip fit on that and i'm going to go uh change that and then what i'm going to do is i'm going to get a button and i'm going to drag it into this space here so it's my button um and i'm just going to go on to the fill color and i'm going to make that and let's just make it a blue and there's loads of different colors that you can choose in fact and i'm going to make it light gray because i didn't really want to get caught up in in too much of this and i just want to be able to change the um the text here submit and then maybe change the size of the text because that is really quite small let's make it 40 something like that and then what we need to do is tell it what to do when you click on it so on select um what we're going to do and we're going to do servmet form and it's going to be form 1 frm feedback there we are close the brackets so now what i can do is i can go on to preview and i can now click submit and when that happens we should find that will appear in this space here and it'll actually be genuinely recorded so let's click on submit boom that went in and how cool is that that the that the image for that student came in that to me is brilliant we're going to do one more thing and the thing that we're going to do is we are going to make sure that when someone selects on the items here we're going to make it appear in this form space over here on the right hand side so what i'm going to do is i am going to uh go onto the edit and i'm going to click don't show me this again and then what i'm going to do is going to tie those things together so if i go on to there and i if i go onto the entire form so let's just make sure that we go on to there you can see i've selected the entire form now if i hit the drop down here what i'm looking for is the item it's saying hey which one do you want me to look at now the one we're going to look at is the thing that's inside this gallery and it's called gallery one at the moment so i'm going to rename it to be gal feedback just so our formula is a bit easier to read so i need to be gal feed back click enter and then what we're going to do is click on the the screen and need to get the item property now what that's going to be is it's going to be gel feedback and then it's going to we need to tell it which one we're looking at so we need to go dot selected and then close the bracket so now it's actually going to uh to look at the one that we've selected which is quite cool so i now just i can click on the different ones and i can change things around in fact not only can i change things um now we need to be a bit careful with this but let's um i'll just go on to here and do test one two three and let's just do um handwriting improvement in fact you can't see all of the text which is um which is a problem and one two three i'm gonna click submit on that it did actually change it i just wasn't sure if it was gonna was gonna do that for me um now and so we can start to see that there are there are different options here now what it could do is where it says this item.comment maybe we don't want comment maybe we want category category and it's remember category is a table and so if we look on here and we go on to tables and we go feedback category and then we go and uh we click on the options here we can get a custom um we've actually got the name and we've got the number of points so it's it's really saying which of these two fields um which of the any of the fields and do do we want to provide so if i go on to here and i'm going to say this item dot category dot and i'm going to say one name so we're now starting to see some differences in behavior uh in this particular area so we've got participation participation but we can click on it we can see more information there's lots of clever ways in which we can work this but you can see it starting to come together so this has been a busy lesson but let's do a recap of what we've done we started off we had a gallery already we created a form we put we connected the form to the fields to the to the data source which was our feedback data source we then added some fields in there we then shifted them around the place we added a custom uh a custom um a custom card in there in that custom card we put that submit button in there and then we put the we made a change to the formula on the submit button we did a little few name changes to to go uh as well and we also added this plus icon and made that get made the form uh spring into life when we actually when we clicked on there so now we're starting to get something that is kind of useful i noticed that this thing doesn't actually have a and it doesn't actually have a a back option here so on select i'm just going to pop up back option here and change this to be back and that means that we can now navigate around here and clearly this is not an amazing ui um but it it would work um well enough so that means that we can get a home we can get a preview we can get a record achievements we can go back from there go to record achievements and then we can hit the plus icon and we can start to add more things in there wow thanks for watching and i'll see you in the next lesson in this next lesson i'm going to show you a couple of ways in which we can shortcut the gallery and form creation process essentially we're going to do a copy and paste and change a few formulas around and it'll all work nicely once we're done so i'm just going to show you how we can do that let's move over to powerapps to do so here we are we're in powerapps we've navigated to our app this is the preview version of it so we can see that we can go get add student that's one uh combination of of gallery and form so the gallery is shown on the left hand side the form is shown on the right hand side and similarly um we can also see that we have got the uh in the achievements section and we've also got a gallery on the left hand side and a form on the right hand side so what we're going to do in this in this next section is show you how how we can we can create a form and gallery just by a copy paste process so the first one i'm going to do is i'm going to just do a copy and paste of the of the one that we created uh and then we'll then move on to doing the one that the the um that the teams uh function also created so what i'm gonna do is i'm going to hit three dots on the scr achievements and then click duplicate screen as simple as that then i'm actually going to change the title of this because it's got scr achievements one and what's actually going to be called scr and this is going to be categories category categories right good so that's my categories and it's all gonna you know work uh well it's it's only looking at it's not looking at the right thing at the moment so what i'm gonna do here is i'm now going to change the the uh the formulas here so that it actually points at the right table now i'm going to click on here and it's going to be categories uh feedback categories but notice that it doesn't like the sort the reason why it doesn't like the sort is because it doesn't have a field called date event so all this is going to be is feedback categories it's also upset because it's actually referencing fields it doesn't have either so what i'm going to do is i'm just going to delete this i'm going to say this item and i think i've got it it's called it's called dot name okay great dot name that's participation in fact and then there's also this item dot i think we can add points was one of the options here so there's different points there and i'm now going to click on the other ones and i'm literally just going to delete them just make sure i click on that item there if i can click on it on the left hand side as well and obviously you can see my me clicking on different items there's no concept of an image for participation so i'm gonna delete that may make more formulas go wrong that is actually okay at this point in times that's fine now that's happy the reason why the form isn't happy is because it's pointing at a data set that it doesn't understand so what it's saying is that well i don't understand you've got this thing called gal feedback i should probably rename that and but but but the actual data source for this form is actually the feedback so it doesn't make any sense so what i'm going to now do is i'm going to say well actually it's feedback categories you need to be looking at it's give me an option replace my data cards i'm going to say no thanks the reason i'm going to say no thanks is because i like my submit button so i'm going to say no thanks to that but it's going to be upset with me and so what i'm now going to do is just going to delete these ones individually and delete those and then i'm going to go to the edit fields and then add field and then add a number of these fields so they've got points and i think it was name was the other option and then i can click add on there and they may end up in an odd uh position in fact i'm going to click on that and if we go to the y option there it's it's it's changed it to zero and we want we actually want it to be one um so that everything's all nicely lined up now i'm pretty sure i'm pretty sure that might actually work now so let's give that a go i'm going to go ahead and hit preview hit the plus icon and the points for it is going to be two and what is the what is the uh the thing that they've done um and maybe maybe they were just happy in class and help helping class mates there we are helping classmates it's worth two points um and that's now gone in there so that that's actually worked it's done what i needed it to do and the back button will work because the back button all it does is is go back now the reason why it doesn't work is because we never went to it and we've we so it doesn't understand where to go back from so what i can do now is go to screen home and then go to the add categories in fact where it says add category i'm going to say categories and then where it's i've got the option now uh to go on to select um as in it should be on on says on change this feels a bit odd on change uh that does seem a bit odd um just going to go on to there and it shouldn't be that it's on select there we are on select and it's going to be navigate scr and it's going to be categories so now what we've got is something that actually works i'm going to click on there and it gets me there and i can navigate back it will definitely work so that's one way of doing it the other way of doing it which is is a similar a similar operation and it's going to be using the um using the the the version that teams created for us so and that's uh in the people page that we've got here so what i'm going to do is hit the three dots there then i'm going to duplicate the screen and then what i'm going to do is i'm going to start making changes so it's called scr uh people i'm going to say well actually it needs to be scr achievement [Music] i'm going to call it v2 and because i'm not actually going to keep this anyway then what's the people going to be well it's actually going to be it's going to be um achievements now uh i need to just uh it's feedback i know it isn't it's cat yeah it's actually categories i've got that one wrong and so categories it's called feedback categories that was what it was so it wasn't actually achievements at all and it's not happy with us um i'm going to change the name here because it should be catching cat v2 that'll do because as i say i won't keep this now it's looking at feedback categories and it's not too upset with me um i'm gonna go edit in the formula bar and this is going to be this item dot points uh click on there then it's got the points in i'm going to edit in the formula bar because it's got no concept of a picture so i'm just going to delete that and and there's obviously something else in there yeah the x property and unfortunately when you the x property for this item is is not in the right place but essentially i can just if i fiddle around with it it just moves it around which is which is good enough for me at this point so the gallery is okay now this thing says people and in fact what we need it to be is it needs to be categories and then we need to go into the form and the form is not happy because it's um it's uh it's not happy with the um the item that's selected now the way to make it happier is to actually change it to the feedback categories then it'll say do i want to replace my data cards and in this case i will replace the data cards so that's going to work here and in fact i don't think we're that far off i'm just gonna see what it's unhappy with here okay so what we've got here is different ways of interacting with this and and some of the things that are in here are not visible now so what i mean by that is that if i go on to preview this and i click on the handwriting when i help in teacher one and i click on the delete do you want to delete this record and the issue is on this delete thing here what it's saying is um is that um it wants to remove something from the people whereas what it needs to do is remove it from the um from the uh feedback categories feedback categories so if i just do feedback categories and do a copy and paste of that and then copy and paste that i'm not going to go into what the formula is actually doing but to all intents and purposes it's actually just deleting it um but i may actually just um do the delete operation just to show you um how so i'll press cancel on that it's now working it's actually all happy so now what i can do i notice that i don't actually have a plus icon here so i oh i've got a new record here what's that going to do in fact it's it's a bit daft because this one here is it's trying to do this edit form one one so i just need to have a a a little look at that and to see what the name of this form is now the name of form is edit form one one it does seem to be happy what is this thing and it looks like it's a button so in fact it has actually worked so this thing does actually work um and i'll just call it test one two three points is three and then i'll press ok on that and it has actually added it but what i'm now going to do is going to click on it i'm actually going to delete it do you want to delete this record delete this record um and now it has actually deleted that so if i um if i go back um in fact because of how we navigated to this the back button doesn't work either um but what we could do is as before we could change the way in which this this operates here so that we can actually navigate to that item but actually i'm quite happy that this one takes me to my categories and allows me to submit it do be careful about deleting things because giving people the option to delete things particularly when they are related tables is pretty dangerous because if you if you go back onto here and you go to record achievements we can see that we've got helping teachers one of the options now if we delete that category helping teacher it it won't be something that could ever have been picked but let's just experiment with that so i'm going to go back we're going to the categories got help in teacher and we can now go and in fact i don't have an option to delete that so what i'm going to do is i will come off this and in fact i'm just going to navigate directly to this cat v2 and i'm just going to hit the preview click on helping teacher click on the delete i'm going to delete this record now and then i'm going to go home and i'm going to go on to this record achievements thing here and notice that this thing has gone blank because it's not it's not something it could ever have been um in fact it's rather upset this thing here because no longer it seems to be able to um to i think i may have got the item wrong on this so if i just go on to here and go on to this thing here um then yes gal feedback selected i'm not quite sure what it's upset with at the moment may just because i'm in um in the edit mode that it's it's not too happy with me but i notice that it's not uh it's not firing correctly it's not uh um i think it's possibly because it's a new form mode in fact that's definitely it and so what i can do is the reason why it's upset is because it doesn't go into a new form mode and so what i'm going to do is i am going to change that and so i'm going to do is go on to there and go excuse me and go on to record achievements and as you can see this form here it's in the middle of submitting something and that's why it's upset uh and so what i'm now going to do is i am going to stop it being in that for in that mode uh the way in which i'm going to do is i'm going to go on to the plus then i'm going to go and bring in a button uh pop it on there um and the on select property on select is going to be edit form it's going to be edit form and we need to just check which form it is actually called it's called frm feedback so so frm for feedback and i click on that and i should be able to close that and now if i hit the preview and i click on there it is actually now behaving itself it's not a perfect way of doing this but it was just annoying enough for me to not be happy with it so we've come to the end of this particular lesson which i showed you two ways in which you could essentially copy and paste the galleries and the forms just to make life a little bit easier for yourselves hope you found the lesson useful and in the next lesson we're going to extend the app even further see in the next lesson in this next lesson i'm going to show you how easy it is for you to publish the app that you've created into a team's channel so that your team members can start benefiting from it let's go and take a look at that now this may well turn out to be one of the shorter lessons in this module all we need to do is we need to click on the save option here i'm going to assume that you can get to this space fairly easily by now and now i'm going to publish it to teams click publish to teams and then i will click on next got an option here to click next and what it will do is it will tell me the channels that exist within my team that are available to me so in my case i have got two channels available to me so i can put it in either one of those channels i can put in both and so now if i hit the plus what i can do is i've put that in there and i can click save and close we can actually now start to see this actually working so i'll just give that just a moment in order to finish its operation so i'm now going to go up to teams and i'm going to go over to teams and then i'm going to go down to learn and you can see there are two channels here uh i think i put it into uh power platform learn and you can now see that up in the uh the top uh there you've got the feedback app there and you can still move that around if you wish and now if i click on that feedback app our app will start to spring into life this is fine if your team member has access to teams they have access to this app and they can start using it you can click on add student and you can start putting in new records and you can put the first name last time etc etc do the person type all those sorts of uh wonderful things and you know you can genuinely make use of this app what i'll show you now is that notice that it doesn't exist in the general tab so what i'm going to do is i am going to go on to publish to teams again go to next it's going to give me the options it'll actually tell me that i've already published into one of the channels uh and so you can see one active tabs it says show tabs there so in fact i'm going to click on this here let's see if we can actually we don't actually have an interesting option to remove it here but what we'll see is that we can remove it so i'm going to hit the plus option here it's now happy with that in fact i noticed that i can actually hit the x here and like uh but i don't have the option to click the x on the power platform learn tab but that's not an issue because we can still take it out so i'm going to click save and close that's now published it to teams i can go to the general tab here and i'm just gonna now gonna click onto power platform learn you can see that i've got the app here i'm just gonna go on to the second one onto general it's obviously got a few more things in here and you can see the feedback app is there as well and now what i'm going to show you is i can right click on there and i can remove that from there i'll click on remove and i can also go on to the feedback app here right click and i can remove it from here as well and then it says it's permanently removed that's fine i'm happy with that and if we then go back to teams and then we go to publish to teams what we should see is it doesn't think that there is anything in that this app has been published into any of the tabs so that's all that is needed for you to publish your app into teams pretty simple if you ask me i hope you found this lesson useful i'll see you again in the next lesson i've got some really interesting things to show you there thanks in this video we are going to extend the school achievements app so that you can actually send an email to a parent or carer to say that their child has done well let's move over to powerapps in teams to do that so i'm in teams i've gone to my powerapps icon on the left hand side i can now go to build and then i'm in learn which is my team that's got everything that i know and love in here and what we're going to do is we're going to soup up the app so that it can actually send an email i'm going to do it in a very straightforward way now one thing that we haven't done so far is we haven't indicated what the email address is for the child's parent or carer so i'm just going to go on to people and i'm going to change this particular this particular entity so it can do that now we've got to this slightly scary screen here and what we can do is we can change it from default to go to custom and then we'll see there's just a few um fields and these are fields that we created now i can add a column here i could go to the visual editor um but i'm actually going to add a column here and what we'll be able to see is that we'll be able to see the um the fields that we're going to create now i've got a number of different field types that i can create and obviously email is one of them that's the one i'm going to do and then the display name is whatever display name i want to give it and i'm going to say um got uh i'll say carer email now clearly i could make this a lot more detailed in terms of cara 1 cara 2 i could even have um i could even have you know a related uh nature a relationship between the child and the parent which is which is one of the routes that i could have gone down but i'm gonna kind of maybe try and um try and keep it a little bit simple at this point in time so if this was a real solution probably wouldn't be how i do it but this is good enough for the purposes of this exercise now is it required do you know what i think it probably would be required and so you can see that this is one of the options i've got here i'm going to leave it at the moment um but just bear in mind that if you try to fire an email to someone and they didn't have an email address it's not going to actually be very successful so i'm going to click done on that and then i'm actually going to pop into the visual editor and let's just see uh i'll click save table and just see if that if that field is actually showing in my visual editor so i'm just going to pop into here and it does actually appear which is kind of handy and it's interesting that on the um the the picture field then we've got these uh we've got the people's pictures but we can't actually see um we haven't got an ability to add the picture that's not a problem so what i'm going to do is under under uh roger federer i'm just gonna go in here and um i should really change the app actually i think i think we know that i can write an email in there that's dead easy what's probably a bit better is if i actually go onto the app uh go on to my feedback app click on that what we're going to do is we're going to go to the people form we're going to add that field into the people form so that then if that child has uh has an achievement then you will get an email um then then then the parent can be sent an email so we're just gonna wait for this to fire up that's brilliant and so now i'm going to go to add student i'm going to click on roger federer and then i'm going to click the x there and then i'm going to click on the form itself and i'm going to get edit fields and then go to add field and then i'm just going to type in email you can see it said ikera email that's the field that we created click on that click add and then it'll appear in our form so that was kind of easy so now we can actually change that and so i'm going to put in my email address in fact i'll do um uh i will do a different email address in fact interestingly enough i just need to make a change that of course that's fine okay so i'll do i'll do tester at data spinners dot code uk in fact i don't actually normally log into tester at data spinners.cod.uk so i better put um my own email address and pop that in there and then click the okay on that and that means it's got an email address i could do something like i could do something neat on here um and um i could just put a little dot of some kind so if it's got the email then i'll have a dot and then if it doesn't so maybe what we could do is i can go on to a blurs go and and we can go and put in a shape and then we can do a circle and i've got a circle it's appeared here pop it in there and then what i can do is uh go on to the visible properties that's when right shows or not visible and and then what i'll do is i'll say true means it will show and what i'm going to say is blank helps i need to just go on to the property there and use a particular formula so i'll put is blank you have don't have to do this this is just uh something you could do and carer email so that that dot will only appear if the email hasn't been filled in and then maybe if we were doing that then i'll go to the fill property of that and i'll just kind of make it red because maybe that's an issue for us red and and then just go okay on that so roger's got his email filled in but novak doesn't so um maybe i was going to click on novak i can kind of edit this one here go on to the carer email and then do tester at data spinners dot co co dot uk and then i can click the ok on that and then we'll find that the the um that disappears so that was nice and easy what i'm now going to do is show you there's actually quite a simple way of sending an email automatically so what i'm going to do now is i'm going to now go onto my my achievements screen then what i'm going to do is i'm just going to maybe create a little bit of space for myself down at the bottom here maybe just move this around and i'm just going to add a little email um an opportunity for us to to send an email in fact what i'll do is i'll create a new screen i'll do it from this but then i'll just delete everything out so i'm just going to screen achievements hit the dots duplicate the screen and and then what we'll do is we will populate it with some things that will mean that we can send an email out so what i'm going to do is i'm going to take most of these things here and and i will i'll keep that back option there i'll get rid of the plus and i don't need this gallery really um and i don't need this refresh uh option here so what i'm gonna do is i'm going to use the office through um the outlook connector and the way in which i'm gonna use the outlook connector the way in which you'll need to do it is you'll need to go to the um the data icon here you need to click add data in fact you need to get down to the connectors and then you need to click on office 365 outlook and then if it doesn't exist already you click add a connection and then you click connect now i don't need two of them so i oh i'm okay with this and that means that you will have that available to you in your app and the purpose of this is so that we can then um have the ability to send an email so what i'm going to do now is i am going to create um i'm going to sort of compose an email a few bits and pieces so that we can send something out so in order to do that i'm going to need a few text inputs so there's one there and i'm going to call this it's got a very long name here and i'll call it lbl and it's going to be in fact it's going to be txt and it's going to be uh email address and i want to make sure these are quite easy to read and then i'll do another one and this is going to be txt and txt subject and then i'll do another one which is going to um txt comments txt comments now uh what i'm now gonna do is i'm now going to make this one a bit bigger because it will be bigger um and now i'll also change the the the defaults that we've got here so uh maybe this is um your child has had an achievement [Music] okay so that's going to be the header um for our email in the text box what i'm actually going to do is i'm going to refer it back to the the item that we've selected so i'm actually going to go on to the uh onto the tree menu here and i'm going to go down to over to um in fact i've gone on to the wrong one which is a bit of a disaster actually and so i have now i'm going to change this here so hopefully you won't make the mess that i've made of this uh i'll call it scr email that's fine and unfortunately um i have managed to make adjustments to the the uh the original achievements thing uh and then so which means it's all going to kind of go a little bit strange so i'm going to change this uh this the screen name here but notice that there are lots of odd names that we've got here but also if we if we go on to the home screen it will actually go on to the email here so if i actually go on to record achievement it's going to go on to the email thing so what i'm going to do is i'm going to go back and then where it says record achievements on select and it'll navigate to s oops scr and it's going to be achievement and that'll take it to the right screen now because i renamed the screen so that's gone to the right screen and what i'm going to do is i'm going to find some kind of email icon and so i'm just going to go up to there and i'm just going to add another button then so if i had a plus and then go onto button drag it onto the screen here and it is going to be a little bit uh cramped in here so maybe i'll make that a little bit bigger and in fact that's the it's quite hard to actually select the right things here so if i go on to the i think if i click on this and i go template size then that is the height of the template so i'm going to make this let's say if i made it 60 60 that will make it a little bit bigger and what this uh this will give me an option of doing is sending an email so now i'm going to uh it's it's it it's been a bit funny with me in terms of the size of the buttons and so on um but but there are ways around that so i'm going to go on to the text of that button in fact it says button uh i'll have to send oops send email okay so now i've got an option of sending an email and and what i will do is on select and it will just get it just give me a navigate option so we're gonna we're just going to navigate and where we're gonna navigate to the screen um and it'll be the screen email must be email and then close the brackets close the brackets but we're going to do some interesting things here what we're going to do is we're going to have the ability to then start to um to refer to uh to this particular line item so that we can send that email out so now what i'm going to do is i'm going to hit the preview and i'm going to click send email but of course it's not going to send an email it's just going to take us to this screen then what it's going to do is we need to know the email of the of the child or rather of the carer for the child and so what that is is if i go to preview and i go back again and then go onto this screen and then this is called gal feedback underscore two it's not a very good name for it so this should be called gal um uh chief meant record okay so it's called gal achievement record so now what i can do is i can go to send email uh and what i can do is in this bit where it says text box here i can say well actually the value here should be gal achievement record dot then it needs to be selected that means i've selected it's the one that i'm currently selected on that'll be okay then what do i need well actually i need the email address so actually i need to reach in to the uh the the people entity or rather it's um it's the student entity uh which is really the people entity and then do another dot and then i can type in carer email and that should result in the correct email address that has actually worked so what i'm actually going to do with this is i'm now going to uh to do the same thing but in this this comments check box here now i'm going to go on to here and i'm just going to do a preview on this um and just check this yeah this this business to do with being of value is it's its default value is is what we're actually looking at here so what i'm going to do is i'm now going to go on to this value thing here and what we want is gal achievement record dot selected dot and and it's going to be and it's going to be the comment here going gonna click on comment home out well laid out that's great now notice that this thing here says mode is single line and in fact what we should do is make it the mode multi-line and then it just lays it out a little bit better so homework well laid out so that's all nice uh nice uh nicely laid out we know what the the uh the email address that we're sending it to and all we need now is to be able to have a button that allows us to send that email so what i'm going to do is only hit the plus i'm going to go on to in fact i can't do icon search i'm going to drag this onto the screen here it's a plus icon but what i should be able to do is let me just see if uh if there's mail is an option here and there is send i think send is another nice one so we can do that and so we've got a send option here and i'll pop it down at the bottom maybe like this uh there's there's better places for this better ways of doing in fact i'll do it there that that's quite a nice little spot there to put it on and now on this particular item here i will need to i will need to make sure that it does it behaves itself so what i need to do is i need to take a formula i am going to cheat and i am going to paste in a formula from uh from here now this won't be quite correct yet so i'm just going to make it a little bit bigger and we're going to make some little changes to it to make sure that it actually behaves itself so i'm just going to grab this formula and and we will then make some changes to it because it definitely won't work so on select send an email who are you going to send it to rory dave spinner but half of these objects don't actually exist so you're going to send it to and this is text email address so okay so you're going to send it to um txt email address dot value oops then you're gonna be the the subject of the email is going to be the so the subject is going to be this uh this item here so let's it says text txt subject so i'm going to call it actually txt subject uh subject dot text oops oh it's got dot value okay fine um dot value and then the uh the content is gonna be uh txt comments dot value and then it's all happy at this point in time and at this point it would actually send an email across um and so what i'll do is um i i could then sort of start to to kind of make this email a little bit better so what i can do is i can then um i could then do things like um we would like to let you know that that your child [Music] has had and that she meant today um and then we can do something like the uh achievement uh yep achievement is as follows and then we can close the quotes and put another ampersand in and then it will actually be okay notice i actually had to do a shift enter to actually do a line fade here and so the achievement is as follows and notice that i need to actually put a space in and then another shift enter and maybe another shift enter as well um and um and then you could you know you could you could make this a lot more interesting as an email but what we should do now is we should actually try this email and see if it actually works so i'm going to hit the preview on this and i'm now going to click the send on this so you saw that send it was very quick to be fair and what i can now do with it is i can now go and have a look at my emails to see what happened so you can see here that the the email did in fact send so what we can do is we can actually go back to powerapps and we can try that again i can see there's actually a bit of a typo in there so that means i can sort of change that around uh move that back and then what i can do is i can go to the preview hit the back button and then maybe wait maybe click on this one here and then what we can do is click on send email now um i'm going to click on send email uh your child is an achievement and achievement as is as follows we could have done things like put the child's name in and all that sort of thing and you know but for the purpose of this video you know that we can we can do that sort of thing now the thing that i am uh interested in knowing is whether or not we can actually add in some extra information in here and the extent to which it will it will behave itself now just bear in mind that power apps for teams is a bit different to standard power-ups so this will be interesting to see whether or not this actually takes the value out of here correctly so i'm going to click on that it's now added that in and i can now go to my email and just see um see the email and as you can see the email has gone out i'm going to do one more test and that is to go now that we have edited this we have to be a little bit careful about what's going to happen when we when we next go into this because you do need to reset things as you go back and forth so what i'm going to do is i'm going to go back to teams and now i hit the back button and now going to this one's our participation one so this is the novak uh the novak djokovic participation so if i click send email here it says wonderful pictures in fact it kind of has reset itself so i'm kind of happy with this and i can put test one two three and then click on the send icon here so now we can uh head off to my email and we can check whether or not that's actually worked correctly now as you can see here the it did actually try and send it as it happens it didn't send it because that that email address didn't actually work it's you know it's i may have not allowed it to have outlook um but but the principle is that the attempt was made by the app to actually send it and so i'm really really happy with this it actually worked um you know as well as i could have expected um i hope you found this lesson useful to you now we've pretty well got an app now that if we actually uh if we actually now go and save and then we go publish to teams now one thing i will uh get you to note is i'm going to sort of i'm going to go i'm going to duplicate this but i'm actually going to go into teams because if we go into teams we'll be able to look at the learn and in fact we haven't published it anywhere into teams so um i'm going to publish it into teams i'm going to click next it's now going to give me my uh the screens that are available to me done this before click on this power platform learn and i'll cancel that and click the click on this one here just need to hit the plus that was it save and close that means that that is now available under power platform learn we can go in there and if i refresh this we should see that tab has now been added in i can see the feedback app and it's all working so whoever now notice this time around we've got these additional things that that the user has to um be happy with because it's got now got the ability to send emails i'm going to click allow on that and now we can go on to this record achievements thing in fact and then i've got an option to send the email roger federer in his beautiful handwriting um so there's just a little a little glitch there and go record achievements and i'm going to go on to this and go send email and you can see that it's in a position to then send that out another potentially challenging lesson but this one is really important because it really does offer the possibility of of making a big change to the user experience it's one thing for a child to know that they've achieved something but it's another thing to to actually get an email that is sent to you i hope you found this lesson useful and let me know in the comments below if there's anything that i can help with thanks we've now come to the end of this module it's been an interesting exercise in creating a solution on top of the powerapps teams common data service oakdale integration it's a little bit of a mouthful at the moment essentially with teams you get a database and the ability to make apps so where we started with this we talked about what we were going to build this this idea that we could record children's achievements and actually and actually then maybe go on to send emails uh on the back of that i then talked about the data model that would be needed to support that and we then went on to build the entities that we needed now as it happens out of the box you can't quite build all of the fields so i showed you that you can actually add image fields in a slightly different way but they are super valuable i love image fields we then created a title screen because title screens are really nice as far as your apps are concerned it just a nice landing page is of real value to your users i then showed you that even though out of the box we had galleries and forms that were pre-created for us we could go on and build our own galleries and then as well as building the galleries we were able to build forms of our own as well we then looked at how we could actually shortcut this gallery and form building process i'm not necessarily sure i would always do it but at least i showed you that we were able to copy screens and essentially all of the objects in those screens so that we could make a use of them again and have a slightly more consistent view for our apps we then published the app to our channel within our team and saw that was actually quite straightforward process and then finally we built an email notification within our app so overall it's actually quite a neat solution i think that that the fact that it's actually all self-contained within teams and you all get all of this as part of your office 365 license is really tremendously valuable i'm and i hope that you see within what we've done here the possibility for you to tweak this and make this match your own business processes in the future if you have any comments on the lessons that you've seen please let me know within the lessons that'd be extremely helpful and i'll hopefully see you again in another lesson

Channel: Rory Neary

Views: 2,258

Rating: 5 out of 5

Keywords: PowerApps, Tuesday, Tutorials

Id: QdKnOCszwlQ

Length: 133min 32sec (8012 seconds)

Published: Tue Oct 13 2020