Hello,
I have a SharePoint list with various tasks with dates assigned to them as well as various people that are responsible for ensuring the tasks are complete. I want to filter the SharePoint list based on whether they are completed or not and send an email to the responsible people 1 day in advance of the listed date being reached.
I need to put a condition in but not quite sure what the condition would be and any help where else I may have gone wrong with the flow.
If I wanted to increase the 2nd condition to 14 days, 7 days, 3 days etc. Does the 3rd condition also increase to 15 days, 8 days, 4 days etc. or would that stay the same
Do that instead of the condition based and use a filter array?
Hi @PowerAutoNewb ,
You could set the flow to trigger daily, filtering the list based on the following three conditions:
1. Filter by completion date;
2. List dates greater than or equal to 00:00 tomorrow; (addDays(startOfDay(utcNow()),1))
3. List dates less than 00:00 the day after tomorrow; (addDays(startOfDay(utcNow()),2))
Then, iterate through the filtered results and send emails.
Best Regards,
Bof
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (