cancel
Showing results for
Search instead for
Did you mean:
Regular Visitor

## Build flow to send email on report on 2nd Tuesday of Month

Trying to build a flow that allows me to only send an email on the 2nd tuesday of the month.  A patch report that I created in Logic Apps.  I user Power Automate to fetch file from Sharepoint and send via an email.  I have used the following Triggers in my Recurrence but they dont seem to work.

@And(greater(int(utcNow()),7),(less(int(utcNow()),14))

Anyone that can help this would be greatly appreciated.  Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User

@MjrPothead please can you try this expression

@and(less(int(utcNow('dd')),15),greater(int(utcNow('dd')),8))

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

7 REPLIES 7
Dual Super User

@MjrPothead please can you check this blog, it shows how to run flow on first tuesday of the month, you just need to make a minor change

https://tomriha.com/schedule-power-automate-flow-to-run-only-first-tuesday-of-the-month/

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Regular Visitor

Thank you, so I am guessing it should look something like this?

@less(int(utcNow('dd')),8), greater(int(utcNow('dd')),15)

Regular Visitor

So i tried with just the string less(int(utcNow('dd')),8) and get an error saying "Cannot read properties of undefined (reading 'properties')"

Dual Super User

@MjrPothead please check this out, first it is important to understand how the expression is generated, please take a look at this

https://www.youtube.com/watch?v=tlS6pSAx-GY

Using this you should be able to figure and test your expression

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Regular Visitor

Thank you for the video. I watched it and am still confused.  I know I need a trigger condition to run an email on the 3rd Tuesday of the month.  That Video didnt really show me how to accomplish this.  It went into great detail on Triggers and  Conditions.  Im still no closer to getting a trigger condition to run on 3rd tuesday, or 2nd Monday, etc....

Dual Super User

@MjrPothead please can you try this expression

@and(less(int(utcNow('dd')),15),greater(int(utcNow('dd')),8))

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Regular Visitor

I got it, that got me on the right path.  Seems i was using dayOfWeek instead of dayOfMonth.  Now I can specify @And(greater(dayOfMonth(utcNow()),7),less(dayOfMonth(utcNow()),15)) for the 2nd Tuesday of Month.  Thanks for pointing me in the right direction.

## Helpful resources

Announcements

#### Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

#### June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

#### Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

#### Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,817)