Answered

Run flow in specific dates of the month

(0) Share

Report

Posted on by RLSid17

219

Hi,

I want to create a flow where it would send emails to the recipients every 1st, 3rd, and 5th of every month (excluding weekends if possible). How can I achieve this with the Recurrence flow since I'm not able to specify the dates if it would run every month?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RLSid17 ,

Please try:

@and( or(or(equals(dayOfMonth(utcNow()),1),equals(dayOfMonth(utcNow()),3)),equals(dayOfMonth(utcNow()),5)), not(or(equals(dayOfWeek(utcNow()),0),equals(dayOfWeek(utcNow()),6))) )

Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @RLSid17

You can make a schedule flow that runs on daily basis & within flow you can check the dates and day and accordingly perform the specific actions. I have designed a schedule flow as per your requirements:
1. Schedule the flow to run daily:

2. Next, add the conditions to check the date and day (for weekends):
here, we are checking if the current date(today) is 1, 3 or 5 and also checking if day is between 0-6. The number 0 & 6 are being used for Sunday & Saturday respectively.

3. You can perform additional actions in the "Yes" path as per your need.

If it helps, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
RLSid17 219 on at

Like (1)

Report
Copy link

Link copied!

@v-bofeng-msft and @ManishSolanki

Thank you both for your solutions! I tried it and it works (today). I won't know until the flow runs on the 1st, 3rd, or 5th day. This is really helpful and I intend to learn more about trigger functions like this.

Was this reply helpful? Yes No
RLSid17 219 on at

Like (0)

Report
Copy link

Link copied!

Just a question, can I create 3 separate conditions for 1st, 3rd, and 5th day to send emails?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yes, you can. Infact, you can further check the date or day within "Yes" path which again opens gate for "Yes" and "No" flow. I mean you can add condition within condition to perform actions based on specific date or day.

Thanks

Was this reply helpful? Yes No