Flow needs to run twice in total (different days and times)

[Gizmo73]

Hi,

I have a flow that works and I need it to run once on Wednesdays at 4.30pm and once on Thursdays at 10am. Only those two instances.

From what I can see in Recurring schedule, I can select 10 and 16 (hours) and 0,30 (minutes) but that will run more than the 2 required times. My workaround is I've duplicated the flow and changed the schedule and now the flows work at the intended times. However, it does mean if I need to amend the workings of the flow, I've basically to edit two flows. 

I'm sure there has to be a way of scheduling the one flow to run at those two times instead of two flows at one time each. Going forward, it would be much more efficient.

Any ideas would be greatly appreciated.

Thanks.

[creativeopinion]

@Gizmo73 You'll need to add a delay to your flow based on the day of the week. Since your trigger is set to run every Wednesday and Thursday at 10 am and 4:30 pm, add a condition to check to see what day of the week it is. if it's 

Get Day of Week for Today (optional)

To help you to better understand the logic of your flow, add a Compose action to store the current day of the week. I like using Compose actions to output parts of my expression to verify the output. This is especially helpful if you are new to writing expressions. 

You need to use the dayOfWeek() function. This function accepts a single parameter:

dayOfWeek([timestamp])

For demo purposes, I've used the utcNow() timestamp.

Review the output. Today is Thursday. The day of the week = 4. Sunday = 0, Monday = 1... etc. I cover how to use the dayOfWeek() function in this section of one of the tutorials I've linked below.

Use a Condition action to check and see if the output of the Compose action is equal to 3 (aka Wednesday) then add a Delay action. This way the flow will delay till 4:30 before continuing on with the other actions in your flow.

You may also be interested in these YT Tutorials:

7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️

In this section, I'll cover how to get dynamic content with an expression when the dynamic content you need isn't listed in the dynamic content menu.

In the full tutorial I cover 7 functions you need to know when getting started with expressions.

1️⃣ empty()

2️⃣ coalesce()

3️⃣ equals()

4️⃣ if()

5️⃣ concat()

6️⃣ length()

7️⃣ split()

I cover how to use these functions in expressions and I’ll also cover common mistakes when it comes to writing expressions and show you a few tips and tricks along the way.

As a beginner or even an intermediate flow builder—expressions can seem a bit complex at first, I’m going to try to simplify it for you. If you want to level up your flows by writing expressions—keep watching!

IN THIS VIDEO:

✅ What is an Expression?

✅ What is a Function?

✅ What Does Wrapping a Function Mean?

✅ How Do I Insert an Expression?

✅ How to Use a Compose action

✅ How to Navigate the Expression Builder with Arrow Keys

✅ How to use the Expression Tooltip

✅ Common Mistakes When Writing Expressions

✅ How to differentiate a null from an empty string

✅ How to Get Dynamic Content When it’s Not Listed

✅ How to Use a Get Item Action to Verify Dynamic Content Output

✅ How to Convert Strings to Lower Case

✅ How to Troubleshoot the if() Function

---

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[Gizmo73]

I took a different approach. I got the date (utcNow), and from that, I extracted the day, the hours and minutes. I then concatenated those 2 results and in a condition, checked if the output was either Wed 16:30 or Thu 10:00, then continue otherwise cancel the flow.