PL-100 Microsoft Power Platform App Maker – Create Power Automate flows Part 2

3. 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 when data is changed. So we’re talking things like SharePoint, Dynamics, Outlook, and in this case the data first. So I’m going to call this my database flaw. And you can see choose your flaws trigger. Lots of triggers here. SharePoint. RSS. That’s a blog feed. Gmail Teams Azure DevOps.

So I’m going to look for the data verse. And so you can see here when a Raw is added, modified or deleted. So using the Microsoft data verse. Not the Microsoft data verse legacy. So I’m going to click create. So I need to sign in to create a data verse connection. However, it’s going to check whether mine is sufficient. And yes, you can see. So let’s fill in the gaps. So what happens when I create a row in the table and I’ll go down to the expenses table and then we’ve got a scope. So who actually makes a change? It might be you yourself or it might be anybody, the organization, for instance. So when this happens and here you can see, you can filter the columns, the rows and other things.

Then let’s stick to our email. I want to be emailed. So again, I will put in an email address and this is my data verse role changed. But now look what we’ve got in terms of the dynamic content. Because the previous step was all about the data first. So it’s got things about the role that has been added, modified or deleted. So you can see for instance, the expense receipt. Could that be added into the attachments, for instance, because it is a picture. We’re going to find out. If I type up here expense, then we can see, we can insert into the body the description, the expense Identifier. No, I don’t want that. The expense value, the date of the expense and so forth.

So I’m going to put this new data received. So I’m going to now save it. So you can see saving and it’s ready to go. And if I go into my floors, there it is, a five second ago automated flow. So what I’m going to do now is go back to my power apps. I’m going to just insert this directly into the table rather than using the power up, make sure I’m in the right environment. Always the case with the power platform, PowerApps, power automate. So I’m going into the expense, going into the data and I’m going to add a new record. And you can see when I add a new record. What this has taken me into, this has taken me into the form that we have previously built when we were looking at the model based app.

So this is going to be ID of expense, the account, the expense value. So nine, nine, nine. And you can see that unhides the description. I need to put the description here because the other one is locked.

So this is a fairly big purchase. And you can see also that you can get flaws running from PowerApps, model driven flaws as well. So I’m going to save and close that. So that has now been added. And if I refresh the data here we are, nine and 99. Let’s go back to Power automate. And I want to see the run history. And here you can see it has run 5 seconds ago, but oh, status failed. So these are important. You need to know why it has failed. And you can see it’s failed because the attachment didn’t work. So it’s important that you can look at the floor runs and go, oh, yes, we got a tick there, or check mark, but there we’ve got an exclamation mark and something has failed.

So you couldn’t have found this out by looking at the floor checker because it’s like syntactically. It was correct. So what do I mean? Well, suppose I had a sentence in English. The ceiling elephant is on the roof. Okay, that makes syntactical sense. It makes absolutely no sense. What is a ceiling elephant? Whereas here we have got the syntactical sense of this database floor. It does make sense. And the floor checker doesn’t show anything. But when you test it, when you run it, nope, does not make any sense. So just double click that a few times, go into advanced options, get rid of that attachment, save it, let’s go back into PowerApps. So we’ve seen that it does work when we enter data directly.

What about when we enter data through a canvas app? In other words, the floor ran. The fact that it failed was an eva hitter there with regards to whether the connection between the database and power apps were working. So what I’m going to do is I’m going to view expenses, I’m going to add a new expense. So this expense was created at a certain day. The expense value was 9998, a fairly big expense. The account, let’s say six coffee. I could add a receipt if I wish to, but let’s just add this. So now that has been created. So if I sort there it is.

So let’s now go back to Power automate, go back to my flaws, have a look at the run history. There we are. 12 seconds ago, it succeeded. So, again, I can click on that and I can see all of the stages that ran. Now, it’s fairly simple at this stage. It’s just the first stage and then the second stage and the third stage. But, yeah, that’s fine when you’ve got just one path that it go down. But later on, we’ll be developing some Power Automate flaws where there may be more than one path that it can go down.

So it’s useful to see which particular path it went down. And if I now go into my emails, you can see we have received new data, received a fairly big expense, and the price and a date. So in this video, we’ve created a data verse floor. We have connected the dataverse with Power Automate. So no longer is your data verse data just sitting there.

And people enter data and delete data, and you don’t know really what’s happening now. You can monitor it. You can have a connection between your data first and Power Automate and know when something has been created, deleted or updated in a particular table. 

4. 48-52. Creating a scheduled flow, tracking Weather using Excel Online

Now in this video, what we’re going to do is create a scheduled or reoccurring floor. So here you can see a scheduled floor. So scheduled floors, they run every X number of months, weeks, days, hours, minutes and seconds. So I’m going to call this weather conditions recorded. What I’m going to do is have this recorded every hour. So I will start, start at a particular time. So I probably will just start it manually. So I’ll start it at say, 03:00 p. m. And I want it to repeat every, let’s say 30 minutes. So you can see in English, this flow will run every 30 minutes. So I will create that. So here we are. I didn’t really wanted to have a start time, so I’ll click on it going to show advanced options and get rid of the start time. So you can see, you can also specify a time zone as well. There’s no red asterisks next to it like here. So start time is optional. So next I’m going to get the weather.

So let’s type in weather. And here we have MSN. Weber Microsoft network. And here we can see in Actions get the current weather. So I’m going to get the current weather. So the location so I’m going to get the location of New York City and see what it makes of that. And I can choose to have empirical units. So those are Fahrenheit inches and metric units. So that’s celsius centimeters. So I’m going to choose empirical units for this. So what do I do with this? Well, I want to save it and I’m going to save it in Excel. Now there are two different types of Excel connectors. Excel online business, excel online OneDrive. Well, I have a business account, you might have a OneDrive account. So I am going to add a row into a table. So it is creating a connection.

So now I have to select a location. You may have had to log in as well, by the way, a document library. Well, that’s not making any sense. Let’s just click on the and I’m in the wrong connection. I want to be in the Microsoft connection. So I’m going to click on that. So you may need to add a new connection if you have to have more than one connection.

So let’s have a look. There’s better OneDrive in there. We have I want the other OneDrive attachments and documents and so forth. So what I’m going to do now is I’m going to go to my OneDrive for business and I’m going to create a new Excel workbook. So this is it, I’m just going to save it as weber it is in my Documents folder. So there it is. Close that up. So look, there we go. Weber excel. And I need a table, so there are no tables in there. So let’s go back into here and create a table. Insert table. And my table is headers. So there’s my table.

And you can see at the top it’s already saved, so I don’t need to save it online. So let’s now have a look at this drop down again, maybe open up this Weber again. And after a bit of experimentation, I had to close it, go to a different file, go back to my original file so it can refresh.

We now have a table, table one. So I’m going to add a row into this table. Now, what do I want to see? Well, I haven’t defined the table well because I want to know what it is I can add. So I’m going to have a look at the dynamic content. So what I want, I want, let’s say the atmospheric pressure, I want the humidity, I want the temperature, and I want the wind speed maybe at the conditions caption. So let’s go back into my weather spreadsheet here.

And so I’m going to have columns for pressure, humidity, temperature, wind speed and conditions. So you can see it’s now saved. So let’s get rid of that. Let’s go to a different document again just so it can refresh the metadata, so that’s the data about the data. Go to this table again and you can see that the columns have updated. So here’s my pressure and humidity and temperature, wind speed and conditions, some of which are badly smoked. So let’s add in the pressure. There humidity, there temperature here, wind speed and the general conditions. So you can also see latitude and longitude and when last updated, and lots of other things. So this now will be adding the raw into the table. So what I’m going to do is save it and I’m going to test it.

So I will test it manually. So you can see this floor uses MSN Weather and Excel online brackets business. So the floor started and in fact it’s run twice. So here we’ve got the pressure, the humidity, the temperature and the wind speed. So now let’s go out of there into my floors. So again, if I want to, I can just run the floor. So let’s see what happens now when I’ve done that.

So you can see we have exactly the same weather. So because it is going to be running every 30 minutes, what I’m going to do is I’m going to pause the recording and I’m going to let it record the weather for a few hours. So it’s now several hours later and you can see we have got a whole host of run history all succeeding. So if I go right to the bottom, we can see we started at 03:08 p. m. , it’s now 09:12 A. m. .

And if we have a look at the spreadsheet, you can see that we’ve got all of these added. So you can see starting off partly sunny, then going sunny and then clear overnight. I think what could expand this quite nicely is if we add the time. So if I go in and add time into this so you can see it’s saved and go back into weather conditions recorded, go to Edit going to here and now we’ve got time.

And I’m going to add into that last updated the date time of which the Provider created the current conditions or provided the current conditions. Save it, test it manually. Test run and we can see changes have been made, fill changes. And so there we go. So in this video, we created a scheduled floor. So we started off with having a recurrence every 30 minutes and then we got the current weather from New York City.

And then we added a raw into a table using OneDrive which could be OneDrive for business or the personal version of OneDrive. And so we got a location, we got a document library, we got a file, got a table, so we had to set up the spreadsheet beforehand and then we could add all of these dynamic contents into the columns and add that as a new raw into the table.