Okay SharePoint lovers, I think I need someone who can do some programming behind the scenes (I know I can’t!).
This is what I need: I’m trying to gather “field data” from multiple sites (or sub-sites). I’ve read about the Content Search Web Part but am having no luck with that – I think it’s because I’m looking to aggregate specific fields. For example:
I have three sites, all with lists:
Site A
Company Name
End User
Tool Name
Status
Site B
Company Name
End User
Part Number
Warranty Expiration
Site C
Company Name
Delivery Date
Value
From these 3 sites, I’d like to have Company Name as the key field (for lack of a better term), to a new list on a new page containing: Company Name (key field) Part Number (from site B) Warranty Expiration (from site B) Delivery Date (from site C).
Can anyone help??? Doing any sort of back-end programming is beyond my skill level.
Maybe this video will help out? “Roll up content from across sites”
https://www.youtube.com/watch?v=_7hVH2Z6p_k
A Content search web part will work for this. Â I would first create a Content Type that all 3 lists will use. Â Then in your content search web part, target this content type as the source to return results. Â You can then create a refiner or other filters to filter out part numbers or tool names for example.
I’d have to do some testing but I think you’d be able to achieve this using the excellent workflow tools from Plumsail. They have some workflow actions that go across site boundaries. Take a look here – https://plumsail.com/workflow-actions-pack/Â
Rob
I don’t know (yet), but I’m definitely going to find out and use your steps to see if I can make it work with SP2013. I know some of the 2012 and earlier SP stuff doesn’t work in the new version, but I’ll look! I’ll reply if it does!
BTW – love your website! Got it bookmarked.
Does your structure allow you to use cross-site lookup columns? Have a read of this if so : https://bniaulin.wordpress.com/2012/04/10/create-a-sharepoint-lookup-column-to-another-site/
