Executing flow on last monday of the month

(0) Share

Report

Posted on by ocgv99

Hi all,

I am relatively new to Power Automate and I am trying to make 2 flows, one that will execute on the last monday of the month and a different one that will execute on the last Friday of the month.

I have created a flow starting with a recurrence with a trigger set as follows for the monday version:

@And( equals(dayOfWeek(triggerOutputs()?['headers']['x-ms-file-last-modified']), 1), equals(dayOfMonth(utcNow()), dayOfMonth(addDays(addMonths(utcNow(), 1), -1))) )

My main issue is, will this work and should I set the recurrence to every day or repeat weekly only on mondays?

Thanks in advance.