Trigger flow on the third & fourth Friday of the Month & the coming Friday

(0) Share

Report

Posted on by Wong_MR

Hi there, I have a job task where I need to send THREE email reminder to my colleagues.

1. The first one is to be sent on the third Friday of the month.

2. The second one is to be sent on the fourth Friday of the month.

3. The final email reminder is to be sent on the next Friday. (in this case, it could be the last Friday of the month, or the first Friday of the next month, depending on the calendar)

For example, in April 2021, the reminders should be scheduled at 16th, 23th, and 30th of April

In May 2021, it should be 21st and 28th of May, and 7th of June.

In June 2021, it should be 18th and 25th of June, and 2nd July.

How should I code in Flow to schedule this?

Many thanks for your help!!!

Categories:

Business Process Flows

All responses (3)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Trigger flow on the third & fourth Friday of the Month & the coming Friday

Hi @Wong_MR,

The recurrence Flow should run once every month, and the difficult point is to find the first weekday of the current month. Here is a function named dayOfWeek() function, you could initialize it to get the day of week for the 1th of month, if it is 5, it means this 1th of current month is first Friday, if it is 6, add 6 days, if it is 0, add 5 days, if it is 1-4, add (5-x) days.

I export this Flow as a zip file, you could download it and import it into your Flows, then you could test it:

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

Triggerflowonthet...
Wong_MR 10 on at

Like (0)

Report

Re: Trigger flow on the third & fourth Friday of the Month & the coming Friday

Hi Expiscornovus, thank you for your reply. This look ok in April. But I am not sure if this will work in the coming months. In May 2021, could it trigger on the 21st, 28th of May, and 7th of June?

I searched on the net. Shouldn't there be some use of formatDateTime(addDays(utcNow() & formatDateTime(utcNow()? (I don't know how to code it however...)

Thanks
Expiscornovus 32,131 Most Valuable Professional on at

Like (0)

Report

Re: Trigger flow on the third & fourth Friday of the Month & the coming Friday

Hi @Wong_MR,

I would say this should be possible if you would use the once a month schedule and then some delay actions.

Hope this helps a bit?