This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 68%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBW%3C/text%3E%3C/svg%3E)
I have a list in SharePoint that I need to set up a workflow to automatically run daily. I want it to do the following:
Check if the Follow-Up Required? field is Yes
AND if the Follow-Up Complete? field is No
AND if the Follow-Up Date is before today. (past due)
Then send an email.
I need this to loop through all items in the list once a day, is this possible? If a time is needed, it would be 7am EST
Hi @Boyd, William , I'm looking into your issue now and I will reply you as soon as possible. :)
Hello, thank you for your reply. I wanted to check in to see if you had any luck?
Hi @Boyd, William ,
Which version of SharePoint are you using? I did some tests, it should be not supported to use workflow to automatically send daily emails. If you are using SharePoint Online, I even recommend that you gradually reduce the use of workflow, Microsoft will stop supporting workflow in the future. What can be done is to send an email when the conditions are met when the item is created:
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
We have to keep using workflows with my company until 2023, so we have to run these for now. The example you put up was fine for creating items or when it is edited. However, I need a loop that will look through each item daily and send the email if the condition is true.
Hi, would you like to share the version of SharePoint you are using? If it is SharePoint Online, you could try to use flow, which is currently the recommended tool. In the case of SharePoint Server, according to my research, there is no condition for sending emails regularly every day.
I am not sure how to determine the version. We are in MS365 and SharePoint Designer 2013. We to not have Forms yet. And I do not need it to generally send an email daily. I need it to loop through each item daily and send the notification if an item is past due.
Is there a farm in your environment? Is the operation interface like this:
