AnsweredAssumed Answered

How do I capture the right value from a SharePoint List?

Question asked by t27046 on Apr 22, 2015

Hi,

 

I have a roster set up within SharePoint with the following fields:

 

  1. Start Date (Date Field)
  2. End Date (Date Field)
  3. Name – (Choice Menu with three names in it)

 

So as an example, I have the following roster set up in a SharePoint list.

 

Start Date

End Date

Name

20/04/2015

26/04/2015

Peter Davis

27/04/2015

03/05/2015

John Smith

04/05/2015

10/05/2015

Fred Nurks

 

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
to work? 

 

Any assistance would be greatly appreciated.

Outcomes