Home

Dynamic filtering of "Assigned To"-column of Workflow Tasks list

%3CLINGO-SUB%20id%3D%22lingo-sub-1208820%22%20slang%3D%22en-US%22%3EDynamic%20filtering%20of%20%22Assigned%20To%22-column%20of%20Workflow%20Tasks%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208820%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20list%20called%20%22People%20Lookup%22%20that%20contains%20the%20following%20columns%3A%3CBR%20%2F%3E1.%20%3CSTRONG%3ERoles%3C%2FSTRONG%3E%20-%26nbsp%3BThe%20different%20roles%26nbsp%3Bof%20my%20department%20(single%20line%20of%20text%20column)%3C%2FP%3E%3CP%3E2.%20%3CSTRONG%3EA-shift%3C%2FSTRONG%3E%20-%20The%20A-shift%20responsible%20per%20role%20(person%20or%20group%20column)%3C%2FP%3E%3CP%3E3.%20%3CSTRONG%3EB-shift%3C%2FSTRONG%3E%20-%20The%20B-shift%20responsible%20per%20role%20(person%20or%20group%20column)%3C%2FP%3E%3CP%3E4.%20%3CSTRONG%3EC-shift%3C%2FSTRONG%3E%20-%20The%20C-shift%20responsible%20per%20role%20(person%20or%20group%20column)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20all%20relating%20workflows%20I%20query%20this%20list%2C%20which%20means%20that%20as%20long%20as%20I%20keep%20this%20list%20up-to-date%20the%20responsible%20people%20will%20be%20assigned%20the%20relevant%20tasks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELately%20I%20have%20tried%20to%20create%20shift-specific%20views%20of%20the%20open%20tasks%20of%26nbsp%3Bthe%20Workflow%20Tasks%20list%2C%20but%20without%20any%20success.%20Does%20anyone%20have%20any%20suggestions%20to%20how%20I%20can%20achieve%20this%3F%20Essentially%20I%20am%20trying%20to%20filter%20the%20%22Assigned%20To%22%20column%20of%20the%26nbsp%3BWorkflow%20Tasks%20list%20to%20only%20display%20tasks%20assigned%20to%20the%20people%20of%20the%20different%20shift%20columns%20of%20my%20lookup%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1208820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Regular Visitor

Hello,

 

I have this list called "People Lookup" that contains the following columns:
1. Roles - The different roles of my department (single line of text column)

2. A-shift - The A-shift responsible per role (person or group column)

3. B-shift - The B-shift responsible per role (person or group column)

4. C-shift - The C-shift responsible per role (person or group column)

 

In all relating workflows I query this list, which means that as long as I keep this list up-to-date the responsible people will be assigned the relevant tasks.

 

Lately I have tried to create shift-specific views of the open tasks of the Workflow Tasks list, but without any success. Does anyone have any suggestions to how I can achieve this? Essentially I am trying to filter the "Assigned To" column of the Workflow Tasks list to only display tasks assigned to the people of the different shift columns of my lookup list.

 

Thanks in advance!