Send an Email after 24hr

(0) Share

Report

Posted on by manutd2008

Hi All,

I have request from user, to send an email after 24hr from the date field.

I have date field called: Training End Date. I need to send out an email after 24hr of the Training End Date.

For example if the Training Ended at 8-01-2021, the email will need to send out at 8-02-2021.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report

Hi @abeyenen7 ,

You can use addDays(), just swap out the hardcoded date with your date value.

addDays('8-01-2021',1)

You can use formatdatetime() to reformat to MM-dd-yyyy

E.g.

formatdatetime(addDays('8-01-2021',1),'MM-dd-yyyy')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
manutd2008 16 on at

Like (0)

Report

What is my condition will be?

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @abeyenen7 ,

Theres a few options depending on your flow.

1. If you can trigger the flow at the end of the training session, you can use the Delay Until action and pass in the expression.

2) If not, you can create a scheduled flow to run daily and go through a list of completed training sessions the day prior and send the email out. If you are using SharePoint or Excel, you can use oDATA filters. Example below, note the -1 to subtract days.

TrainingEndDate eq 'formatdatetime(addDays('8-01-2021',-1),'MM-dd-yyyy')'

Was this reply helpful? Yes No
manutd2008 16 on at

Like (0)

Report

TrainingEndDate eq 'formatdatetime(addDays('8-01-2021',-1),'MM-dd-yyyy')'
I like the second option, but we still hard coding the date, is it possible to pass the date field it self?

TrainingEndDate eq 'formatdatetime(addDays('TrainingEndDate',-1),'MM-dd-yyyy')'

Cuz the data can change based on the Training End dates.

Some training date can end the on 09-01-2021,

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

Hi @abeyenen7 ,

Yes, you should be passing the Training End Date dynamically as mentioned in my last post. I dont know anything about your flow or applications so have picked a specific date you have specfied as an example.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No