I have a sitecollection with a lot of subsites containing the same tasklist. Is there a way to have a WF, that collects all tasks and end dates and sending out a task reminder to the assigned person a few days in advance?
Thanks for your help & Best regards
I suggest you to create a new Site Workflow and schedule it daily.
On that workflow query your task list and get the end date column to compare with today - 5 ( you can use the fndatediff function ) and then use the Send Notification Action.
Good morning Fernando,
that's actually the same what i thought, but how can i get all the task lists of the diffrent subsites, without "programming" the URLs directly into the WF. I need some kind of loop for all the subsites...
Thanks & Best regards
you can get all subsites with the help of a web service call. Afterwards you need to extract the URL's into a collection variable and the just loop through all of them. This is how the web service call looks like.