Need to send email message after 25 days of Last Job

(0) Share

Report

Posted on by echodapogi

516

Team,

I need help on figuring out this Flow. I have a field called "LastDateJob". I need to send email notification 25 days after the last date job. The trigger is the following steps.

1. When new file is created in Sharepoint list

2. User will enter the "LastDateJob" value. example 4/16/2021

3. I need to send out email message 25 days after this "LastDateJob" saying "Thank you for your service"

Note: I am using "Delay until" function (not sure if this is right function to use)

Please help. don't know how can i achieve this. i tried several expressions but i encounter some errors.

Thanks in advance

echo

Categories:

General topics

All responses (3)

Answers (0)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@echodapogi

The issue with your approach is that a Flow cannot run for more than 30 days. I suspect that you'll want the email to go out more than 30 days after the file is created. A better way would be to use a Recurrence trigger that fires every day. Then, use a Get files - properties only action with a query filter. I will create an example and post here.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@echodapogi

See my example below and let me know if you have any questions. The expression that I used is in the comments. Take note of the single quotes around the expression and the date format.
echodapogi 516 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Scott,

I will try the example you provided. Apply it in my flow. I will let you know if this is successful in my case.
thank you so much for your input.

Echo