You’re offline. This is a read only version of the page.
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
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.
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:
Share
Report
All responses (
Answers (
9,930utcNow('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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
