Trigger flow on every first Tuesday of the month

(0) Share

Report

Posted on by elleeyl

121

Hi Community,

I want to send an email out with MS Automate on every first Tuesday of the month at 11am. This email acts as a reminder to the coming Saturday's activity, and hence the email header and email body needs to indicate the date of the first Saturday of the month.

What I had done below is just something very simple - it will send out an email, be it if the coming Saturday is the first or the last

Saturday of the month. Also there is no indication of the coming Saturday's date. Kindly advise. Thank you.

Categories:

Building flows

I have the same question (2)

All responses (8)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Hi @elleeyl ,

I would make a test and reply here one I could find the solution.

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Hi @elleeyl ,

Please refer to screenshot below to create the flow:

The first expression in the condition as below:

formatDateTime(addDays(utcNow(),-7),'MM')

The second expression in the condition as below:

formatDateTime(utcNow(),'MM')

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
elleeyl 121 on at

Like (0)

Report

Hi @v-alzhan-msft ,

Thank you for your help. 1 more question: Is there any way to show in the email subject the date of the first Saturday of the month?
Thanks.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (1)

Report

Hi @elleeyl ,

I think it could be achieved.

If your original problem has been solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

And you could create a new post for the second problem and you could get help quickly.

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
TheBadger 4 on at

Like (0)

Report

Hi Alice:

If I want to do the same for the last Friday of the month, what do the expressions need to be?

Thanks

Was this reply helpful? Yes No
TheBadger 4 on at

Like (0)

Report

Hi Alice:

If I want to do the same for the last Thursday of the month, what do the expressions need to be?

Thanks

Was this reply helpful? Yes No
Krupa Mehta 2 on at

Like (0)

Report

you can set interval of 28 days, frequency will be Day, Starting date will be your last Thursday Date.
in my case, I was started from Tuesday, for every Last Tuesday of month.

Was this reply helpful? Yes No
Amibr 7 on at

Like (0)

Report

Dear Alice,

I am sorry to bumb this old solution, however, I cannot recreate the steps described here.
As I am rather new to power automate I assume it is me doing something wrong.

Could you help me out? I also need to send out an email every first thuesday of the month.
I need to figure out how to add the expressions in the condition. The image seems different than what you posted.

KR

Was this reply helpful? Yes No