Create your first scheduled flow: a Timesheet reminder
You’ve never created a flow before? In this tutorial we give you a step by step on how you can set up your first scheduled flow: “a monthly reminder to complete your Timesheet.”
A scheduled flow is an automation that runs on a schedule: so every week, every month, every 3rd Tuesday of the month,..
Start off by going to https://make.powerautomate.com
If you want to, you can use this prompt and ask Copilot to create this flow for you: “Every month on the last day of the month, send me a reminder to complete my timesheet.”
However, before using a machine to accelerate a craft, we feel its valuable to learn the slower manual version because it exposes the underlying mechanics of the work. This will make it easier to spot and fix mistakes AI might make.
Step 1: Pick the right environment
Before you create anything in the Power Platform, you always need to make sure that you select the correct environment for your work.
This is a flow that we use for our own personal productivity. If we leave the organisation and our flow is deleted, nobody will care, thus, we can create it in the default environment.
Step 2: Create the flow
When you create a flow for your team, we recommend creating a solution first, as this use case is for our own benefit, we will skip that step.
In Power Automate, click on “Create” and click on Scheduled flow to start creating your flow.
Name your flow and set the schedule
As soon as you click the Create button, this window will appear:
Give your flow a name and set the schedule for your flow.
You can schedule a flow to run every second or every minute – though we do not recommend that. You can also schedule flows to run every day, week, month or year.
If you want to run a flow every third Friday, select “week”, which will allow you to select specific dates.
For our flow, we are moving forward with a flow that we’ll run every 30th of the month.
Add an action
Now we have set up our trigger, we can add actions to our flow: What do we want to happen every month?
Click on the + icon below the recurrence to add an action.
Send an email
Next, we need to send ourselves an email.
If you search for “mail”, you will notice that there are many different connectors that allow you to send emails.
If you want to send an email using Outlook, you may be able to do that via Outlook.com or via Office 365 Outlook. Which one is right for you will depend on how the Power Platform has been set up in your organisation.
For our example, we will use the “Send an email (V2) action from the Office 365 Outlook Connector.
If you get an error message stating that you are violating the DLP policies of your organisation, that means that you are using the wrong connector. We recommend reaching out to your IT department to learn which connector you can use.
Configure the Send an email action
Once the action is added, you will need to configure the action.
For now, we will keep it simple, you need to complete all the fields with an *. Just type your email address in the “To” field, add a “Subject” and “Body” and you are done.
Save and Test your flow
Your flow is now ready, click the Save button and test your flow.