All Microsoft Power Platform PL-100 certification exam dumps, study guide, training courses are Prepared by industry experts. PrepAway's ETE files povide the PL-100 Microsoft Power Platform App Maker practice test questions and answers & exam dumps, study guide and training courses help you study and pass hassle-free!

Adding Expenses to our app

3. 37. The Filter function - linking the Expenses and Accounts screens together

In the previous video, we added three new screens. The expense browse detail and edit screens have been added. But we got these three other account screens, and they don't talk to each other right now. So, if I begin in the account browse screen, there is no way for me to get to the expenses, but I want to be able to access the expenses from the account. So let's put in a new icon here that will get me to the expenses for this particular account. So let's insert an icon, and we've got just a bit of the way down here an icon relating to money. So let's add some data up there. So this is quite simple; we're just navigating by using the arrow keys to get a little better.

Maybe I'll just have to do that. We are navigating to the expense browser screen. Right, so that seems easy. So what's going to happen on the expense browser screen? I'm just going to change what is being shown here. So at the moment, it's showing an image as well as a title and subtitle. Let's just change that to title, subtitle, and body, and we'll edit things here. So I'm going to say that the first thing is going to be the date of the expense. Let's put that at the top of the list of costs. There we go. So this subtitle two is going to be at the expense of value, and right at the bottom of body one, let's have the description. So if I go into this one, we can see that this is an expense of 345 pounds and a penny. I'm not sure which account it's in. So I'll just add it to the account field and drag it up a bit. This will become important, as you will be able to see. So this is an AdventureWorks sample.

So now let's test this. Let's go back to the account browse screen. So we start with Adatamcorporation, click on that, click on the dollar sign, and we get all of the expenses, and this expense is for AdventureWorks. Hang on, that's not what we clicked on. We clicked on a Datum corporation. So what's going on? Well, at the moment, there is no link between what we're seeing here in the browser screen and the account selection. So we are seeing everything. Now, it would help if I could actually see the account here, but I can't if I click on any of these or click on the gallery itself and go to Fields. There's no way that I can actually get the account. So what I have to do is edit the text here. So at the moment, the text is the item description. Let's change that to "item account" or "this item account." So we're going for this particular item, but then we're going into the account, which is a lockup that takes us to the accounts table, where I can then say I want a particular field in the account name. Okay.

So we can see that this gives us Adventure Works. Whereas if I go through this again, I'm clicking on the Datum Corporation, and I don't want to see Adventure Works if I'm doing that. Similarly, if I'm adding a new value, I don't want to be able to add any accounts. I want it just to be a Dawn Corporation. So let's add that in. It looks like I didn't add a date, so let's just change that as well. So how can I get it so I can only see what I have previously selected? Well, we can do this by using the filter function. So, let's go to Items by clicking on the gallery. And items. Is the table called expenses? So what I need to do is filter this down. I don't want to see the entirety of expenses, so I want to see source expenses and then a logical text. So what is going to be true? Well account. That's our lookup. That gives us access to all of the account columns. Let's return to our tree view now that the account name is equal to. We want the account gallery selected.

So what do we want in the account gallery? So, at the moment that Account Gallery is selected, that gives us an entire row. We just want to compare the account name with the account name. Let's close that down. So now you can see it's only going to show those things that are in the Expenses table, where they look up from the Expenses table into the Accounts table and into the field. The account name is equal to what we have previously selected in the Account Gallery. So now let's test it. I go into a data corporation and click on the money. All I see is a datum corporation. I think we need a back button as well. So let's add a back button. It is fairly easy to do. Insert icons. And let's have a look at the back button on the left. There we go. And choosing is fairly simple. It's the same as switching from an open bracket to a closed bracket. So now, if you test this by going to Adventure Works, we now have the AdventureWorks item. If I switch to blue Yonder Airlines. We now have no items.

So I can now insert a new item, and I still have to select the account. But that's okay. We can solve that in the next video. And now we've got Blue Yonder Airlines working. So in this video, we've managed to have a better flow. So one of the requirements of the PL 100 exam is to describe the user experience. While I want to go from the Accounts-Browse screen to the Details screen and then add or view expenses however I wish, So this is getting much better. The only thing now we need to do is solve the account problem. How can we get the account to be the account that we have previously selected? and we'll do that in the next video.

4. 36. Default and DefaultSelectedItems

In this video, we're going to have a look at where we can go from this browse screen. So I can go to City Power and Light, click on the dollar sign, and click on the add button to have City Power and Light automatically shown in the account. How can we do that? We've seen before that the Account Gallery dot selected is what drives this.

So let's go to this card, this particular card. Now you can see that it is locked. So what does "lock" mean? It avoids tampering. Unnecessary tampering. You have to unlock it if you want to make some changes. Why should you avoid tampering? These fields, edit fields, have added everything. But it's all added automatically. And it's there to ensure that everything runs smoothly. So if I want to change it, I need to unlock it. Just click on "Unlock" in the advanced section. And that's all it is. Now, if we go back into the field, you'll see that this is now a custom card. That just means that we're able to edit properties. However, we can't relock it afterwards. If we want it locked again, then we have to delete it and then read it. So now we've unlocked it. Let's see what we can do. So, let's look at default. So the default here seems to be blank. Okay, so let's put the gallery in your account. Okay, and you can see the data type record.

So let's play this. So going to City Power and Light with the dollar and adding And there we have City Power and Light, simple and easy light. So I will put in the expense value and a description and click on this check. Well, that seems easy. Okay, we'll add another item. Oh, it's disappeared. It's because that's what it was previously. So let's go to the cohort winery and click on the dollar. Select the plus sign. It has not been added. It looked like it was going to be so easy, but no, unfortunately, it was just from the previous time. So that hasn't worked. Okay, so let's go back in here. So, if it isn't in default, it could be in default selected items. Makes sense. It is a combo box. We've got various items to select. So I'll put it here under "Gallery Selected." And here we can see a Cohort wine sample. So let's go back to our Count browsing screen. I'm going to a different one just to make sure it's working correctly.

So, contours or pharmacology, whatever you want to call it, and click on the dollar sign, then the plus sign. And there you have it: contoso. Great. So we'll add in a value, add in the description, click on the check, and there you go. You can see that it has automatically been added. And let's just make sure this works. We're going to get a sample of Fabrica ink. Going back to the dollar. Click on "plus." We now have fabricham ink. And let's put in some things. Click on the check. And there we go. So we have two properties here. So the first property we've got is "default." As a result, the default value of a control. So if I wanted the initial value of these expenses to be minus one, then I could unlock this and put in minus one as the default. However, for things like combo boxes and other things where you can select from multiple values, you might find default doesn't work for you, in which case you need to go to default. Selected items.

5. Practice Activity Number 5 - The Solution

Hello. Well, how did you find this practise activity? So, let's take a look. First of all, I wanted you to go to the Device Editscreen, and I wanted you to add Picture Control and link it to the Device image column so you could go to Media and so forth, and you've got Add Picture. But there is a quick way. Remember, we are using a form. So if I click on the form there, all I have to do is add a field. So having added the device image, you can see that the control type is Add Picture by default. And if I scroll down there, we can see a few times that this is an Add Picture control. So simple to accomplish.

Next, I want you to create a new screen so that you can go to the user's gallery page or the device's gallery page. So here it is. So I'm just going to collapse everything, and while I can't drag it to the top, I can move it up so it's in the right logical order. And I'm going to rename that to the main menu. So it doesn't have to be much. All I'm going to do is put in a couple of buttons. So the first one says "see all users," and the second says "see all devices." So maybe you could stylize this a lot more, have your logo on it, have a rectangle at the top, and say in the introduction that you're welcome to whatever this is. Welcome, users and devices. App So if I put that in the Welcome to the Users and Devices app and have that colour be white, So there's a lot of styling you can do. However, the functionality must be added. So, for this button, navigate to the user details screen, and for this, navigate open bracket; just wait for the computer to present you with some potentially very good options.

So go to the Device Details screen and close the bracket. Next, I wanted you to create a global variable. So if we go to the Devices Gallery page, you would see all of the devices regardless of who owns them. So I need to make a global variable that says I've either clicked this button or this button so that I can say set see all devices. And because this is a set, we now use a comma. So, rather than saying that seal devices are true, I want to say that they are false. I'm using the zero value. It doesn't really matter what value you use as long as you have the correct logic later on, and just looking at the formula, the computer thinks I put the word navigate earlier than I wanted it. So there we go. If we go back into this button, just a few spaces, maybe a semicolon, and I set the See All Devices option. So you can see why I put the spaces—it allows the computer to give me a better range of options. and I'm saying yes this time. I do want to set the seal devices to one as opposed to zero, so you can see the differences between them.

And so in this one, I'm saying set C, all devices. You can see why I added a space so that the autocomplete would work with one. So a positive result, and then a single semicolon or two semicolons if you're in a non-English locale. So now let's go to the device detail screen. And in the gallery, we have this photo function. And that's fine if I have gone through the user screen; if I go straight to the device screen, I want to see everything. So if I can see all devices on one screen, then I want to see everything. What is everything? It's the entirety of the device table. If not, then I want to see just the devices for the selected user in the user gallery.

So let's have a look at this. If I just play, if I go to "all users," then I can see all the users select somebody. And here we can see the devices for that user. Just one device Now, I'll also need a back button here. So this is a great way to just test to see if you're missing any icons or anything like that. So, again, this will just have to go back. So let's start again. Go back to the main menu. So see all users, then click on a particular user. There is one device I can see one device. Go back and look at all of the devices, and there are three of them.

Microsoft Power Platform PL-100 practice test questions and answers, training course, study guide are uploaded in ETE Files format by real users. Study and Pass PL-100 Microsoft Power Platform App Maker certification exam dumps & practice test questions and answers are to help students.