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

Like (0) Share

Report

Posted on 26 Apr 2021 08:15:28 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

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 32,563 Most Valuable Professional on 26 Apr 2021 at 11:40:52

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?

Was this reply helpful? Yes No
Wong_MR 10 on 27 Apr 2021 at 01:47:03

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

Was this reply helpful? Yes No
Verified answer

v-litu-msft on 27 Apr 2021 at 03:03:03

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...

Was this reply helpful? Yes No