Holiday Reminder Email

(0) Share

Report

Posted on by dmattia

101

Hello,

I am trying to create a Holiday Reminder Email to be sent 30 days before a holiday. I created a SharePoint list with the holiday name and date, but cannot seem to trigger the email. I tried testing with multiple dates 30 days before.

Categories:

Building flows

I have the same question (0)

All responses (29)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dmattia

You need to use -30 (minus 30)

Was this reply helpful? Yes No
dmattia 101 on at

Like (1)

Report

@abm I changed it to -30 and I added testing dates of 7/30 and 7/31. It did not work.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dmattia

This is because Date is stored with Date and Time.

You don't need to add the IF condition. Use the ODATA Filter query to retrieve the dates.

See below

Expression is as follows:

(Date ge '@{adddays(utcNow(),-30, 'yyyy-MM-ddT00:00:00Z')}') and (Date le '@{adddays(utcNow(),-30, 'yyyy-MM-ddT23:59:00Z')}')

Was this reply helpful? Yes No
dmattia 101 on at

Like (0)

Report

I'm not sure what happened, because my column is labeled as "Date"...

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dmattia

Based on your previous screenshot I have given the column name as Date.

Replace the ODATA Filter query with the right column schema name.

Thanks

Was this reply helpful? Yes No
dmattia 101 on at

Like (0)

Report

I guess I'm not sure what I am doing wrong. The column from my SharePoint list is titled "Date", which is exactly how the filter query is labeled. What am I missing?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dmattia

That means its been renamed after. So to find out the schema name follow the below steps:

1. Click List Settings

2. Click Date Column

3. Check the url of the browser

4. End of the browser it says field=xxxx. Here xxxx is the actual schema name you need to use.

Thanks

Was this reply helpful? Yes No
dmattia 101 on at

Like (0)

Report

I was able to locate the schema name - thank you! When I run the test though, it does not work... I'm still not sure what is happening. I appreciate your help, I'm new to this.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @dmattia

So you looking for Todays date - 30 days

That is 2023-05-31

Have you got record matching the above date?

Thanks

Was this reply helpful? Yes No
dmattia 101 on at

Like (0)

Report

No, I want the email to go out 30 day's BEFORE the holiday, excluding dates that have already passed, even if they are within the same month.

Was this reply helpful? Yes No