How to exclude weekends with scheduled flows using Power Automate

(1) Share

Report

Posted on by POSPOS1

Hi All,

I have a requirement to schedule a Power BI report as a PPT to users every month on 15th.

Requirement is to send on 15th of every month, but if 15th is a weekend (Saturday or Sunday) , then the flow should run on the next week day, i.e., if 15th is Saturday then flow should run on 17th and if 15th is Sunday, then flow should run on 16th.

Can someone please suggest on how this can be achieved.

This is the current flow I have:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Expiscornovus 33,834 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can check the day of the week to check if the 15th is Saturday and Sunday type of day. You could use an expression with the dayofWeek function to check this in a condition an add a delay action of either 1 day or 2 days.

Tom Riha has described using a dayofWeek function in an expression (in your case you don't want to use that as a trigger condition, but in a regular condition action instead):

https://tomriha.com/how-to-schedule-a-power-automate-flow-to-run-only-on-work-days/

Was this reply helpful? Yes No
POSPOS1 8 on at

Like (1)

Report
Copy link

Link copied!

Can you please provide detailed steps in a flow on how to check if 15th is a weekday and then send out an email notification on 15th or the next week day?

Was this reply helpful? Yes No
Suggested answer

trice602 16,135 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

There's a lot of ways to do this, here's the easy path. Check if day of week is Sat, then delay 48 hours. Copy paste, check if Sunday, delay 24 hours...

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Suggested answer

David_MA 14,227 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

I think you can add the following expression as a trigger condition: or(equals(and(and(not(equals(dayOfWeek(utcNow()),0)),not(equals(dayOfWeek(utcNow()),6))), equals(int(formatDateTime(utcNow(),'dd')), 15)), and(equals(dayOfWeek(utcNow()),1), or(equals(int(formatDateTime(utcNow(),'dd')), 16), equals(int(formatDateTime(utcNow(),'dd')), 17))), true)

It checks to see if the current day of the month is the 15th and that it is not a weekend (0 and 6). It then checks if it is a Monday and the date of the month is either the 16th or 17, which would be the next valid day the flow could run based on your criteria.

It will thus either return true if the day of the month is the 15th and not a Saturday or Sunday. Or it will return true if the day of the week is a Monday (1) and it is either the 16th or 17th of the month. Since it will only return true on one of those three days, this should work.

Adjust as needed and schedule your flow to run every day.

Was this reply helpful? Yes No
trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post how to exclude weekends with scheduled flows using power automate in this category building flows from 11/05/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 4 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No