You’re offline. This is a read only version of the page.
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.
No worries! Glad you were able to sort it out!
I appreciate that long walk with me @creativeopinion . That did it! Thank you very much.
What you have in the Compose action field is just a string of text.
It needs to be an expression.
Can you put the expression for the date in a Compose action? To check the outputs?
Share
Report
All responses (
Answers (
addDays(utcNow(),30,'yyyy-MM-dd')
Then set an item in your list to that date. In your Filter query, instead of inserting the expression directly into the Filter query, use the Compose action instead.
Should look something like this. Compose action isn't necessary however if you're running into issues I'd always recommend using a Compose action to help troubleshoot.
Can you just enter a date that matches to ensure that your schema is correct?
field_1 eq '2023-12-31'to see if it's returns an item.
Thanks, but it failed again with the following error.
The expression "field_1 eq 'addDays(utcNow(),30,'yyyy-MM-dd')'" is not valid. Creating query failed.
field_1 is the schema for the date column.
I'm about to give up, even though I feel like this should be simple. I'm not sure what is going wrong.
You need to run the filter query on the column that stores a date not the column that is storing text. The filter query is outputting a date so it needs a date to compare to.
Just the date. I have one column, 1, that is a formatted date column and I have a second that is a single line of text( see below).
I followed the dircetions that another user stated by finding the Schema name for the column, which is Date2.
When i enter this expression in the Filter Query: Date2 eq 'addDays(utcNow(),30,'yyyy-MM-dd')' I get an error "The expression "Date2 eq 'addDays(utcNow(),30,'yyyy-MM-dd')'" is not valid. Creating query failed."
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
