I have a Task List with columns Task Name and Due Date. I have created a workflow that if due date=today then send an email.

The email is sent every morning to remind people of the tasks due.

What I need in the email is all the task names with due date=today.

However, when I do my look up the workflow returns only one value. But in the same email I want to see all the tasks that are due today.

SharePoint warns me about this possible unique lookup but don't know how to go around it.

  • 1
    you need to create dictionary in workflow and in it to store all items/tasks which have due date eq. Today. You could use REST api, like here: sergeluca.wordpress.com/2013/04/09/…
    – Danilo
    Aug 1, 2017 at 12:37
  • Would it be easier to include in the email body a list view (i.e the upcoming view) ?
    – L Baz
    Aug 1, 2017 at 14:54
  • no, it wouldn't.
    – Danilo
    Aug 2, 2017 at 5:49

1 Answer 1


One possible option could be is to set an alert (List>Alert Me) rather than doing it through workflow e.g., You can set alerts based on the particular view. Below I have selected items 'Due Today' view.

enter image description here

  • Thanks Sharepointer. However seems to work only if someone has changed something.
    – L Baz
    Aug 2, 2017 at 8:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.