cancel
Showing results 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
Community Champion

@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
Community Champion

@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')"

Community Champion

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

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

Community Champion

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

Announcements

#### December 2023 User Group Update: Welcoming New Groups and Upcoming Events

A new month means it's time to celebrate and welcome the new user groups that have joined our community. We are excited to announce that we have more than 8 New Groups, which is no surprise after the amazing Microsoft Power Platform Conference. This month, we are breaking them out by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you! Don't forget to take a look at the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online.   Please Welcome Our NEW User Groups   Power Platform: PowerIT User Group: Nottingham Power Platform User Group: Bergen Power Platform User Group: Danmark Nashville Power Platform User Group Microsoft Ambassador Program y Mujer Latina Technolochicas NCWIT Community Copilot Studio:  Copilot User Group Italia Dynamics365: Dynamics User Group AdriaticDynamic 365 Azerbaijan   December User Group Events   01 Dec 2023 Aprendiendo Desarrollo web, creando mi primer power app y power page. 01 Dec 2023 Q4 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meeting05 Dec 2023APAC Dynamics 365 FastTrack Bootcamp - BI and Analytics07 Dec 2023Bay Area Power Platform Meetup: Learn, Share, and Connect07 Dec 2023Indiana D365/AX December User Group Meeting07 Dec 2023Dynamics User Group Meeting: Houston09 Dec 2023 December '23 - NEW Power Apps User Group Meeting - Online 12 Dec 2023December Cleveland Power Platform User Group Meeting12 Dec 2023 RW2 Data Stewardship Open Forum Discussion 13 Dec 2023  Black Country Power Platform User Group - December 2023 - West Midlands