Home

Sharepoint List - filter by results of another list.

%3CLINGO-SUB%20id%3D%22lingo-sub-1169391%22%20slang%3D%22en-US%22%3ESharepoint%20List%20-%20filter%20by%20results%20of%20another%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1169391%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22_2FCtq-QzlfuN-SwVMUZMM3%20_2v9pwVh0VUYrmhoMv1tHPm%20t3_euw5ey%22%3E%3CDIV%20class%3D%22y8HYJ-y_lTUHkQIc1mdCq%20_2INHSNB8V5eaWp4P0rY_mE%22%3E%3CDIV%20class%3D%22_2SdHzo12ISmrC8H86TgSCp%20_29WrubtjAcKqzJSPdQqQ4h%20%22%3EThis%20is%20a%20filter%20by%20multiple%20items%20question.%20I%20have%20a%20staffing%20list%20webpart%20that%20I'm%20using%20the%20current%20user%20filter%20webpart%20to%20display%20the%20projects%20that%20a%20specific%20person%20working%20on%20(which%20will%20typically%20be%20more%20than%20one%20project%2C%20but%20not%20a%20massive%20amount).%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22_3xX726aBn29LDbsDtzr_6E%20_1Ap4F5maDtT1E1YuCiaO0r%20D3IL3FD0RFy_mkKLPwL4%22%3E%3CDIV%20class%3D%22_292iotee39Lmt0MkQZ2hPV%20RichTextJSON-root%22%3E%3CP%20class%3D%22_1qeIAgB0cPwnLhDF9XSiJM%22%3EI%20would%20like%20to%20use%20the%20results%20of%20the%20filtered%20staffing%20list%20(using%20a%20Project%20Number%20field)%20to%20use%20as%20filter%20criteria%20on%20another%20list%20webpart.%20When%20using%20out%20of%20the%20box%20filters%2C%20this%20works%20great%20when%20only%20one%20project%20number%20is%20passed%20to%20the%20second%20list.%20Is%20it%20possible%20to%20pass%20the%20list%20results%20as%20an%20OR%20statement%3F%26nbsp%3B%20I've%20got%20SP2013%20enterprise%20and%20can%20probably%20fumble%20my%20way%20through%20sharepoint%20designer.%26nbsp%3B%20Just%20need%20some%20help%20pointing%20me%20in%20the%20right%20direction%20with%20either%20workflows%2C%20code%2C%20or%20maybe%20an%20overlooked%20calculated%20column%20formula.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1169391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1173110%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20-%20filter%20by%20results%20of%20another%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1173110%22%20slang%3D%22en-US%22%3E%3CP%3EI%20ended%20up%20settling%20on%20using%20the%20parent%2Fchild%20filters%20between%20two%20tables.%26nbsp%3B%20It%20requires%20a%20few%20more%20clicks%20for%20each%20user%2C%20but%20it%20works%20today.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
This is a filter by multiple items question. I have a staffing list webpart that I'm using the current user filter webpart to display the projects that a specific person working on (which will typically be more than one project, but not a massive amount).

I would like to use the results of the filtered staffing list (using a Project Number field) to use as filter criteria on another list webpart. When using out of the box filters, this works great when only one project number is passed to the second list. Is it possible to pass the list results as an OR statement?  I've got SP2013 enterprise and can probably fumble my way through sharepoint designer.  Just need some help pointing me in the right direction with either workflows, code, or maybe an overlooked calculated column formula.

1 Reply
Highlighted

I ended up settling on using the parent/child filters between two tables.  It requires a few more clicks for each user, but it works today.