Pass Your Microsoft Power Platform PL-100 Exam Easy!

Microsoft PL-100 Microsoft Power Platform App Maker exam dumps vce, practice test questions, study guide & video training course to study and pass quickly and easily. Microsoft PL-100 Microsoft Power Platform App Maker exam dumps & practice test questions and answers. You need avanset vce exam simulator in order to study the Microsoft Power Platform PL-100 certification exam dumps & Microsoft Power Platform PL-100 practice test questions in vce format.

Creating a canvas app from a template, and creating one from scratch

6. Practice Activity Number 1 - The Solution

Right, so how did you do? So this is just a general introduction to creating a Power App. So hopefully you've got a power license, an environment with a database, and sample data. So if I go into tables and go into the usertable, you will be able to see that we've got all of these columns set up and we have some data. Now the data that you've got set up may differ from the data that I've got set up. That's absolutely fine. So what we're going to do is create a tablet canvas app. Now, make sure you're in the right environment with this and all the other practise activities. You need access to all of that practise data and tables, and we're going to create them from scratch so I can create them here in Home. I can go to apps and create it there. It doesn't really matter. Now you need to say what format you want. I'm going to have this as a tablet Canvas app. So we've been creating a mobile phone Canvas app. This is a Canvas one, so I'm going to call it User. We'll be expanding it in later practise activities to include devices as well. But I'm just going to call it "user canvas." So let's create, and here you can see things getting ready in the background. It just takes a few seconds and is completely normal. And I'm going to skip this. So now we've got this. Is this the right format? Well, I want it to be in iPad format, which is four by three. So I'm going to go into settings. So there are two ways to go into Settings: Either you can go to File Settings or you can click on Settings up here and then go into the Display tab. So here we've currently got it as 16 by nine, so that's the default. Now you might have a Surface for free, and you might have a wide screen, so if you want to change it to something else, absolutely go on. So click "Apply." And here we can now see we've got a less-wide canvas, and I'm just going to zoom in slightly. So next I need to insert a gallery, so we can go to Insert Gallery. So I can also click on Insert on the left-hand side. And I've got a vertical gallery here. And if I go down to the layout section, I've got all of these different types here. But I'm just going to insert a gallery. So I haven't said what sort of gallery. So go ahead and pick whatever you want. And I want it to be connected to the user table. So I could just type in User, for instance, here. and you can see we've got users here. Next, we need to resize the gallery so it fits the left-hand part of the screen so we can use these little circles so I can do my resizing as I like, and then I've asked you to change the layout. At the moment it's using an image or it's reserving space for an image, and I don't actually have an image, so that's no good. So I've actually changed it to "Subtitle and Body." So that gets rid of the ability to put in a picture. Then I'd like you to edit the fields so that we can add the licence type and primary email address. So we've got the full name at the top. So I'm going to put in, maybe here, the primary email or maybe the licence type. And then here, I'll put in the email, the primary email. So I think I'll switch them around because there's more space at the bottom when it wraps the text. Finally, we need to reduce the font size of this, the primary email. It's a bit big. We can't see all of them down here. Don't forget, we have to click on the top item. We can't simply click on anyone below. It has to be the very top section. And here I can now reduce the font size so I can change it down, say, to 14, or I can change it here in the formula. So here we have 13. And what I can do is just play this and see whether it's of a good size now, and I think it is. In this practise activity, we've got our hands dirty by actually creating a Canvas Power App. From blank. We've inserted a gallery, we've connected it to some data, and we've changed layout and other things. In the next section, what we'll be doing is expanding our original Canvas app. We'll be adding another screen; we'll be adding navigation buttons; we'll be doing things to tidy it up as well. So I hope you're enjoying this course so far. And now let's further reinforce what you have learned by having a quiz.

Expanding our canvas app

1. 36. Inserting a new screen and a card component

In this video, we're going to create a second screen so that eventually, when we click on any of these links, for instance, we will get to the second screen with details about this particular item. So let's go to a new screen. Now you can see that we've got a bit of a selection of screens. So we've got a list one, which is similar to the gallery we visited, but a little better presented. You can see that we have got the start of a search item here. There are so few icons on the search items, and we've also got sorting and so forth. So I'm going to just delete that, and we've got something similar to what we're going to be creating here, a form. So, for example, if I click on a datasource, we can see that we have account name, main phone number, and address, which we can edit by going to the fields and editing fields, and then we can add or remove fields if desired. However, in this particular presentation, I want to do this completely from scratch. So I'm going to delete that scene and just create a blank screen. Now we've got screen one and screen two. These aren't really very good names, are they? So let's rename them. So this is my browse screen, and this new one that I'm just about to create—that is going to be my details screen. So what I want to insert here is a form. So a form is a control, which shows just one record. So on the browser screen, we've seen multiple records; all of the records that we've got in that particular data source here are just one record in a read-only form. So I'm going to click Display, and here it is. So this form isn't connected to any data yet. So we connected the data. So I can click on connected data over here, which will get us to this data over here on the left-hand pane. Or I can use this data source to collect it and save it to my account. And you can see that the computer has automatically added some fields. So I'm going to click on "edit fields" because they're not the fields that I want; instead, what I want is, firstly, the address right at the top. So I'm just going to drag that up and then the main form and then the account name. So that's what we've got in our previous example, the one that the computer automatically created. But I'm going to add a few new additions. I'm going to add country and country region as well. And I'm also going to add email. So having done that, you can see we've got all of these items here, and if I click on this arrow on any one of them, you can see what it is primarily for: text, phone numbers, email, or rich text. So rich text includes formatting. So main phone at the moment is for text. I want to change that to a phone number email. It's correctly identified that it's a viewing email. So let's just drag that down a bit. So this is my record. And if you can't see it, by the way, if you can't see the screen sufficiently, you can use the zoom functionality at the bottom. So you can zoom in, zoom out, or we could even fit the window if you so wish so that you can see. The computer thinks it's a bit smaller than what we could do. So if I go back to the treeview, we now have a browse screen. And if I play or click any of these, nothing happens. Similarly, I've got a detail screen and this detail screen. If I don't play an item to display, the computer doesn't know how to connect the two. So let's do that. Now, let's click on the card. So don't click on the screen. So we've got a detailed screen, but I'm going to click on the form itself. So it can be a bit tricky to actually click on the form. So I'm going to go into the tree view and click on it there so you can see that it has all of these components in one form. And I'm going to now go to "Advanced." So I said we didn't need the Advanced earlier for labeling. We do now. And because I've got the form shown, I can go into the data. So we've got Data Source, which is accounts, and then the item. So what particular item do we want? Well, let's go back to the browser screen. I want to click on any one of these items and go there. So I click on here, and it gets selected. Where is he here? Here is the gallery. Now, if I were on the very topitem, then here would be the next arrow. But I want the parent of that I want where this is contained. So we can even go to Gallery Two, for instance, and click on that. And it's the same when we are looking at these individual cards. I could click on the formhere as well, in the breadcrumbs. So what I want is the gallery. Two selected. So if I start typing in Gallery Two Dot and the very first item we get is okay, the computer thinks, "Okay, these are the ones that I use the most." So I can just use the down arrow and press tab to autocomplete. And now look what's happening. The computer is taking an item in Zoom—the one that I previously selected from Gallery Two—and giving me the information. So I'll just make it a bit bigger. So if I were to go back into Gallery and select something else, would this work? You can see that is not sufficient for selecting it. If I return to my browsescreen and select City Power and Light, Is that sufficient to change it? And you can see Yes, it is. We've now gotten city power and light. In this video, we've created a form on the second screen, and we're using dot Selected to go back to the Gallery and see what has been selected to get the right row of data. However, this is a clunky way of working. In the next video, we'll add some icons, and then we'll be able to navigate and go back between these two screens.

2. 37. Using formulas in non-English locales

Now, before we move on to the next video, I'd like to discuss what happens if you're in an English locale, such as the United Kingdom, the United States, Japan, and so on, and a non-English locale. So when we talk French, German, or Spanish, we're not talking, of course, necessarily about the language you speak, but rather how your computer is set up and how power apps think your computer is set up with regard to your locale. So we basically divide this into two categories: English locale and non-English locale. And you can see how important it is for power apps in just a moment. Now, we're going to be talking about a function called "navigate" to be able to get from one screen to another. So in Spain, for instance, the word "navigate" is "naviga." However, you still use the English functionname, I'm afraid, wherever you are. Now. It's not like Excel. Excel does translate to formulas; PowerApps doesn't. Now, if we're looking at the number 1234 in English, we use a comma to separate them. In non-English locales, it's a dot. Now, we don't actually use thousands of them in power apps, but it's important to know what's going to happen with decimals. It's the other way around. So if I wanted to say three and a half, then it would be three dots, five, and three commas, five. In nonEnglish locales, this means that the comma has already been used. So, if I have two arguments, say I have the navigate formula again and I'm navigating, and it takes two arguments, sometimes one, sometimes two. So we have argument one and then a comma and argument two. However, the comma has already been used in the nonEnglish locale to separate the integer from the decimal. So we can't use the comma this time. So instead, what we have to use is a semicolon. Now, here's where it gets even more complicated. Navigate one and another formula next to it if I have two formulas like this. So we have Formula One and then Formula Two, all reacting to the same event. We have a semicolon separating them, but we've already used the semicolon. So what do we use here? Well, we use two semicolons. So hopefully, you can see that there are some differences. Comma, two semicolons—that is done in Excel, but semicolon to two semicolons isn't. So throughout this course, where you see a dot, it's a comma. In a non-English setting, where you see a comma, it is a semicolon, and where you see two semicolons, it is two semicolons. Now, that's not necessarily the case with stringliterals or any strings inside text, like speech marks. So if you were to look at this formula, for instance, you can see we've highlighted all of the various things that need to change in a non-English locale. So we got a 1259 comma, and then another comma, and then the semicolon, and then lots more commas. So in a non-English locale, this would change to twelve commas, 59 semicolons, two semicolons, and then single semicolons. So if you're in an English locale, feel free to copy what I'm doing. If you're in a non-English-speaking country, I'm afraid you're going to have to translate just a little. So the actual function name will remain the same. If I use any decimals, then that will need to change to a comma. Commas change to semicolons, and a single semicolon changes to two semicolons.

3. 37. Using the Navigate and Back functions in the OnSelect event

Okay, so now we need a better way of connecting these two. They are connected, but I can't use them. So what I'm going to do is go on to the next arrow, and you can see what it says on select. When it's clicked, then I want you to do this. I want you to select the parent. In other words, I want you to run the OnSelect of the parent. So what's the parent of this arrow? It's the gallery. Okay, so why do I do that? Well, if I click on here, let's see what happens. When I go to "select," I select the parent. If I click on here and go to OnSelect, let's see what happens. I select the parent, and you can see that here in the advanced control. So wherever I click, as long as I'm clicking somewhere in this area, I will be selecting the parent, or it will take me there. So what do I need to get through to this detail screen? I need to navigate. So the key word there is "navigate." And then I've got to say where I want to navigate to. Well, I want to navigate to the detail screen. So let's have a look at that again. Navigate, open the bracket, view the detail screen, and close the bracket. Now you can see that the computer has put the keyword "Navigate" in blue and put "Detailed Screen," which is one of my screens, in italics and purple. You don't need to do that. The computer does it all for you. So now let's see what happens if I click on this arrow for Fabricum Incorporated. We now have Fabricum incorporated. Okay, how do I get back? I can't, okay? That's not good. So I might need a back button. So let's insert an icon. So do we have something that looks like a back button? Well, I suppose this left icon is pretty good. So I'll put it up here and on Select. What should I do? Well, I can navigate to the browser screen. So let's see if that works. So I will play this. Click on the arrow. So here's my fourth coffee sample. and go back. Click on Blue Yonder Airlines. So I don't have to click on the icon, but the icon is handy. This is why you should click roughly, because it's not necessarily intuitive to click on the telephone number. But as you can see now, these two are connected. What I'm going to do is make sure that account name is right at the top. So I'm going to return to properties and edit fields. I'm going to drag my account name right to the top. Now these are all labels. And what I want to do is go to this particular label and make it bold and red or something. But at the moment, I'm getting a card. So a card contains a title and the value for one column. If I want the label, I have to click again. So if I click on here, this will give me the card. If I click again, it will get me the label. So I want this particular label to be, let's say, red and a bit bigger. Maybe put it in bold, actually, and make it a bit bigger. So now let's have a look click.So now we can really see the fourth coffee sample, big.Maybe I don't need an account name there. I can delete it. So I will go into my Details screen, click on the label, and I can't seem to collect or delete. It is locked. You can see this lock symbol next to it. So to unlock it, I need to go into advanced, click unlock, and now I can delete it. Alternatively, I could simply make it invisible. But then I would have a gap. So I much prefer to delete it. There we go. However, this gives me a problem if I do that. We've got an X here. Something is wrong. And we've got a little dot over here by this death score. Something is wrong. so I'm not going to do that just at the moment. I'm just going to undo that, and you can see I've made it invisible. Now navigate, then browse green. This is great if I know specifically what screen I want to go to. But suppose I had several screens in my app, each of which went to the detail screen. So I have a browser screen; I have a "here are all the people in Dallas" screen. I've got a specific screen that gives a bit more detail, and I can click on that and go to the detail screen. The trouble is, now if I navigate to the browser screen, I'm always going to the browser. Is there a way just to allow me to get back to where I was? The answer is yes. To do that, I can change this. So instead of navigating, it says back, and you can say open bracket and close bracket. You don't actually need anything in those brackets. So let's just have a look and see what happens. So I click on a particular item and can go back to the previous screen. Now, you may have noticed that the computer says, "Actually, there's something you could put in the brackets, and that thing is the transition." So how do I go from one particular screen to another? Well, the default if I don't put anything is green. Transition none. It just happens. But I can cover it. So I'll cover it from the left or cover it from the right. I can either fade it away or uncover it. So let's just see what each of those does. In principle. We'll go through Cover Left and then Cover Right. We'll just have a look at the cover. So if I cover, I'll use the navigate function for this if I cover.So I go back to the on button. I'll now cover to get to the detail screen. And then, on the detail screen, I am going to unpack. So let's see what happens when I play. So that's a step up from simply saying, "Here it is, here's your new screen." So the alternative to covering and uncovering is fading. So if I put in fading instead, of course, you can have none, which is just, here's your screen. So you can see it just fading into the background in favour of the new screen. So I can use that to both navigate and wave at the back. So in this video, we've created a new screen. We've created a screen with a form. The form is made up of lots of cards. The cards are made up of lots of labels. And I've connected this screen to the previous gallery by going into "Advanced" and selecting "Gallery Selected." So this is probably a good reason to actually have a really good name. So I'll call that the Browse Gallery, for instance, and you'll see instantly that if I rename an item, it's updated in all of the formulas that it's used. We've also had a look at the back and used the navigate button to enable us to go in between screens. Navigate, I'm supposed to respond with a specific screen name, but I don't. And in both, I can say how I want the transition to happen, and the default is known.

4. 37. Building an edit screen

Now, in this video, we're going to create a third screen. So this is a screen that we can use to edit what is selected on the browser screen. So I'm going to go and insert a new blank screen. So we're going to rename this as the editscreen, and we're going to insert another form. But instead of the display form, which displays fields in a read-only form, we're going to have an edit form that lets users edit existing fields and add new roles. So here is our edit form, and we're going to do exactly as we did before. First of all, we need the data source, the accounts. We need fields so we can choose what fields we want. So let's say I wanted to add the email address again, so we can just add that, and it gets added to the form. So each of these is an individual card. Within each of these, we've got two labels. But you don't have to worry about all of that if all you want to do is add in an extra field for extra items. All you need to do is click on the form and then go to fields, edit fields, and add fields. and here you can rearrange it as you wish. Now, again, we need to link what we're looking at. So the item at the bottom here is using exactly the same item as before? We're looking at the browse-screen gallery. So gallery two was selected. And as soon as I do that, then this screen populates itself. It operates in the same manner as the Detail screen. Right, so how are we going to get to this detail screen? Well, what happened in the original is that you went from the browse screen to the details screen. I can hold down Alt and click on something to do the relevant action. And now I want to be able to edit it. So what I need here is an icon here.So I'm going to insert an icon. Now, I've inserted an icon here previously, which looks a bit like "go back." It doesn't truly matter what icon I put in. It could be a completely misleading icon; it could be a camera, but it should be something that actually helps the end user understand what it's going to be. So I'm going to click on this one, the edit. So let's drag it over here, and hopefully you know what code we need and where we need it. On the on select, we need tosay navigate to the Edit screen. And you can put in, if you wish, any sort of transformation. Now, you can see that there are squiggly red underlines, so that's telling me that something's wrong. Also, have a look at the X here and the dot up here in the stethoscope. That's telling me that something's wrong too. So if I click on this, which isthe app checker, you can see that thereis something problematic with one formula. So the name isn't valid. I can click on the arrow for more details. You can also see something about accessibility there as well. There are ten accessibility problems. We'll have a look at accessibility later. So the problem is that there is no edit screen. And the reason for that is that I've misspelt it here. So keep an eye out for all of these little red icons, but especially a red dot next to the stethoscope, which is always active when I am doing some editing in Power Apps. So now, if I click on this, or alt-click on it, it takes me to the edit screen. So what I need to do now is, well, I do my edits, but I've got to say, okay, yes, I want to save that. And the way we do this, well, first of all, let's add an icon again. So we'll make it a check mark. And when the onsite act changes this from false to true, False just means, in OnSelect, don't do anything to submit the form. So what form do I submit form?aggregates all the updates in the form control and submits them. In other words, it saves what you've got. So we need to say, "Okay, I want you to save what is in." Then there's the question of what's in. What are we submitting on the screen? The answer is no. And then you can see the computer doesn't like that. What we're submitting is the form. So this form is called Form One. So that's what we need to say. So this is really when, if you are using something like Form One, you need to give it a name. So I'm going to rename it something better than just Form One. Form One could be from any screen. It doesn't know what that particular screen is. Edit form. So let's have a look and see how we're doing. So if I play, we'll have our fourth coffee. I can get the details; I can edit it. I'm going to now change it to "Fifth Coffee," and I've saved the changes. Or you can see the changes worth saving. Oh, and then what? We'll have to go back? Well, first of all, has it actually done it? Let's go back to the gallery. Yes, as you can see, it has saved it. Okay, so now what do we do? Well, I could say it back, but why do I say it back? Do we need another icon to say "back"?and the answer is no, we don't necessarily need that. We could use a semicolon and then respond. Now, as previously discussed, if you are in a non-English locale, then you will need two semicolons. So whatever works on your computer So let's see if this works. So let's go back to the browser screen. Let's play. So I'll click Edit, change this to six coffees, click the check mark, and we now go back to our detail screen. And from there, we can now go back to our browser window. So far, so good. Except how do we know that the changes that have been made have actually been saved? It just submits the form and then goes back, regardless of whether it's been saved. So something's not quite there. So what we need to do instead is find out if it is successful. Now, if it is successful, another event will run. So when a select event submits the form, we then get an event to say whether it's successful or not. That event is in the form. So that event is called Success. So if it's successful, then go back. If it's not successful, your choice You could just say "do nothing." And that is what the standard form does. So let's just quickly go through that again. We have an icon. When I click on it, it raises an event on select, which submits the form. The form is then saved successfully or not. If it's successful, then the edit form runs on success runs.And I've now changed that to go back to the previous screen. So the detail screen runs, and if it's not successful, then failure runs. And so it just stays exactly where it is. Now, suppose I didn't want to save the changes. Okay, let's get another icon, the cancel icon. So this cancel icon, instead of submitform, it's going to be reset form. So bring it back to its original condition and then go back. Now, it doesn't really matter to me whether it resets successfully. It's nice if it is, and it's nice if it isn't. But it's not going to save the changes. and that's the important thing. because then we're immediately going back. So in this video, we've created an edit screen. The screen goes to the detail screen. In this particular case, by clicking on the pencil, we can then edit what we will, and then we can submit the form. And if it's a success, it goes back. Or we can reset the form with the X and then go back.

Go to testing centre with ease on our mind when you use Microsoft Power Platform PL-100 vce exam dumps, practice test questions and answers. Microsoft PL-100 Microsoft Power Platform App Maker certification practice test questions and answers, study guide, exam dumps and video training course in vce format to help you study with ease. Prepare with confidence and study using Microsoft Power Platform PL-100 exam dumps & practice test questions and answers vce from ExamCollection.