First time posting! Hello, I have a list that is being utilized to manage project requests. These requests have an option for a "duration" (15, 30, 60 or 90 days). I have created a calculated column that takes the user's choice and applies an "Expiration Date", which is their choice of duration represented in date form. I have a need to send a reminder email to the creator of the item 10 days before the "Expiration Date". I have looked through every past post and article I could find but I haven't had any luck putting it all together.
I have attached a screenshot of my scheduled site workflow:
Calculate Date sets "Today's Date" in a variable: varReminderDate
Query List queries the list when the Expiration Date column is equal to varReminder Date
I also have the "Field" set to Expiration Date and the variable to "sendemailremindervar"
When I run this, it does not return anything - Expiration_x0020_Date:
For each sets collection to "varsendemail"
Store result in "varstoreresult"
Send notification is set to send to me as a test, though I will be setting that to the creator of the list item.
Can anyone guide me on what I may be telling it to do incorrectly? I can provide any other needed info!
Thanks!