0

I have a List 'Product' (Parent site) with column 'IDManager' and another List 'Roadmap' (subsite) with column 'IDManager'.

I need to get the 'IdManager' column values from Product List to 'IDManager' column in the Roadmap list when item created or updated in the Roadmap List.

Note: 'Product Name' column is common in both lists.

Improve this question
1
  • Its pretty simple through SPD workflow.. What is the challenge you are facing?? Commented May 18, 2016 at 7:02

2 Answers 2

Reset to default
0

Lookup column is the answer you are looking for. Try creating a Lookup column in Roadmap list and fetch the values using column of ProductList. Check this video on how to create lookup column:

https://www.youtube.com/watch?v=ShLH0mBcA54

Improve this answer
4
  • Thanks for your help. I tried it. But, how to get the data from parent site to sub site? Commented May 18, 2016 at 9:59
  • You never mentioned that you are looking for Parent site to child site connection. It is not possible to connect Parent site content into a subsite by using Out of the Box feature. you need to add a DataView Web part using SharePoint Designer to fetch the contents. Read about Data View Web part Commented May 18, 2016 at 11:27
  • To be fair he did state the list "roadmap" is placed on a subsite from the beginning. Commented May 19, 2016 at 7:18
  • my bad..missed it Commented May 19, 2016 at 8:38
0

You can actually have a lookup column containing a field from the parent site on a subsite using OOB functionality.

The trick is to first create the list on the parent site you want to look up into. Then you create a site (lookup) column targeting the parent list. Now on your subsite you can select the site lookup column and add it to your list.

Mind you a people picker cannot be used as a lookup target, so if your column "IDManager" is of that type it will not work. But if it's just a plain text field it will Work.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.