All right.
Welcome back.
So in this video where and talk about scheduled flow so you choose when and how often it runs.
So let's click on that and so what we'll do is we'll add a name or will generate one.
OK so let's call this scheduled flow and starting to 21 at 10 a.m..
So let's instead of 10 a.m. much too.
It's 138 right now so let's do two o'clock.
OK.
Actually one forty five.
Let's do one forty five
and repeat every one minute.
That's fine.
Let's create it so recurrent.
So we're going to do next step.
So we'll do the following.
OK.
So we can delete a row.
We can get a row get worksheets let's rows president on the table update a row.
OK.
That's so that's not something that you want to do every minute.
OK.
Send an e-mail notification.
I wouldn't do that every minute.
What we can do is let's do this.
So let's go to settings.
No not that.
OK.
There we go.
One minute so we can do.
Once a month every one every hour every day every week every month.
OK.
So let's do every week runs on Monday Tuesday Wednesday Thursday Friday Saturday Sunday every week.
OK.
We don't want to do that.
Let's do on Sunday.
At these minutes under the valid minute values.
OK.
So we'll do zero.
OK.
And then at these hours we'll do 10 lots more.
OK.
There we go.
Let's do 10 a.m. runs at 10:00 on Sunday every week.
OK.
So instead of every week let's do every month OK.
And then we're in the time zone.
So I'm on the Eastern time zone
so I'll go down to Eastern Time.
OK.
So what we're gonna do is once a month I'm going to get an email
and we're going to send an e-mail notification.
OK.
That's fine.
I click on that.
But what we're gonna do.
I don't know I keep showing that.
So don't worry about that.
I'm going to click on my email address here.
Jay Werner it learned talk plus 20 20 on Microsoft dot com.
I'm going to copy that.
We're going to paste that in here.
OK.
And then we'll do monthly e-mail OK just for the subject.
And then here check out
how many courses you created this month.
So I'm going to give you a perfect example of how we could utilize this.
So what I do is I use I have Office 365 I'm using that right now.
And when I utilize Office 365 I use Excel for my course list.
So every month I want to look at how many courses I have done OK and what I can do through here is I
can set up this scheduled flow where every month it's going to send me an e-mail and say hey make sure
you check out your course list and see how many you've done this month you know to get a total of how
many you've done because what I do is every time I get a course done I go to excel and I add it to my
list.
OK.
But I don't look at the number every single time I just added in there and then move on to the next
thing.
So what we can do is we can add a next step and go to the Excel online business.
OK.
And then what we can do is less rows present in table.
OK.
So we can sign in to create a connection.
And what we'll do is I will create one.
So one drive for business.
The document library will do one drive and then the file
this is what I need to add.
So I'm going to go to one drive real quick.
We're gonna go to files and I'm going to do folder and we'll do a course list.
OK.
And then what we'll do is we'll go inside of course list and I'll create a new file.
OK.
And I'm going to call this course list OK.
So once that opens then we can add course list in here.
OK.
And then when you edit the flow
right here.
So in one drive we're going to select the
solar like one drive.
And then when I click on this it didn't work.
Okay.
Hello.
Let me delete this real quick OK.
And then we'll add a new stop so online business and let's create create a worksheet get tables.
Let's get a table.
OK so the location will be one drive for business and then it's going to be one drive and it will be
we'll move this to
I want to move this to the new flow.
So we'll just put it in here and I'll do course lest I add another course list in here that way it works
because for whatever reason it hasn't set up yet which is all right because I'm doing this on the fly
so it's not going to totally cooperate with me.
But when I click here and I do new flow OK.
Then it's going to load and then we of course last.
OK.
So I save that.
And then what we can do is let's test us.
OK.
So I'll perform the trigger action.
OK.
So let's save and test
or run the flow.
Make sure it's working OK so your flow rate your flow run successfully started to monitor go to the
flows or the flow runs page so click on that
OK.
And you can see it's succeeded right here.
So if you click on it
get tables.
If I click on get tables course list and there it is.
OK.
So if I go to my email and I refresh this
OK it won't show up there but that's fine.
The whole idea of this is every month on the first I want this to pop up.
OK.
So let's go to other first second and just see what this is if it worked in there if it did.
That's OK.
Again this is just an example but it's one that I'm actually going to use myself because this is an
easy way for me to automate myself because
I really am not obsessed with course less.
But what I do is I'll I'll go in and I'll modify my course list all the time.
And so this way it kind of automates me a little bit and says hey don't do this every day do it.
You know once a month.
So let's go to
let's click on Where's the power automate here.
There it is.
So let's open up a new tab here and then we'll go to my flows.
OK.
So you can see it right there.
So we've got the schedule flow there.
We can run it.
We can edit it.
It's scheduled.
OK.
Now you could set this up where you do it once a week once a month once a day once an hour whatever
it is you could do that if you want.
It just depends on what you need to do.
You know there are certain flows that I need to set up for my course creation that I could do once an
hour you know or one today to see where I'm at.
See what I've got done etc..
So I think that this is a great.
This whole program power automate is awesome.
OK.
Because I do nothing but work with flows all the time with everything that I do for video production
and training courses and that kind of thing.
So this is like a match made in heaven for me because I love flows.
All right.
So thanks for watching.
I'll see in the next video.