Run SharePoint Flow on weekday, weekend, specific day

Ever wanted to run a workflow only on weekdays ?
Or for that matter - execute only over the weekend, run on selective days, exclude holidays ?

When it comes to Power Automate (Flow), the "Recurrence" trigger can be run on selected days from the week at given time.
The traditional way to achieve this was complex, where you find out the current day and check if it is a Saturday or Sunday, accordingly decide to trigger the logic or not.

Start by creating a new flow from https://flow.microsoft.com/.

1. Navigate to Power Automate portal.
2. Click "New Flow".
3. Select "Scheduled Cloud Flow".
4. Provide name and frequency for the Flow.
You can select the days on which the Flow should run from this screen itself, as shown in below image.
Repeat every = 1 week
On these days = select desired days

Flow exclude weekend
5. Click Create.
6. Add other actions to your Flow and save.

Alternatively, you can also use the "Recurrence" trigger from a blank Flow to schedule the task.

1. Select the frequency as "1 week".
Interval = 1
Frequency = Week
2. Expand "Show advanced options".
3. For "on these days", select the days on which you want to run the Flow. For weekdays, select - Monday, Tuesday, Wednesday, Thursday, Friday.
4. Provide the time when you want to run the Flow using "At these hours" and "At these minutes" field.

Trigger Flow on weekdays only
5. The Preview displays when the workflow runs, including day and time.
6. Add other actions and complete the Flow.
7. Test over a week to confirm it runs correctly at defined intervals.

If you want to trigger the Flow only on weekend (Saturday and Sunday), select as below.

This approach comes handy when you need to perform a scheduled activity during off hours using Power Automate Flow and SharePoint, say sending reminders for overdue approvals over the weekend or archive older documents.

Have Questions? Post them here!