Your daily flow does its job. But it doesn't need to do it on Saturday or Sunday. The recurrence trigger doesn't have a "weekdays only" toggle in the basic UI. One condition block at the top of the flow, one expression, and the weekend runs stop without you touching the schedule again.
How to do it
You've got a flow on a daily recurrence trigger. You want it to fire Monday through Friday only.
- Open the flow and leave the daily recurrence trigger as it is. The trigger will still fire every day. The condition decides whether the work happens.
- Add a Condition control action immediately after the trigger.
- In the left side of the condition, click the function icon and paste this expression:
dayOfWeek(utcNow()). Set the operator to "is greater than" and the right side to0. - Click "Add row" to chain an AND. Use the same expression
dayOfWeek(utcNow())on the left, operator "is less than", right side6. - Move every action from the rest of your flow into the "If yes" branch. Leave "If no" empty.
Save it. Saturday and Sunday, the flow runs, sees the date, and skips. No work, no babysitting, no Monday-morning cleanup of weekend noise.
Why it works
utcNow() returns the current date and time at the moment the flow runs. dayOfWeek() converts that to an integer: Sunday is 0, Monday is 1, all the way to Saturday at 6. The condition keeps the values that are strictly greater than 0 and strictly less than 6, which is exactly Monday through Friday.
The reason this beats fiddling with the recurrence trigger is that the trigger UI handles "every Monday at 9am" cleanly, but multi-day patterns get awkward fast, and timezone behaviour around the trigger is its own footgun. A condition on the day of week is a single source of truth, easy to read in the flow, and trivial to extend if you later want to skip a public holiday or only run on the first weekday of the month.
When not to use it
If your business "weekday" doesn't match Monday to Friday, retail teams running Saturday flows, payroll teams running Sunday-evening flows, the condition needs to match your actual schedule, not the calendar default. And if you need to respect public holidays, day-of-week isn't the right tool: you want a SharePoint list of holiday dates and a lookup, which is a different post.
The full version
For the end-to-end automated report flow that this condition slots into, see Build It: Build an Automated Weekday Sales Report Flow (25 May).