I have a list in which there is a project name, a task description, who (multiple people picker) and a due date
There can be multiple lines for a project, as many times there are tasks.
I need to send an email 3 days before the due date to the persons in the "Who" column BUT only for the tasks where they appear. I would like to send only one mail which will display all the tasks the person has to complete.
Example: 3 days before "02/25/17", the site workflow is supposed to send a mail to each person in the "who" column.
I assume the mail is sent to person1:
Please complete the following tasks before 02/25/17 :
Hope it is clear!
Thansk for your help
Solved! Go to Solution.
A site workflow is the way to go for sure - very similar threads here:
Are they any help in guiding you on a way forwards?
I made a site workflow as you suggested with loops in loops!!
For each "who"
For each "projects"
Get "who" collection on the project
For each "task"
Get "who" collection on the task
Get "project" collection on the task
A bit hot but it works
Thanks a lot!