Hello, I'm new to power automate. May i know is there a way, we could schedule the flow to run on a specific intervals such as i only want it to run on every month week 3 Tuesday at 10am, not every Tuesday. If yes, would you mind showing a printscreen of the flow how could we create it?
You can't schedule a recurrence in flow like that currently. You can go to ideas.powerautomate.com and submit an idea and if it gets enough votes it will be considered.
For what you want to do, it will have to be triggered every Tuesday, but you setup the flow to check if it's the third Tuesday or not. If it is not a condition action would contain a terminate action to stop the flow from doing anything further.
What you need to do to make this work is create a compose action and create an expression to with this formula:
dayOfWeek(utcNow())
Then follow the link I posted previously to calculate the week of the month. Once you have those two pieces of information, you create a condition action. The condition you are testing for is the output of the dayofweek, and the week number. So dayofweek eq 2 and weekofmonth eq 3 (day of week could be a 1,2,3 depending on how your system is setup if Monday starts the week or Sunday does, most the time it should be Sunday, but I can't remember if Sunday is 0 or 1)
Hi @srduval , thank you so much for your information. However, I only need the workflow to be run on Week 3 of each month on Tuesday at 10am only, not every Tuesday. Is there anyway we could set this up using power automate? If yes, would you mind showing a printscreen of the flow how to create it? Many thanks in advance.
You will just have to have it run every Tuesday at 10am and have a condition test the current date and terminate if it doesn't match.
dayOfWeek(utcNow()) will get you the integer of the current day, which Tuesday will most likely be 2 or 3.
This should let you check for week of month.
Solved: Calculate the week number of current date within a... - Power Platform Community (microsoft.com)