How to trigger an action on last Monday and Wednesday of the month (if the last week has Thursday)

(0) Share

Report

Posted on by microsoftuser10

Trigger criteria:

- Need to trigger an action (send a Teams message for example) on last Monday and last Wednesday of each month.

- But last week of the month must have Thursday

- If month ends on Wednesday, we use the week prior and send message on that week's Monday and Wednesday

How do I do this?

ps. BTW there's no easy way to trigger an action on the specific last day of the month. Please add this feature in "Recurrence".

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @microsoftuser10 ,

Please create a se flow and set the trigger's condition to to :

@if( and(less(dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1)),4),not(equals(dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1)),0))), or(equals(startOfDay(utcNow()),startOfDay(addDays(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1),sub(-6,dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1)))))),equals(startOfDay(utcNow()),startOfDay(addDays(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1),sub(-4,dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1))))))), or(equals(startOfDay(utcNow()),startOfDay(addDays(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1),sub(1,dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1)))))),equals(startOfDay(utcNow()),startOfDay(addDays(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1),sub(3,dayOfWeek(addSeconds(addToTime(startOfMonth(utcNow()),1,'Month'),-1))))))) )

Best Regards,

Bof

Was this reply helpful? Yes No
microsoftuser10 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks Bof, appreciate the response.

Can you explain the logic please?
Also did you mean to set the interval as 1 and frequency as "day"?

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

Like (0)

Report
Copy link

Link copied!
Hi @microsoftuser10 ,

Also did you mean to set the interval as 1 and frequency as "day"?

Yes.

Can you explain the logic please?

Check if month ends on Wednesday/Tuesday/Monday

If Yes. Check if today is the prior week 's Monday or Wednesday

If No. Check if today is the last week 's Monday or Wednesday

If the condition is true , then trigger the flow

Best Regards,

Bof

Was this reply helpful? Yes No
microsoftuser10 4 on at

Like (0)

Report
Copy link

Link copied!

I had setup the power automate flow job and it triggered on Tuesday. Did you test it?
What I wanted is - trigger it on Monday and Wednesday (the last week of the month *if* last week has Thursday otherwise go back a week).

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

Like (0)

Report
Copy link

Link copied!

Hi @microsoftuser10 ,

Show me your trigger please.

Best Regards,

Bof

Was this reply helpful? Yes No