Send a reminder (mail) based on a list item date value

[MicrosoftFlowBe]

I am totally new to flow. In our SharePoint library we have two relevant columns for this task:

"Valid to" (date column)

"Document responsible" (person column)

"Valid to" holds a date value, and I need to create a reminder --> that sends a mail to the document responsible for the specific list item/document one month _earlier_than the date value of the "document responsible".

For example: The date in "valid to" is 2020.12.30 for a list item. One month before this date a mail/reminder is sent to the person on the "document responsible" person column. 

I was thinking to use the trigger "when an item is created or modified" since the date value could be changed/modified later on.

My problem is where to start - especially in the scenario where a timer is set in flow to send a mail for a specific date which later changes. How to stop the timer and adjust to the new date?

[v-litu-msft · Accepted solution]

Hi @MicrosoftFlowBe,

You could use Recurrence trigger to run the Flow every day, then use Get items to filter out items that valid to column value is equals to 30 days ago. Then Send a minder to these people, steps as below:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Lino]

Hello, i am trying to do this exact same thing with a column that is called "Due Date" in my sharepoint list. But i cannot seem to make it work. 

I am looking to send an email 16 days before Due Date.
The date format in my sharepoint list is: 'dd/MM/yyyy'

I find it wierd that my Due Date isnt found as Dynamic content. Can the mistake be there?
Otherwise i have also seen that in picture p2, in the parameter tab on the left, its written "$filter": "Due Date eq '03/27/2024'
This is 03/27/2024 is basicly todays date minus the 16 days.
But this is not what i am looking for. I am looking that "if today date is 16 days before due date, then send an email"

Thank you in advance