All right.
Welcome back.
So in this video we're going to talk about productivity soar and productivity we can do a couple of
things here.
Copy SharePoint list items and to see us V.
Each week.
Create daily summary of planner tasks by bucket planner task to Microsoft to do task send an email one
planner task is assigned to me notify me in outlook when a student completes a quiz.
Copy flight.
Office 365 outlook e-mails to one note send approval email when a new item is added on new SharePoint
items create planner task and assign a creator.
See more templates here so let's see what else they got.
We can save email attachments to the file system upload file upload files upload photos to SharePoint
folder add planner tasks on Excel our online business spreadsheet on a weekly basis can create a plan
or task when Microsoft forms is submitted.
So this one right here is a good one because what I like to do when I'm messing with my courses and
planning my courses is I like to plan on my weekly tasks so this is a great way to do that.
So let's add planner tasks to an Excel online spreadsheet.
OK so I'm going to continue
OK so we'll give that a second.
So interval is gonna be frequency as well.
Once a week we're going to once a month once a day once in our second hour you can enter a custom value.
We'll keep it to once a week and let's look at the advance options here.
So let's set this to our time zone.
So go ahead set it to your time zone.
I'm going to put mine to Eastern time zone
so let's see where you're at.
Here
OK.
Interest in
I wonder if I can just type in Eastern.
There we go.
Eastern time Okay start time.
So this is we can hide that and just do it like this list.
My task no additional information is needed for the step.
You'll be able to use the outputs.
Okay.
And then here.
So location one drive for business.
The document library will select a document library from the dropdown so we can do one drive.
And then we can select a file so we'll go to course list and then the course list and then select a
table from the dropdown.
So we'll do no items.
OK.
So what I'll do is I'll switch this to sample and then form response and then we'll go here and we'll
select table 1.
OK.
Now when I save this.
OK so that doesn't work that's fine.
So what we'll do is we'll change that.
So let's go to the app launcher.
OK.
And click on one drive open a new tab.
OK.
And what we're gonna do is we're gonna do create a new folder called productivity.
OK.
And then we'll go inside a productivity and we're going to click on new Excel workbook and we'll call
this to do list.
OK.
And then what I'm going to do is I'm going to create here and we'll call this to do.
So let's do tasks.
OK.
All right.
So now that we've done tasks we can go back and we can go to the folder here and was like the file.
So we'll do productivity and we'll do to do list.
OK.
And then we'll select table
OK.
And then we'd save and see if that works.
If not we will refresh this
OK and then we'll select this again just just to reset it because it's not going to work in real time
we're going to refresh your page for it to work which is fine so we're gonna go to productivity will
go to to do list and then we'll go to the dropdown
and we can go to
we'll go to the the to do list here.
All right click we're going to insert sorry we've got to insert and then insert table here.
Okay.
And then column 1 is going to be what we're going to select and our flow.
So now when I close that.
Now when I refresh then it should find this guy
so we'll go here and we'll go to one drive then we'll go to productivity or the to do list and then
we'll go here and we have table 1.
Okay.
Now when I save this we can do the flow checker.
No errors no warnings.
And then we can test the
so it says item do is no longer present in operation to be removed
okay.
So then we can do column
and we'll do for the column we'll do tasks.
So I'll save that.
OK.
We'll we're an item do is no longer President the operation.
Item titles no longer present.
It should be removed before the workflows re saved.
Okay.
So what we'll do is we'll go in here and we'll delete all this.
OK.
I'll just said delete and then I'll save.
And now let's try to push this through as I'll say about
OK.
So now we'll refresh and then we'll try this again.
Sometimes this will happen when you're creating a flow where it's not going to cooperate with you entirely.
It's going say hey you know you're you're throwing errors we need to fix this.
OK.
No problem.
So let's do productivity let's say to loot to do list and then the table.
We don't have any item so we'll just do enter custom value.
And then we'll have to save
the number to test.
So it's going to insert a row.
All right.
So that is productivity.
All right.
So thanks for watching.
I'll see in the next video.