cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterMurphy
New Member

Trigger on first Monday of the Month

We need to send out Monthly updates to Employees through announcements on Yammer.  This is labour intensive at the moment and we would like this to be automated.  This would be suitable for announcing that Expense, Mileage and Extra Hour Claims should be in by x date of the Month (or nearest working day prior) or providing reminder announcements for figures to be submitted by a certain date from operational teams.

1 REPLY 1
v-micsh-msft
Community Support
Community Support

Hi @PeterMurphy,

 

I think this could be achieved through the following way:

1. Add the Recurrency trigger, specify Frequency as Day, Interval to 7, Click Advaned options, specify the Start Time to a date in Monday, for example:

2017-03-20T15:00:00Z

Doing it in this way would have the trigger fired every Mondy,

2. Then Add a condition, Click advanced mode, copy and paste the following formula, which would check if the current Monday is within the first 7 days of the current month,

@and(
    GreaterOrEquals(dayofmonth(utcnow()),1),
    less(dayofmonth(utcnow()),8)
)

3. Under the Yes part, add the yammer- Post message Action, click Advanced option, Set the Broadcast to Yes.

See picture reference:

116.PNG

 

Regards,

Michael

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,639)