cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Partisan
Post Partisan

Trigger email on specific dates

Hi,

I need to send the email to the concerned department on 3 specific dates from power automate flow. I believe Recurrence control will allow to trigger only on a single date. Please advise.

1 ACCEPTED SOLUTION

Accepted Solutions

@Teresa24486 

 

Did you tried the approach which I suggested. Not full hard-coded value of date like month, date and year. Getting only date integer value from dates for the month, so that we can trigger for subsequent months and do the validation.

 

Let me know if that works for you.

 

 

Regards,

Prakash

View solution in original post

17 REPLIES 17
rampprakash
Power Participant
Power Participant

Hi @Teresa24486,

 

In the Occurance flow just cross the condition with the Three dates and process it.

 

Eg

Trigger Occurance flow

 

If the date = 1 or date = 2 or date = 3

Process it

 

If you think it's not a good one we can create three different flows 

 

Please Mark as Solution if this helps

https://microsoftcrmtechie.blogspot.com

https://youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

dpoggemann
Super User
Super User

Hi @Teresa24486 ,

 

The recurrence does not allow this, you can run on specified minutes, hours, days, weeks, months with a start date.  In these situations I would have the flow where you want to actually execute the business logic triggered by http request and then have three different flows that run on your specified intervals all call the main flow that receives the http request.  This way if you want to add additional recurrences you can and all of them would just call the same main flow.

 

Example video:  https://youtu.be/umBegXooiKU?t=643

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,

Drew

Prakash4691
Solution Supplier
Solution Supplier

@Teresa24486 

 

Set recurrence flow interval to 1 and frequency to day. 

 

Add triggering condition as specified below,

@or(equals('05/09/2021', formatDateTime(utcNow(),'dd/MM/yyyy')), equals('24/10/2020', formatDateTime(utcNow(),'dd/MM/yyyy')), equals('25/10/2020', formatDateTime(utcNow(),'dd/MM/yyyy'))). Attached screenshot for your reference.

 

Prakash4691_0-1630855447599.png

 

Change dates as per your requirement. If it wants to trigger on specific timezone, you can set that too from advanced settings options of recurrence.

 

If it answers your question, kindly give kudo and accept it as solution.

 

 

Regards,

Prakash

Hi @Prakash4691,

Mine is a manual trigger flow, how can I add the recurrence control without deleting the existing flow?

@Teresa24486 

 

Manual flow we cannot add any trigger condition. It is self explanatory has to be triggered manually.

 

But you can add condition inside manual flow. Create variable with Boolean type include formula which I mentioned earlier and remove @from beginning. Add seperate condition and check for variable, if it is true add you business logic or else do nothing.

 

If it is easy to delete and create flow, you can try recurrence flow.

 

If it answers your question, kindly give kudo and accept it as solution.

 

 

Regards,

Prakash

Hi @Prakash4691,

In the above example, the trigger dates are hard coded, but I want the flow to trigger on specific dates every month. Does it do the same functionality?

 

rampprakash
Power Participant
Power Participant

hi @Teresa24486,

 

I think its better to use 3 different schedule flows.

 

Please mark as Answer if it is helpful and provide Kudos

Blog : https://microsoftcrmtechie.blogspot.com
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

dpoggemann
Super User
Super User

Hi @Teresa24486 ,

 

If you don't want to duplicate code across the three flows, please see my details on the http trigger above.

 

Please accept if answers your question or Like if helps in any way.


Thanks,


Drew

@Teresa24486 

 

Yes, it will but tweak the formula a bit. Instead of passing date with month and year just pass specific dates like below using expression. Just get date integer value from utcnow() to validate.

 

or(equals('05', formatDateTime(utcNow(),'dd')), equals('24', formatDateTime(utcNow(),'dd')), equals('25', formatDateTime(utcNow(),'dd')))

 

Add initialize variable action and set type to Boolean include above formula as expression in value.
 
Add another action as condition, if it is true include your business logic or else do nothing. Attached screenshot for your reference.
 
Prakash4691_1-1631021631614.png

 

 
If it answers your question, accept it as solution.
 
 
Regards,
Prakash

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,463)