Answered

Send email notification when sharepoint list item reaches due date

(0) Share

Report

Posted on by Stuey187

Hi there, I am relatively new to SharePoint and flows. I want a scheduled flow that send an email when the item due date is reached. I have built the flow below and tried various different scenarios but not having any luck. When I run this flow the history shows succeeded but no email is sent. I have one item in my list which should have resulted in an email

Would be grateful for any input that may resolve the issue

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @Stuey187 ,

I think the problem is in the date - if you're using just the utcNow() expression then it contains also the "current" time of the flow run, which will never be equal to a date without time. When building reminders over SharePoint list you're interested only in the date part in ISO format - add formatting into the utcNow() expressions:

utcNow('yyyy-MM-dd')

Also, it's better to use filters in the 'Get items' when building reminders than a loop + condition. If you use a filter it'll return right away only the items that fit the filter, e.g. the items where the due date = today (as explained e.g. here). If you use a loop an a condition it'll loop through all the items and check them one by one using the condition - a very time consuming operation once you reach a higher amount of items in the list.

Was this reply helpful? Yes No
Stuey187 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom, Thanks for you feedback.
As suggested I have added a filter into the 'Get Items'.
I was still having an issue but discovered, after much painstaking research, that I was not using the column internal name. Updated this and all working good now.
Thanks for your help.

Was this reply helpful? Yes No