2

I am rather new with SP so I apologise if I cant express myself too well.
Problem at hand:

Two lists - Shops and Managers with a many-to-many relationship between them.
I.E. in Shops there can be more than one managers and a manager can manage more than one shop

I want to either:

  1. Create a List C where I have a lookup column listing each shop in the first column and in another ALL of the managers that correspond to this shop, written in one line.
  2. Insert a column in Shops outlining all of the managers per a particular shop.

Essentially I want to create a workflow that is activated on a specific date, which checks whether there has been any change in the Managers or the Shops list and subsequently update List C.

Any idea on how I can get multiple values for a lookup?
I created the workflow, but I can only have one value per a field in Shops for managers.

Improve this question

2 Answers 2

Reset to default
0

You should allow multiple values on lookup column:

enter image description here

EDIT:

This will allow you to enter multiple lookup values in the column: enter image description here

Improve this answer
5
  • yes I did that, but somehow it still doesn't allow me to have several values! I created different variables and all, but I am stuck with SP showing me only the 1st value
    – Geri
    Dec 10, 2014 at 11:50
  • Please take a look at edited post.
    – Slaven Semper
    Dec 10, 2014 at 12:04
  • I think SPD only gets the first value of a multiple value column. You might be able to fetch the multiple values if you use the REST API to query the list item and iterate through the list of multiple values.
    – Choggo
    Dec 10, 2014 at 12:30
  • Right, well as mentioned my skills in SP are more of an admin level for now - not much experience with the actual code. But thank! It means that I'm at least certain that none of the easier ways would work @slaven - do you mind elaborating your 2nd solution a bit?
    – Geri
    Dec 11, 2014 at 8:28
  • It's one solution. First screenshot shows editing a lookup column to allow multiple values and the second screen shows how you can enter multiple values in lookup column when creating new list item or editing existing list item.
    – Slaven Semper
    Dec 11, 2014 at 8:54
0

The above is basically correct. In your shops list, create a lookup field to your Managers list, but instead of ID, use the title field (I'll assume your managers name is in that field). 

Get information from 
Managers
In this column
Managers Name

When you add a shop, you can select all the managers for that shop. In workflow, if you return that lookup field, you'll have the option to return it as 'Lookup Values (semicolon delimited)', which will be a list of all the managers.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.