Get items in cross site lookup field from multiple sub sites.

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
riyaz.kalva
Posts: 2
Joined: Sun Dec 27, 2015

28 Dec 2015

Hello Sir,

I have one site collection under which 5 sub-sites. I have one created one site content type in root site for e.g. My Article. In all sub-site's pages library I have added the My Article content type. Now what I want to do with cross site lookup field is, it should show all items from these 5 sub-site's pages library filtered by My Article content type. As of now, we can select only single site as a source site for the cross site lookup column. But how would I select multiple sites as a source site for cross site lookup column?



Thanks.

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

29 Dec 2015

Hi,

You cannot aggregate multiple lists in the same lookup. So, I can recommend to create a list in the root site and add a separate entry for each article in each sub-site. Then create a lookup field getting data from that list.

Anita Weber
Posts: 9
Joined: Tue Nov 24, 2015

29 Dec 2015

This would not work unless that list is dynamically updating itself as the content in all those page libraries update.

Could a search query not be used and set as the Lookup source?

Anita Weber
Posts: 9
Joined: Tue Nov 24, 2015

29 Dec 2015

Or I think SPServices can create a multi-lookup also

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

29 Dec 2015

Hi,

You can populate the main list with a workflow each time a new article is created in one of the sub-sites.

Anita Weber
Posts: 9
Joined: Tue Nov 24, 2015

29 Dec 2015

Dmitry, we worked out using a REST search call based on Content Type is probably the easiest way.

Will let you know the outcome.

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

29 Dec 2015

Cross-site Lookup does not allow you to store items from multiple lists. So, I don't think that this is an option.

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 7 guests