Microsoft Power Apps Basics | Bash (BizTech Matters) | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

14 Lessons (45m)
    • 1. Learn Microsoft Power Apps Basics

      0:31
    • 2. Get Power Apps

      4:33
    • 3. Create Excel Data Source

      2:17
    • 4. Creating the App

      1:39
    • 5. Previewing the App

      6:07
    • 6. Tree View

      2:41
    • 7. Edit Properties

      4:18
    • 8. Insert New Item

      3:14
    • 9. Insert New Screen

      4:02
    • 10. Actions

      7:37
    • 11. Additional Options

      1:17
    • 12. Save and Distribute the App

      4:09
    • 13. Mobile App

      2:05
    • 14. Thank you and Congratulations!

      0:53
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

272

Students

2

Projects

About This Class

Last time you opened an automation in Microsoft Power Apps and are overwhelmed by the number of things to do. You don't know how to make the best use of your time.

But it doesn't have to be this way!

You Will Walk Away With...

  • MORE TIME!
  • Create your own Mobile App from scratch
  • Turn your ideas into apps with zero coding with this!
  • Understand the essence of the Power Apps concepts and techniques, and see them in action!
  • See how it is done in Power Apps with real examples!

After this class you will be able to:

  • Actually SMILE when you open the App :-)
  • Brag to your friends about how you can create real-world apps confidently!

If you're like me, you want to create desktop and mobile apps for important tasks and projects. Whether it's for business or personal related projects, everyone wants to be able to their transform ideas to apps freely and easily.

Here's what we will cover in Power Apps:

  • Accessing Power Apps

  • Create the App from a Data Source

  • Tree View

  • Editing Properties
  • Inserting New Items and Screens

  • Using Actions
  • Distributing the App and using in Mobile

  • Real World Example - Contact Directory

151efa73.png

Meet Your Teacher

Teacher Profile Image

Bash (BizTech Matters)

Online Teaching Excel Expert

Teacher

Hi! I'm Bash and over here at BizTech Matters, I love sharing what I know through online classes, with my over 10 years of IT and teaching experience. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I ensure that I will give you the tools to succeed.

 

My goal is to show you the essence behind on whatever I'm teaching you. Hop in for a fun ride into learning in the technology world!

 

Join me in learning the following this growing list of skills:

- Mastering Top Microsoft Excel Formulas

- Mastering SQL Queries

- Create your own Power BI Dashboard!

- Use Excel Power Query to Clean your Dirty Data

- Use the Top 50 Excel Keyboard Short... See full profile

Class Ratings

Expectations Met?
    Exceeded!
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Learn Microsoft Power Apps Basics: Hi, Welcome to Microsoft Power Apps, the basics. So I just starting out in Microsoft Power Apps. This is what you will learn in this course, are to bother great apps, but no coding. Your apps with your team. And it tends to form your ideas into apps. And so much more to learn our apps now and see you inside the course. 2. Get Power Apps: Hi, This is Brian. Hello and welcome to the wonderful world of Power Apps. To be able to open Power Apps, you just need to go to Power Apps.com. And I already have it open over here for this website. And it's very easy to start. You just need to click here, Start free and all you need is a Microsoft 365 accounts. So when we talk about Power Apps, you can see the description over here. Everyone can quickly build and share low-code apps with Microsoft Power Apps. So the good thing with this one is you can create an application from scratch, okay? And there's pretty much minimal coding required. So it's really designed to make a quick app that's suitable for your needs. And the good thing with microsoft Power Apps is that there's a lot of templates that we will also be going through so that you can have a better idea of what you can make here. You could see right, there's building professional grade apps the easy way, right? And it's very easy to get started over here, as I'll show you throughout the course. Now, once you're ready, I'll click Start free, and we'll go straight to Power Apps over here. So when we talk about apps, right, pretty much there are two main starting points that you need to be aware of. First is the apse, like the application that we will be creating. Alright? And then the second one is the data source. So when we say data source, there's quite a number of options that you could see. Over here. You have the Dataverse, we have SharePoint. If you're familiar with SharePoint lists, right? You could use this to store your data. And we also have Excel. So pretty much if you're familiar with storing your data inside Excel workbooks, that this would be perfect for you. Alright, if you have an SQL database, then you can also use this as the starting point for your application. Because pretty much for your application to work, right, it needs to enter with data and to be able to store or write data or update data, right? You need to have a source. So this are the, pretty much the different sources that you can start with. But the good thing with this one is let's go over here, right? There's more create options if I click on this, okay? So we have different templates as well that you can start with. So once you've decided on which data source you're going to be starting with. You can also have a look here on the different templates that you can play around with. Like if you have a specific need, right, then you can just start here and then customize asked you go along. So there's quite a number, let's say with this budget tracker as well. Okay, You could have a quick preview as well over here, okay, And then if you want to use this template, if you just go for it, I'll click Cancel. But you can have quite a number of apps that you can see over here, ready-to-use expenses. There's a PDF reader, there's browser as well, right? There's also estimators. There's quite a number. So you could just quickly lord inside Power Apps on what you can create. But what we will do right now is we will be creating an app that's going to be like a phone book. Very simple, right? We want to, Let's say we have a company and have you just want to have everybody's contact in here in this app. And then we can use the app to update the different contexts that we have inside the phone book. And one thing that I want to tell you is that this is best practice to be able to use a SharePoint list when it comes to storing data, because there's structure inside the SharePoint list and there are also no limits when it comes to the number of rows, Let's say as compared to an Excel file. Okay, So for learning purposes, we are going to be using Excel as a Quickstart because it's very easy to just set up an Excel workbook and then store our data in there. But when it comes to setting up SharePoint, you might not have a SharePoint site ready. So we will be using an Excel workbook to just show you the possibilities of Power Apps, and then you can work from there. So another limitation as well to keep in mind when working with Excel files is that when we have the Excel file opened, it will be locked to that specific user. So just keep that in mind when it comes to using apps with Excel data source. 3. Create Excel Data Source: Now when it comes to our next step, I know you want to create an app right away, okay, I know you're excited, but before we do that, we need to work first with Excel, because what we need first is to set up our data source. So as discussed, we are going to be working with the Excel workbook. So we need to create this, and it's very easy to do so. So I'll jump straight over here. We have office.com open. So you can see, right, we can just create our Excel workbook from here. I can go for a new blank workbook. Or you can also go to OneDrive and then just create your Excel workbook in spine. Now what I have open right now is I already have created a blank workbook. Okay. These are contacts. This is like our phone book over here or like a directory. And what I want to work with is pretty much this field. Let's say let's have FirstName, LastName, and we have our e-mail address over here now. Okay, So pretty much, pretty simple, but it's up to you if you want to add more fields details, feel free as well. If you want to add the phone number or whatever that you need, like details regarding the employees or team members, then feel free. And what I'll do right now is I'll just add like a couple of rows of data over here. Let's add John over here. Okay, and then I'll add, my name is, well, okay, so we have couple of rows of data setup. And one thing to take note off is for Power Apps to work. You need to have this formatted as an Excel tables. So to be able to do that, I'll go to Insert and then I'll go to table. And my table has headers, and I'll click Okay, now we have our table ready and then let's just go over to Table Design. It's certainly named as table one. But we can also change this to say to contacts table or let's say contact table. So we can just rename this as well. And then once we have everything ready, you have your data source. And now we can continue working inside Power Apps. 4. Creating the App: So now we will be jumping over to the exciting part which is creating our app. But before that, I just want you to have a quick look over here. This is our data table and this are the fields that we will be working with. First name, last name, and email address. Because you will see on how Power Apps we'll be using this in creating our first app. So now I'll jump over to Power Apps. Okay, since we have our Excel workbook ready, I'll select this right now for Excel. Okay, and then what will happen next is we will look for the Excel workbook that we have created and then select that and Power Apps. We'll do the rest. Now, I already have a connection to my OneDrive account, so we can do that as well. You could just go for new connection and then have it connected to your OneDrive. Once we have that, you can see over here, right? We have our contacts, like Excel workbook over here. So I'll select that as well. And then you could see that it's able to see the contact table inside our workbook. This is what we have named it a while ago. I'll just jump straight here and go to Table Design. And you could see the name ask on TAC table. So Power Apps is able to read that. And then we can just select that table so that this is what Power Apps we'll be working with. Now, I'll click Connect. Okay, and then let's just wait for it to do the work for us. Okay, So now that we have Power Apps ready, you can see our app as well over here. And then next is we will be exploring on what it has created for us. 5. Previewing the App: So now we're inside our app and one thing to take note of is it's able to load the contents of our Excel workbook, which is really cool. So there was snow coding done on our part. It's done everything by Power Apps. And one thing to take note of is, for example, if your app right now doesn't have data inside, then this brings me back to the point that I've raised, right? That when it comes to having your Excel workbook open, make sure it's closed. Because let's say if it's open in another tab, the Excel workbook, Right, Then Power Apps won't be able to access it because it's locked to that specific tab. So it's very important to have it closed, right? And then Power Apps would work normally are as expected and be able to read your data source. So that's one of the limitations when it comes to working with Excel workbooks. What we can do right now before I'll go through the different details, technical details over here, what I'll do is let's just have a quick overview on what this app can do. So what I'll do is I'll jump over here. You can see this Play button is for previewing the app. You can also press F5. So I'll just click on this and you can just have your app. It asks that you just have a quick look. So we have pretty much like basic function I this in here we have searching. So let's say I'll just type in John over here and you can just filter right away who the different records. You can even also refresh as well over here, right now we have our sorting. So you can just change the order. Swell. We have the plus button for adding a new record. So let's say that's just click Add over here and a new email address. Let's say we have gone though my Excel Online. And then we have John's name over here and then we have built swell now at school for check and it's able to save as well a new record for John Doe over here, okay, And then you also have details so you can click on the arrows over here. Let's say I just wanted to check details off my record over here. And they could just make changes as well. You can click on edit or you can also delete the specific item. Let's say, let's change this to double n. Let's say just pick on submit and go back as well. And you can see that changes are made to our record over here. Actually edit this again just to make it consist. Then you get to see the changes as well to the email address. And I'll go back and we have this as well over here. Now, the question right now, if, if this reflected through our X0 data source. So I'll open right now the Excel spreadsheet or the XL workbook. And you can see that what we have done inside the app, you can see the changes as well made over here. So you can see my name right now having double n and the email address as well. It's been updated. And we have the John Doe entry as well, which is really cool because you have created an app from scratch. There's no coding required, and it has the basic functionality. And it was able to find the different headers or fields that we want to use for our application. We can see that a new column was added over here, which is pretty much a unique identifier that's being used for Power Apps. So you can just ignore that, okay, just to leave it as it is. And you can just go straight back to Power Apps and just continue with your application. Now, don't forget to close this one so that you won't run into issues when it comes to working with your app in here. Okay, So this is pretty much the simple overview on what our app can do. And that's really cool because it's all out of the box provided for you. And what we are going to be doing as well is really going to be making some changes over here. And one of the things is pretty much when it comes to interacting with elements over here, you just click on your inside the app over here. And let's say you just want to change the name, you can just double-click. So what I'm doing right now is I'm double-clicking the texts and say this is our contact. Or let's say this is our company directory. Just type in the name with a different name and you can just go for review again, then you can see the changes that we have made over here. And another cool thing is while we're in this mode, pretty much we're modifying the app. You can also hold the LP. Because right now, if I click on a specific element, right, you can make changes to that. But one of the cool thing with Power Apps is when we hold the Alt key, then it's like it just moves you to the preview mode, which means that you can just go straight. Okay, so if I click on this right, you could just make changes to this bottom. But if I hold the Alt key, it's like we have jumped to preview mode and it will allow you to interact with specific element instead of making changes to them. So I'll hold the Alt key, I'll click on this, right. And it brings me straight to the details page inside, right, for this specific record, for my record. So it is really cool technique. I want to jump from previewing, right? And then you want to edit the elements again. You could just go straight and click out. And I'll click on this button while holding out right now. And it brings me back to the big screen. Okay? And then let's say I want to jump over here and jump back. And it gives me a quick preview of what I'm doing right now. 6. Tree View: Now let's focus on the tree view, which is on the left side over here. So if you have this closed, right, it's very easy to open the preview. You can see this icon over here on the left side. I'll click on it. And we have the tree view. And what I'll do is let me just have this full screen so that we can have a better look over here. Now, when it comes to the tree view, pretty much what we have is the list of different screens and components of our application. So you can see over here, I'll just minimize this. And you can see that we have three default screams that are created inside our app. So we have the browse screen, we have the details screen, and then we have the edit screen. So browse screen pretty much is this one which is showing all of the records inside our Excel workbook. And then we have the details screen. So I'll just click on that right now. And you can see the details that are pretty much don't over here. And we have the edit screen as well. So you can see this editable fields are specific records, so really handy. So we have three different screens over here. And then let's go back to the main screen. And if you've opened this, right, you can see the different elements inside our screens. So for example, if I select Browse gallery over here, you can see this being highlighted. So it's a really cool way because for example, if you're unsure or if you're having a difficult time when it comes to selecting a specific element, you could either go to three view. And then let's say I want to select the search icon. So I'll select this. We have the search icon selected right now. Or you can also do the opposite way in which has just selecting the actual element via the interface. And you can see which item or element is selected inside the tree view. So for example, if I select this button over here, you can see that this is the icon view item. And then you could also just browse through and then see what are the different elements as well for our other screens over here. And you can just play around just to have a better understanding on what is the A1 inside. And then if we jump over into components, we don't have any at the moment, but we will be working strictly with the three screens as well. And I will be showing us well on how we can create our own screen later inside our app. So stay tuned for that. 7. Edit Properties: Now let's talk about editing properties inside our app. So when it comes to editing properties, you might have noticed on the right side over here, right? This is pretty much the properties if we want to customize the elements inside. So for example, let's say we have the company directory over here, right? Instead of double-clicking on this, you can just select this element, right? Yes, texts over here, this label. And then we can just jump over to the right side. And you could just have multiple changes done over here. So for example, let's say I'm not happy with this specific label over here is just a generic name. You could also change this to, let's say company directory labor. You just change this over here. And if you notice on the right side, okay, if I jump over here, you can see that the name of the element has changed because of discipline. So you can make changes as well, okay, so that it's a lot more readable to the human eye. Instead of having technical names on our left over here, we can also make changes. Let me select that. You can also make changes to the text over here, okay, There's different fonts, the font size, or the different styles that you can play around with over here. Now, what we'll do is, let's say, let's try out the different bonds. Let's say we want to change this refresh icon over here, okay, and then you can change the icon. So let's go through the properties. A good Just change this to different eigen that would be more suitable for you. Now, what I'll do right now is, let's say for the Browse Gallery, this is pretty much the Browse Gallery. Write the list that has all of our data over here. And let's see, we're not happy with how this is displaying our data. You can also make changes to that. So if I jump over to Properties, you have the Browse gallery over here, properties as well. Okay, The data sources to contact table. So that's perfectly fine. We have the layout and the field. So let's just have a quick look at our layout. Let's say we have the current setup is title, subtitle and buddy, let's say, let's change this to title. So if I select this, what you can see is pretty much only the email address that's being displayed like that. Because we just want one field to be displayed over here can make changes as well. Let's say we want a title and subtitle. Okay. And then now we have the e-mail and then we have the first name over here. Now, the other change that we can make as well as pretty much for the fields because you might be wondering, okay, I'm happy with this layout. But can I change? Like, okay, I don't want the email to display. I just want the first name and last name to be shown over here. We can make change as well. I'll select edit over here. And you could just change, let's say, I don't want the first name. I want to be shown here, the last name. And then for the title field, I want first name to be shown over here. Now, let me close this and you could see, right, I'll select the Browse Gallery again. And you can see that it's able to take effect right away. We have our first name over here. We have our last name as well being shown to our fields. And it's really easy to do so with the properties over here. So pretty much we have everything set up by a Power Apps, but if you want to have changes made as well, customization and just go over to Properties and then make the necessary changes. And you can just have fun over here, there's quite a number of options that you can just play around. We have the borders, we have the callers, right? So let's say, let's try it out. Let's just see what's going to happen. And you didn't even change color over here. Let's say you want it to be colored green. Hey, have fun, and just add some life to your application over here. So let's say I'm just happy with this color and green as well over here. But there's quite a number that you could just play around with this over here. Just have fun with the properties, and then see what you can come up with your own application. 8. Insert New Item: Now let's talk about inserting new items or new elements into our application. So right now, let's say you're happy with the level of customization that what you have done with the app. But let's say we want to create a new page that our users can navigate to. Be able to do that, we need a new icon on the top over here and then have the users click on the icon. And it's going to bring them to the new Help page or the new screen that we will be creating. So first things first, we need to have a new icon over here so that users can click on that. To be able to do that. There's pretty much two ways you can work with. So for example, we have the Insert menu over here. I'll select that and you have the different elements that can play around with. So for example, let's say I want the icon, the question mark to be inserted to this application or to this screen, then you could just check for that specific icon over here so you can see the question mark over here. Now another way is to go to the left side and you can see the plus sign over here, right? There's the insert up over here. I personally like this better because their search. So let's say I just want to go straight to the point. I could just type in the question mark. We have the icon over here, but you can also use this to have a quick preview on the different options. There's quite a number that you can play around with. It comes to the variety of elements that you can use inside Power Apps. So let's go back over here. Let's say I'm happy with the question mark, okay? But to be able to make space over here, right, we need to resize this or maybe just change the text to directory so that we can have some space over here. Okay, and then add our question mark to our application. Now I'm dragging the question mark right now. I could just maybe resize this a bit. Then it's very easy to just move the elements so that we can have a consistent look and feel. So once we have this over here, I'll select this and I'll go to our properties over here as well. And then maybe change our color because our items over here are color of white. And we can change this as well to color it white so that we can have a consistent look and feel across the different icons over here. Now, we can also change the name. We have icon one, which is not really helpful, but we can change this as well to let's say health Page icon over here, I'll press enter. And we have that specific elements right now that you can also check inside the tree view. And you can see our Help page icon. It's already added over here. Okay, so we have the icon and you can just change as well to whatever customizations that you would need for this specific elements. But once we have our new element over here, then the next step is to be able to insert our new Help page, which is pretty much a new screen that we will be adding to our application. 9. Insert New Screen: Now let's talk about inserting a new screen inside our application. So what we have right now is we have our icon ready, Right? But we need a new screen. Once we click on this icon, on the question mark icon, it will redirect us to the help page are pretty much like our helps for you that we want to show to the user to be able to do this. It's very easy to do. So we just go straight to Insert over here. Okay? And then you can see the option of new script, so let's select that. And then pretty much inside the new screen, you can start with a blank screen or you can also have a look at the different, like ready-made templates so that it's easier for you to have a starting point. In our case, we would go for the subsets so that we just show a quick message to the user with our email address, for our support, support email address. And then they could just have the user view it. So let's select that once we have this screen, so we're very easy, okay, nothing special that we need to do. I'll just zoom out a bit so that you can have a look at discrete. So nothing fancy, just this specific checkmark over here and the texts. Okay, so this is going to be our Help page. So what we want to do, let's say we want to rename our screen as something more descriptive. So let me just open the tree view. And if you notice on the left side right now, we have our tree screens that we have created that actually Power Apps that's created for us, but this is our new screen right now. So let's say, let's just rename this. It's very easy to sell. And then let's say this is our help screen. Okay? Now I'm renaming this so that it's easier for us like, okay, later down the road, or maybe two weeks from now, for example, you need to make changes. It's very descriptive that you can have a quick idea on which screen is which. Now, once we have this renamed, what we want to do is just add texts over here. So let's say, okay, let's say I need help. Then e-mail us at support at Excel Online.com. There you go. And then you can also change the icon. So pretty much any element that you see over here, I'll just zoom out a bit, right? You can just change them. So for example, I'm going to properties right now. And let's say, let's just change this to a different icon. Say, let's search for posts. So if you just make changes and then if it's a bit small for you can also make this larger. So let's just make some minor changes dirty. And you can also drag and drop over here. Okay, I've dragged the iPhone, so let me just undo that right now. There you go. Then what we have right now is there needs to be a way for the user to be able to go back to our main screen. So to be able to do that, we need to add a bottom. We are going to be going for Insert over here, right? And then there's the bottom over here. Now that's inserted bottom and click on it. And there you have it. Very easy. There's a bottom over here. And let's just align it so that it just looks pretty centered, but it's up to you. Okay? And then for the texts, we can just change this to, let's say, back to main page or screen. There we go. Okay, and then you could just make changes as you see fit. So pretty much you just sign it like what is best for your desired look. So very easy, okay, this is pretty much our Help page. You can add images as well, just make it fancy, It's all up to you. And the next thing that we need to do is to add functionality so that our bottoms will not work. 10. Actions: Now let's talk about actions. So pretty much we have all of the components compete because if you go back here to our browse screen, we have our question mark bottom, right. And then ideally, the plan is, once you click on this question mark button, it will redirect you to the help screen over here that we have just created. And then clicking on the button over here would bring us back to our browse screen. Yes. All of the components are there, the new space, are there Still one missing link? How do we add the action or the interaction that once you click on this button, it will bring you back to the browse screen. So this is where actions come in. So to be able to add an action, this is like adding the interaction or interactivity when it comes to our elements. So to be able to do that, it's very easy. There's this section over here called action. So if you select this, right, There's different options that you can just try it out. But for our purposes, for this question mark over here, very easy. We just need to go to Action and then select navigate. If I select this, right, if I select the navigate action over here, you can see that there's a drop-down. There's pretty much which screen do you want to navigate to? So given our question mark, what we want to happen is once our user clicks on this, you want to navigate to our help screen, right? Then there's pretty much different transitions as well that you can just try out on how it would look like right now. It's selecting faith by default, so we're okay with that. I'll just select that. And you're done. If I select on this, you can also see on the top right, but it's pretty much in the form of a formula. So if you're familiar like formulas in Excel, then this is pretty much familiar territory for you. So you can see over here, right? Navigate. And then it's telling to go to the help screen. And the type of transition is faith. So it's like explaining this in plain English in a way, right? And it's fairly easy to read on what it is trying to do. But if, for example, you're having difficulty with a specific formula or specific function, then it's very easy to just look for the help page for this one. So for example, if I want to check out Okay, For navigate, right? You just select different categories of the functions and then you can just search for that specific function as well that you want to experiment with. So it's a really cool way because if you click on this formula button over here, right? It just brings you a whole list of different formulas that you can use in Power Apps. So for example, let's say you want to use a larger bell, right? Or an action over here. Because for example, let's say you want to check out the navigate action over here. You can just find it and there's a quick description on what it's going to do for you. And then if you click on Learn More which we will be doing in a short while, it will give you more detail regarding that specific formula so that you can just have a better understanding on how to use it. Okay, So that's pretty much for this one, for the question mark, we're good with this, but there's still one missing piece that we need to do. So let's jump over to the health screen, right? And then for this specific button, we want this to navigate back to our browse screen. So to be able to do that same action that we need to do, action over here, select navigate, and then which screen do we want to go back to when you click on that button? Browse screen is the one that we want, right? And then if we select this right now, you can see that our formula over here, It's navigate back to the browse screen and we're using the faith and station. So it's looking good, which means we have all of our actions ready. But the good thing with this one, right, is we're not just limited to the navigate actually, if I go back here, okay, what you can do as well is once Power Apps has generated this app for us, you can also learn from their outer bottoms on what it's trying to do or specific item. So for example, if I select the US right now, right, you can see the Refresh icon. And if we have a look at the formula, you can see the refresh formula being used. It's refreshing the contact table. And if we jump over to the sorting, then you could see that the sort descending, which order is it trying to start with? If we select the plus icon, right? It's saying that it's trying to open the new form, which is the editing form right now. Okay? And then it's going to be navigating to the edit screen. So there's a lot of moving parts over here, but you can also learn by dissecting on what Power Apps has created for you. And then if you don't understand a specific formula, that is very easy, we just jump over to the help page right now by looking for the specific formula and then selecting learn more. So what I want to show to you right now is let's just jump over to the help page already. Have it open right now over here, right? And then for the help page for Power Apps, there's quite a number of formulas over here. So there's a lot of them, right? And it's a good thing because you can now understand better which functions are possible inside Power Apps, like what are the different types of functionality that you can play around with when it comes to forming us now that's selected navigate formula over here. And if we have a look right now, right There's the explanation and then the arguments on what it's passing. And the cool thing as well, even the transitions, they have a preview, like a quick preview for each specific transition so that you can select which one, Like what's going to happen when you transition from one screen to the next. And the syntax and different examples as well on how we can use this specific function or formula inside power. So HEPA, look at this page, is just quickly go to learn more over here. And you can just learn a lot of what you can do inside Power Apps. Okay, so now we have all of our actions set, but the most important part is to be able to test out our new screens, right? I'll renew actions if everything is working as intended. So to be able to do that very easy, we just jump over to the preview. You can press F5 as well. I'll click on that. And then let's test out our Help page. So you can just select back to my screen, right? And it has now transitioned or navigated back to our me browse screen over here. And then let's just try out the question mark. If I click on this, it goes to our help screen. Okay, so everything's looking good and you can just have a quick test right next, selecting the records just to make sure that everything is working as intended. And if I select the plus button is still working. Good, then I'll select the Help icon again, back to my screen. So make sure to test everything out as well. It's very easy to do so inside Power Apps by just selecting the preview option. 11. Additional Options: Now let's go over the different additional options that's enabled inside Power Apps. So let me just close the tree view and then let's open this up over here so that you can have a better look over here inside data, pretty much the different connections, right? When it comes to loading our data, you can see it over here. We have the contacts table right now to our Excel workbook. And you could just make changes to your data sources over here. Now, let's jump over to media. So you can also upload your own images, videos, or audio files so that you can use it inside your app as well. One of the cool things is integrating with Power Automate. So you can also create new flow, right? And then you can add that automation to the app that's going to be triggered. Okay, over here. Okay, so if you haven't checked out my Power Automate course so that you can also have an idea on how you can integrate other applications. So it's like opening a whole different world on what you can do inside Power Apps. And then for advanced tools, which is out of scope for this course, we have monitoring and tests over here. Okay, so have a quick look at the different options inside Power Apps. 12. Save and Distribute the App: Okay, so now that we have our app ready, we have tested everything. Everything's working great. And we are happy with all of the screens that we have created. Okay, so the next logical step is to be able to save our app. So that next time around we can just continue our work over here. So to be able to do that, it's very easy. We just go over here to File and then you can just select Save. And there's also a version notes so that you can just type in on what are the changes that you have created, last saved. So that is very easy to just understand on what are the changes that you have done over time. So once we're happy with this, I'll click on Save. And it's going to be saving it straight to Power Apps. Now, the next step, because the good thing with this one is it's also possible to share our app with multiple people. So for example, if you have more people in your team, it's not just you working on developing this app or designing this app. Then you can also share this with people inside your team. To be able to do that I'll select Share is gonna be opening a new tab for me. And then this is where I can now start adding more people or users to my team. That's gonna be like updating this app. So you can see over here, right, There's add people as users and co-owners, right, to your app. Now, there's one important reminder that I want to emphasize with you. It's making sure that all of the data connections, right, your data sources, it has to be shared with all users because what we're sharing over here, right? So for example, I'll just type in John's name over here, right? What I'm doing right now is I'm giving junk axis, but this is for the app only. So it doesn't include the Excel file that we have used and also the OneDrive. So just make sure that John or whoever specific user that you are sharing to make sure that they also have data permissions to the different data sources that you are using for data specific application. Okay. So with that out of the way, right now, John is simply a user for this app, so meaning that each can use the app I have created right now. But if I select this, I can make him a co-owner. So you can see over here, right, can use edit and share the app, but not delete or change the owner, right? But right now, the cool thing is you can have multiple people working on the design of your application so that it's not just you, it's now a shared responsibility amongst your team, right? When it comes to improving the application. So it's very easy to do that over here in Power Apps, which is a cool thing when it comes to the sharing options. Now click share, and it's not updating the permissions. And then the cool thing right now is gone, can now make changes. The application as well. No, I'll close this. And another option as well when it comes to distribution, right? I'll go back to apps so that we can have a look at our app that we have just created and updated. This is the one. Now if I select this for distribution purposes, you can also export the package, right? And you can also add to Teams over here so that more people can be exposed to your application. Okay, So that's pretty much it when it comes to saving, sharing, and distributing your application. And one more thing is one important thing that you need to do once you have seen the changes that you have made to your app to make sure that gets reflected right, you need to click Publish once you're happy with this, so that it now gets reflected throughout the different people who are using your app. So you need to publish this version. And once we're happy, right? Power Apps will do this for you. 13. Mobile App: Now the cool thing is Power Apps also has a mobile application so that you can just open the apps that you have developed or treated inside your mobile phone. So when it comes to mobile, okay, you're not just limited to the specific OS, so pretty much Android or iOS. If you have an iPhone, you can pretty much use Power Apps as well. So I have no installed Power Apps and I have logged in as well to the same account. So if I go over to all apps right now, you can also see the one that we have created, this specific app. Right now, I'll just select this and it's going to be opening the app right now. And over here, you can see pretty much all of the functionalities are the same bottles that I have created over here. So we have our list I can just sorted right now. I'm just tapping on my phone. Okay. And then I can click on Add that he can see the View record over here, k or x over here, and just check out the details of my record. Then you can see that pretty much everything is working as intended on how we have created this inside our web browser. So that's really cool. Now, let me just select the question mark as well. Just have a quick look of the help screen that he has created. You can see the texts, you can see the icon and our bottom. And let me just test the back to Main Screen button and see if it works. Okay, So that's really a cool, okay, everything is working as intended and you can just have as well, like different team members that you have shared too. They can also install our apps to their level faults and use the same apps that you have created together. And the cool thing is, if you know Power Automate and you have integrated like specific functionality inside Power Apps than the possibilities are endless. And I hope that you have enjoyed Power Apps and have seen a glimpse of what it can do for you. 14. Thank you and Congratulations!: Thank you and congratulations on completing this course. So I hope that this has helped you learn microsoft Power Apps basics. So you're also able to leave a review on this course. So just by clicking on the reviews link over here, and you will have the live Review button enabled for you. So simply click on the link or the button to be able to leave a review. So please, please leave an honest review. As I would love to hear your feedback. You can also check out my profile for more Microsoft related courses by simply clicking on my name, this link over here. And once you have clicked on the link, it brings you to my profile and you're able to continue your learning journey by going through my top microsoft courses.