Answered

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

(0) Share

Report

Posted on by 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.

Categories:

General topics

All responses (7)

Answers (1)

Sort by

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, so I am guessing it should look something like this?
@less(int(utcNow('dd')),8), greater(int(utcNow('dd')),15)
MjrPothead 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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

jinivthakkar 4,187 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 12 on at

Like
a
(1)

Report
Copy link

Link copied!

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.