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

[MjrPothead]

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.

[jinivthakkar]

@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.

[MjrPothead]

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

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

[MjrPothead]

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

[jinivthakkar]

@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.

[MjrPothead]

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....

[jinivthakkar · Accepted solution]

@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.

[MjrPothead]

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.