43. Load or create data records for testing and development Now part of testing or development is to be able to create your tables and then load records into it. So in this video, we’re going to have a look at the various tools that you can load and indeed save data. So first of all, you need to get into your tables. That’s either data table or solution and the relevant solution, and then tables. So let’s go into our Spence table and into data. So here you can…

53. Create a Twitter flow, using variables, conditions and loops In this video we’re going to take the Twitter connection that we used in the Canvas app and we’re going to take 20 or 30 tweets each with a particular word in it. And we’re going to see what languages they are being tweeted in. We’re going to count the number of English and the number of non English. So let’s create a new floor. So I’m going to have an instant and cloud floor because I want to be…

48-52. Creating an automatic flow, using a Dataverse table Now in this video we’re going to have a look at what happens if somebody adds a Raw into a table in the Microsoft database. Can that be a trigger? The answer is yes. So I’m going to create an automated cloud flaw. So automated cloud flaws are triggered by an event. So it could be a new email, it could be a Twitter post, it could be a request for leave and those could be called approval flaws. It runs…

Power Automate Licensing Hello. And in this section we are taking a step away from PowerApps and going into Power Automate. So Power Automate allows us to have certain processes and you can see some of the things that you can do on the screen either when I click a button or when a certain event happens or at a certain time it could be repeated. Now let’s, let’s start by talking about licenses. So firstly, do you have the license to use Power Automate which addresses Floor Microsoft. com?…

43. Saving and loading data records into views In this video. We’re just going to have a quick look around and see what else you can do in views. Well, you can group, so you can group on a particular description or an ID, or when it was created or currency. For instance, you can use this at the bottom to narrow down what you’re looking at. So maybe you’ve got the equivalent of a file effects used to be in the 1990s and 2000 thousands. So look for all…

18, 28. Create and configure Dataverse table views In this video we’re going to have a look at how we can create and configure Dataverse views. And we’ve already used views even though we didn’t know we did. If we go to the PowerApps portal and go to Tables and select a particular table, in this case the expense table and go to Data, that is a view. The view is the active expenses view. There are also a few other views as well and we can see what views…

45. Expanding our Dataverse business rule Okay let’s change this amount to $600 so now we are over a hundred description should appear and no it doesn’t. OK why is description not there? Well the reason is I said what to do if the expense is under 101 said what to do if the expense is over or equal to 100 so I said set the visibility to false. I haven’t said anything anywhere. Well if you change your mind, set the visibility to true so I need now to…

Dashboard – enabling global filters Now in this video, we’re going to have a look at filtering and sorting. So first of all, we’ve got the time period filter here. So you can see if I say last quarter, then this stream changes to the last quarter. If I say this quarter, then it changes again. We have visual filters. So if I load them up, you can see again these visual all filters. These charts are filtered by this time frame. And then if I click on a particular…

Using dashboards in our model-driven app So what can we do with all of this? Well, if I click on dashboards here, we can see that I’ve got lots of different dashboards. I’m not going to select them all. Instead, I’m just going to select the classic dashboard and the multistream and the interactive single stream. Now, by doing that, it quite often adds additional entities. So I need to click on the entity and remove it. The expense here, I have these two dashboards, and I’m going to say…

Create model-driven charts Now, in this video we’re going to create charts from our data and there’s not much functionality in here, so we can create charts by going to the relevant table and going to charts. Or in the app designer we can click on charts and go to create new. So either way we’ll get to this page and it doesn’t give you a lot, lot of functionality. Firstly, what chart are you wanting to create? So in other systems this might be add a chart. No, here…