 So we want to start off creating an app. You can create an app from whatever data that Power Apps can connect with. And that could be a SharePoint list and Excel spreadsheet. We're going to start with an Excel spreadsheet. OK, so I'm going to click Blank App. I'm going to click Create. I'm going to use a phone format and I'm going to give it a name. And I'm going to call just so I can remember it easily. It's the June 23rd demo call. That's where I'll give it the name. All right. And now if you have a way to either on your phone, you can follow the instructions. What I'm going to do is the manual instructions, not the automatic ones. Because once you understand how to how the screens are created, you can make adjustments from templates that you can find that you might like to modify for your own use. OK, so we need to select a data source. And I'm going to go over here and click on data. I'm going to click on add data. And I'm going to search for one drive because one drive for business, because that's where the data is. So I'm clicking on it. Great. That's what I want. It's this table inside the spreadsheet. And I'm going to make a connection to it. So I'm in the part that's called Building Screen One. All right. So I'm going to go back to the Tree View here. And on the on the right. Let's see, follow the instructions. Your data source, choose a table, click Connect on the right panel. OK, seems OK. Connect. How come I'm not connecting an insert an item? How come it's not connected? I'm having some difficulty. This should just automatically. Oh, I see. OK, I'm going to insert. I feel like I. Forgot something here on the right panel. OK, my bad. OK, I need to insert a blank vertical gallery. So I'm going to see if I could just get that in here. So I'm looking for the vertical gallery and go home, insert, input. I think I'm going to start over because something isn't it's not following the instructions that I started with. So I'm going to remove it. OK. And I'm just going to go back. See, all right. So I'm right here, save. And start over. So I guess it doesn't matter how many times you practice, there's still some something that can happen a little bit differently than what you expect. OK. So what I'm looking for here is build screen one. So I'm clicking on insert and. I am I am just baffled as to what is not what I'm just going to completely start over. Let's try to get leave that. All right. So I'm here and I'm going into Power Apps open on a new tab and OK, a blank app. Yep. Create. OK, phone. OK. I'll call it June 23rd. They to create. All right. Phone create, save the app. I'm going to skip that part and I'm going to follow as closely as I can. The steps that I outlined, which when I followed them to practice were. Really good. I'm going to close it. I should have it. I go to all apps. Sometimes there's a short delay. Again, sorry about this. I'm a little puzzled as to all out. Nope. That's not what I want. Go back here. OK. And in the meantime, a couple of other people joined us. So I think I'm going to have to start again. I haven't had this problem before and I'm a little bit confused as to what. So this is a take three. Well, you're practicing your own. Can we get a quick introduction? Sure. If you want to go on the chat or verbal. OK, I'm just putting the screen on briefly so you can see our morning chaos is 1138 in Connecticut. And hello from Valerie and teens. Kora and Steven in different parts. Oh, hi. Yeah. OK, so yeah, I think I'm I think I'm OK to go, Valerie. Thank you for helping me out. I apparently did not have the screen wide enough and I wasn't seeing some of the controls up here. OK, I'm back to the build screen one where the first instruction is insert a blank gallery. So what I wasn't seeing before was this gallery. And as you make it as you change your screen size, that input option disappears. So there's a handful of different ways to do things. So I'll eventually learn where to find the gallery in another way. But a lesson learned there, depending on how wide you have your screen set up, you may or may not see the gallery. So what I'm doing here is I'm inserting a blank vertical gallery is like a container. And then I'm going to select a data source. OK, I need to connect to data. So I'm clicking connect to data, add data, select a data source that could be a database, a spreadsheet, a SharePoint list. It could be data verse or a whole host of other connectors. So I'm going to start off by looking in OneDrive for business. I'm going to connect to OneDrive for business. And I found the spreadsheet. Which has a table, which is the data that I want to use for the for this demo. And then I'm going over here to data source and I'm going to select the table. OK, and then I'm going back into the center area. I'm going to make this a little bit wider. And the next part is to select a layout. And now I want to change that layout to title, subtitle and body. And now you can see some of the data is coming in. And Valerie, you'll see your name in there and my name and some other people's names. OK, and so I'm going back to band and select the tree view. I'm working with gallery one. OK, and what I'm going to do is I'm going to put a border around here. So these instructions hopefully guide you to locating where some of this stuff is when you're doing it the very first time, it seems a little bewildering, but eventually it becomes second nature. So I'm going to make a width of two in there and see. And it did it put a boundary around here. OK, and so I'm going to select gallery again. And I'm going to edit the fields. And instruction seven recommends changing the title to location. So these are all personal preference. Subtitle one is co-producer and body one is going to be the project. Because these are the things that I want to be visible on the browse screen. OK, and I'm just going to click out of there. And now I want to reposition them a little bit. So I'm going to add some titles, some search options and some headings and see how that works out. Whoops, sorry about that. I guess you can't see that. All right, so on the I'm going to insert a label. So I'm going over here to insert label. And I want this to be up at the top. OK, I'm going over to the right panel and I'm removing the text. I just want some background over here, a background color. And I'm going to put some other things on it. So I'm going to make it a little bit wider in here. And next, what I'm going to do is I want to fill that with a light color. Again, it's your choice. I want to show you what some of your options are. OK, so I'm putting that in and then I'm going to insert another label. I'm just moving my instructions over here so I could see them a little better. There, I've got them on the side here. And move them over a little bit. OK, where did my screen go? OK, here we go. We're back. All right. So I'm going to move the chat off here. And I'm going to if something is if someone's putting something in for that either Ken or Valerie can alert me to or else I need a third eye to to watch everything. OK, so the next thing I'm going to do is insert a label. And I'm going to call it the browse screen. All right. So similarly, I'm inserting another label. I'm going to make this one a little bit smaller and I'm going to put it in the middle. I'm going to change the text to browse and just to save time, I'm not going to write out everything that I suggested in the instructions. OK, so we have browse there. And then I'm going to insert a text input for the search area. So a text input, OK, to put this below it. Make it a little bit wider over here, sort of just like that. OK, and I'm going to remove text input. And in the hint text, I'm going to put search. OK, and so that that puts it there and you can make it lighter, darker, center it and so forth. OK, and now I'm going to put in another label below that to put a little bit of guidance for what he in the items below. All right, I'm also going to give that a fill color, a different one. OK, and I'm going to call this one. I'm going to put the labels of what we're looking at the column labels or the fields. It's location and co-producer and so I'm going to go up here. Location and co-producer and below that is the specific project name. All right. And I want to center it, click the center here, and I want to make it bold or semi-bold, whatever you like or underscore. And then on this one, on these two, I also want to put a border. And so you can make your border thick, I'll make this one a little bit thicker or you could make it a thin border and you can also change the color of the border. I'm just going to make that a thin one. OK, all right. Now, and then the other some of the other things I'm going to do is I'm going to add an icon here, a search icon to give us the visual clue that this is for search, so I'm going to put that just adjust and you can adjust these, you can make them smaller. You can move them around with your mouse, you can move them around with controls over here with sizing and placement and so forth. OK, now what I want to do is I would like to adjust what's in the display here. And so I'm going to click in here, I'm going to make it I want to have about 10 items to display. So I'm going to reposition the layout here and narrow that a little bit. And I'm going to move this one over so that they're both about on the same level. OK, and I need to make this one just a tiny bit taller there. OK, and maybe nudge it up a tiny bit and I can do that with my arrow keys. I think, OK, all right, so that's about what I want. And just going to make this one a little bit lower. And now I can move the whole box up. And now I think I have just about now if I select the gallery, I want to move the entire gallery up to fill the screen. And that's what I want. So I have one, two, three, four, five, six, seven, eight, nine, ten, ten, eleven. And if I work with the spacing, I can get ten or eleven or maybe even more, depending on how I want them to be laid out. So you see by changing the position of this top one, it serves as the model for the other ones, I'm just going to put that down a tiny bit. OK, so I'm going to leave it about like that. I want to add two other icons or reload and then add new item icons. I'm going to go up to the icons here. And these are literally just icons. They don't do anything until you give them a formula or to control them in some way. OK, and maybe I'll move it over just a little bit over here. OK, and I also want to add a new item icon. And we are going to add in the formula or instruction for what that does a little bit later. OK, so I'm just checking on the chat, seeing if everybody's good with that. But basically what we've done now is we've created the first screen. OK, actually, I want to do one more thing. I'm going to add the search formula. OK, so we select gallery, made the adjustments. OK, and I'm going to skip over how to highlight a selected item. I'll maybe come back to that. I want to add the search formula. So this is what PowerFX is about in the training that some of us have been taking with Rory Neary's course. This is the formula bar. This is where a lot of the power in Power Apps comes from. So here's where we're going to use it in a big way. So on the left panel over here in the tree view, I select gallery one. And then I see items up here in the properties list. In the formula bar, I see YTB projects. We are going to make a change. And so what I'm doing is I'm going to copy the instruction. Line in the Microsoft Word document, and I'm going to paste it in here. And what I want you to notice is what happens in the display. I broke it. Now I'm going to paste this in. And now you'll see what it did is it sorted alphabetically by location. OK, and if I go into play or preview the app, if I type in Connecticut or the beginning letters of Connecticut, it filters down to show me those items related to the projects going on in Connecticut. So that's that's one of the very powerful things that I'm just going to save this here. I believe it's saving automatically, but I don't want to take any chances here. And now we'll be able to go on to screen two. All right, so starting screen two. I go to new screen. And I add a blank screen. And then I locate the forms tab and insert. And I the type of screen that I want is a display screen. OK, I'm just going to adjust this a little bit. And in the right panel, let's see, I'm following the instructions here. Form viewer one right here. Data source, the data source that I'm working with is the one that we have been working with. I select the fields that I want to display. So for the purpose of this demo, I found it useful to select the fields in a particular order, because that's how they will be placed. And if you want to reposition them after you place them, if you just want to click down all of them, you can do that and then you can reposition them. But I'm going to select them in this order according to the instructions that I put together or the step by step instructions. And I want notes to be at the bottom. OK, so I do that and. All right. And now I'm over here. I'm going to I'm down on screen two. But now we see that there's no there's nothing showing in here. There's no information. All right, so we want to connect to the to the data. So on the properties properties list in the top left, if you are able to refer to the instructions, we want to select item and in the formula bar, we enter gallery one as selected. And that populates our view details form. All right, so that's exactly what we wanted. Now we want let's see, we'll put a border around here. And I'll call it three. Let's see if I could change the color. Oh, I don't want to do that. No, that's not the border. I want to change the border color. There we go. OK, OK, so I got a red border. That's pretty nice. Now I want to put a title up here. OK, so you could follow along with the instructions. I'm going to take a little bit of a shortcut. You can go back to screen one and I'm going to copy what's on screen one. So I'm holding down the control key and let's see. Did I get everything start over? I mean, I want the big one and then I want these. Oops, I want to I want to select everything here. All right, let's see how that goes. A little bit of practice. Maybe I'll get it. OK. And then I'm here on screen two and I'm going to paste it. OK, so not too bad. I didn't get absolutely everything. But in the browse, I'm just going to change that. This is my view details or you can call it whatever you want. I know in the instructions I just suggested a little bit different. OK, and on the let's say I'm going to move everything upward. And if I select everything, it'll all move up. I didn't have everything selected. So I'm moving them up individually and I'm using my arrow keys. OK, and I'm going to push that up. And one of the other. Icons we want to add as the back icon and let's see where is that. So you can use an X. You can use a left arrow and use this one that says back. And then I'm using my arrow keys to adjust it. And the back is pretty easy to get the formula for you. Say when you select it, what do you want to happen? I want to go back so it's back and I close out. So that's pretty good. And we'll program the add new item button because once we have our third screen set up. So I'm checking the options here. I've adjusted them and you can also change the formatting here as you like. But I'm going to move on to the next screen. OK, and one thing I'm going to change down here is. On the notes here, I think. There's a way to make this to line if I've got the line wrap on. So that's pretty good. So maybe it's working kind of the way I would want to. I'm just going to give it a little more. I can give it a little more space, maybe not. I have to first of all make that one bigger. OK, and then the interior one I should be able to make bigger. OK, so that's pretty good. All right, so I want to move over to the third screen, insert a new screen. And it's going to be blank. OK, and I'm going to collapse my other screens here. So we have screen three and then I want to add a form to it. It's going to be the edit form. All right, so here it is. And then on the right panel, let's see form one, I'm at form one right panel. And I select YTB projects. OK, a panel opens and then I'm going to edit fields. I'm going to add the fields and similar to before I'm going to click on project co-producer, location, com, coordinators, team and notes. I'm going to add them. And similar to before. I go over to the properties list. I select item. Hopefully I can let me go over here and make sure I have the form selected. And I should see item in here. So I could just start typing it and I enter gallery one dot selected. All right, and hopefully good. It brings in so I want to select the whole form. I want to put a border around it and I'm going to resize it. And I want to bring in a like a header or a border area title. And I'm going to paste that in. And I also want to put in some description for it. And then we're pretty close to having a rough cut copy of. Our app. All right. And so we want to let's see, select the form. Go up. We want to also put a back icon so I could copy that. And I know it's we're at twelve oh one. I think I'll be able to bring this into the finish within just a couple of minutes. If you have to leave, I understand that you'll get a copy of the recording. And then we want to we want to put it in icon to confirm and submit a new item when we add it. So I'm going to refer to the instructions on what that what that is. And it's called submit form one and then go back. Copy on select submit form one and go back and then do one other thing. When it's successful, we let me see. Let me click the form when the form is successfully updated. We want the form to return back to the browse screen. So we're going to put a back and put that in there. OK. And this this is the one that I want to reposition so that we can see it a little better and click here, pull it down a little bit. This is the one where we want it to be multi line. It says mode single line. We want to make that multi line. We go OK. And so I think we're just about there. We have the control set. Now what we need to do is connect the add new item. And so this is the very last part. Three more steps we want to navigate and create a new form that we can enter when we click the plus icon. And so on select, we want it to actually perform a function. And that's the function we wanted to perform. Oops, you don't have to click tabs in there. Sometimes I do that. And then when we want to view an item, OK. We want to navigate to screen to to view it. So we copy that instruction and on select, we paste that in. OK. And on the screen to is that where I am? Let's see on screen to we want to add an edit icon. I forgot that one. So let's add that one in edit put in that pen. OK. And actually on the view details, we don't want to add one. We want to edit it. That's what we want to do. OK. And for that edit icon, it's going to take us into screen three and edit that form. OK. So then we put that. So these are the power effects of formulas. And now I think we are set and let's save it. We'll publish it if we want to share it with people in our organization. OK. And now let's test it. So let's go back to screen one and see how we did now. I could see that I'm chopping a name here. So I want to make a tiny adjustment on the layout here. So let's see I'm in the gallery. I'm just going to click. Let's see if I can. Yeah, I just want to make this a tiny bit bigger, just a tiny bit. And then I'm going to take this one and I'm going to move it down. And then this one, I should be able to enlarge a little bit just. There we go. And now I could see things a little better and you could spend more time on the adjustments there. OK, so I'm going to save it, publish, publish. And then let's test it and see if I got all the steps. Hopefully this won't take too long here to the publishing and save. OK, OK, yeah. So I see some questions there that I'll help out with afterwards. So let's do a practice. So we did the search. If I type in Uganda, I see Uganda. So that's good. That part's working. If I click on a refresh, there's really not a lot of data added to refresh. Let's see if I can add a new project. So a new project and it's in where do we want this one to be? I'm going to say it's in Alaska. All right. And we're going to make something there. And we're going to send Valerie, Kora and Steve to Alaska. And the NJ team is going to be their backup. And we'll say, let us know what you need when you get there. All right. And let's see if it'll save it for me. Come on. Yay, it saved it. And there it is. Alaska New Project. I want to look at it. There it is. And OK, so let's see. We'll send gluten free pizza. OK, I hope you like gluten free pizza. Here's section for private rooms for parents. Yes. OK. All right, we did it. What thank you for staying on. I know we had a little bit of a bumpy start there. And that's my blind spot. What happens in the two those tabs when your screen is in a different position? But I think I got it now. So the closing summary sentence or two is that. Those of us who are working with community organizations, nonprofits, businesses, schools, we have ideas for ways that we can use technology and benefit from having apps. Maybe an app that is a collection of resources or maybe an app that has ideas that we picked up from training or an app that collects web links or something that reminds us who's on the team or not reminds us. But if we're in a community organization that has more than a handful of people, we could use it to include member names, contact information, notes, skills and strengths of each person. This also the sky's the limit. Once we have a little bit of confidence with creating the three screen apps, we can expand it. We can add charts. We can put video information in. We could connect it to Power BI. We could show the charts inside here as well. We can do calculation and I'd be happy to help anyone get to the file if they don't, if they have some problems locating it. But does anyone have a question on whether they see a value or some use or purpose for working with this tool, Microsoft Power Apps, in their community or in their family? Ken, if you're still there, I don't know who's. Yeah, Ken, if you're still on the me check in with who's still with us. So would someone be willing, either Valerie, Robert, Ken or Akesha, any thoughts on what you could imagine using this tool to do? Anybody, Steven? Cora, I know you're working on some some resources for my goal. I think we actually met about that. Yeah, explain what you're doing with the course and making an app for resources for teams with autism, because I can't really find a lot of good resources. They're mostly for like kids and like parents of kids, not really kids themselves. Yeah, this app that we have right here, it could be easily modified. Like I could share the app to you. You can make a copy of it and you can modify it to like where the where I'm using location that could be that either literally could be the location of a resource or you could make a simple spreadsheet where you indicate the name of the resource, a short description, the phone number, the website, the specialty or something like that, or whatever you think people would find useful and we could create an app to that would that could be used with adding and reviewing that information? Yeah, what do you think, Ken, any if you're you still with us? Oh, yeah, I raised my hand that everything. Oh, gosh, yeah, I just saw that. I'm trying my hardest to use technology to its fullest. That was a great demonstration and for someone who is a little more seasoned getting to catch up on the app. So Cora is sharing what she's developing is incredible. And I'm sure Robert Steven and everyone else on this call developing things. And I accessing or reaching out to people, I see apps the most useful. When you reach out to them, it gathers data, but it also provides resources. So if someone checks off using the scans that you developed by TV scans, and they're feeling not so good today and they wanted to reach out to someone clicking a resource like the second floor helpline that we have in New Jersey, they could talk to someone. So the possibilities are endless. I wish I had an apple for the teacher because usually we provide it. This was incredible. Wow. And in my hope is that Opeca and the work that I could do to help with the people collecting the data in any way that I possibly can, because we have all this data. We have the outreach we can use the data in real time. I'm just blown away. I want to. Yeah, you're welcome, Ken. Thank you for joining. And I use myself as my own learning aid or something. And what I want to say is that if I can do this, anybody can do it because you saw how I fumbled around in the beginning. I'm not a world expert at this, but I can figure things out. I know who to ask for help. There's a lot of training. And I gave you a demonstration of how by following these instructions. Now, it took me several hours of putting the instructions together, trial and error going through. But my motivation was that I felt that the barrier to entry with something like Power Apps is that with all the trainings that are out there, there are not a lot that literally break it down step by step. So I'm just going to close out by going back to let's see the. Yeah, here it is. These are the instruction. And so what I'll leave you with is this 10 steps, which I haven't memorized here. And I'm going to show you how you can use Power Apps as a to create an automatic app that you can certainly use, but generally you want to modify it. So that's why going through the step by step of how it's actually created is useful. So suppose I'm back and here's there was just some time delay, but you see those other attempts did show up in here. It takes a couple of minutes. OK, so I'm going to go into create an app. I'm going to create an app from Excel. Now, you'll notice how this is completely different from what I just went through. That Power Apps is going to automatically generate the app. It's going to look a tiny bit different. OK, and I want to let's say I want to get my data and let's see. Where is my data in here? My connections. Oh, I guess my connection is my account. That's right. OK. And so I'm selecting it here. I'm connecting to it. Oh, I thank you, Steven. I see your comment in there about homework and quizzes and schools. So what's going on right now is that Power Apps created the app. OK, now it might be a little bit rough around the edges, but we can open things. We can edit them. We can go back and you see it's organized in a slightly different way. I'm going to type in Valerie. OK, and what it's showing me because the search is different. So this is what I want to get better at. It's showing me all of the so Valerie is involved with quite a few of the things in Y2B. And so the search is working differently. It's doing a search across more than one column. And so I want to know how does it do that? All right. So what I could do is I could click on Browse Gallery and I could look up here. And then I can practice with this. To use this type of search G. And this is where over time you learn a bit by bit of the different expressions and functions in the Power FX language that can be used and applied to have your app do different things. And Steven just wrote in collecting baseline data. And we're going to be talking with Steven next week about a health care app that we're curious about and an app for farmers. Yeah, so you can create you can use Power Apps to create an app automatically from Excel or from SharePoint or from Dataverse. Or and you could also learn how to build it from scratch from just a blank slate, which is help as you go along to understand how to make modifications and changes. I'm going to close out the meeting. I thank you for those of you who are able to stay a little bit longer. I appreciate your patience with me being on the learning curve with trying new things on these sessions and to learn us to teach. So I hope you liked it. I hope you'll join us again in the future for something. And you all know my email. So if you have a question and you it didn't work out for you to connect with the spreadsheet data, just send me, you know, WhatsApp, text message, email, and we'll make sure you can get to it. So thank you, everyone. You all have a good evening in East Africa. We're seven hours later and we're going into our early afternoon here on the East Coast. So thank you, Akisha. Thank you, Korra, Juliet, Ken. Thank you, Robert, Steven and Valerie. So we're going to do the countdown. Can I have some YTB people and anybody who wants to turn up the volume?