I have a roster set up within SharePoint with the following fields:
- Start Date (Date Field)
- End Date (Date Field)
- Name – (Choice Menu with three names in it)
So as an example, I have the following roster set up in a SharePoint list.
I populate the above fields manually but I want a site workflow set up that emails out who is on the roster for this week.
e.g. email notification stating something like %Name% is on roster from %Start Date% to %End Date%
(Peter Davis is on roster from 20/4/2015 to 26/04/2015)
I want to schedule the workflow that runs on every Monday at 10am. I can do that but I don’t know how to select the correct value from the name field?
Basically the workflow needs to run through the list and then add the value from the Name field to a variable when the Start Date (always on a Monday) equals the date when the workflow runs (always runs on a Monday).
I tried using Query Lists and Collections but not sure how to use them properly? Are you able to tell me what I need in the workflow to get this
Any assistance would be greatly appreciated.