
Hi!
I want to setup auto reminder in my list that send email if column(1) value is "No" and it 3 days over due from date I picked in Date(2) column.
Any ideas?
Hi @Pavel_H ,
You could create a calculated column in your list that will calculate the difference between your Date2 column and today.
Create a scheduled flow that runs daily.
Use the SharePoint Get Items with a filter column1 eq '0'. This will give you only items with No.
Save your result as an array and then filter based on your calculated field eq 3.
Send email.
If you dont want to use a calculated field, you can look at using at using expressions here.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn