Sign up ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

So, the question does a poor job of outlining the problem.

I've got one list where my clients track their projects; let's call it Projects. In it, they make a selection on a multiple choice column indicating what area of the company their project affects. The purpose of this is so that when it's time for the project to receive approval, it can be routed to the appropriate approver.

Approvers are linked with the respective areas via another list, which we'll call AreaOwners.

Occasionally, clients will have projects that affect multiple areas. Multiple areas require multiple approvers. So, how do I grab multiple names from my AreaOwners list based on multiple selections from the area column. It'd look like this:


ID  Area

1   NOC, LOC


Area OwnerName

NOC  Jane Doe

LOC  John Doe

POC  Jack Johns
share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.