SharePoint 2013 custom column of subsites

telliot79
telliot79 used Ask the Experts™
on
Experts,

I'd like to have a custom column in a SharePoint list that's a look up column of all my sub sites. Is this possible?

Many thanks in advance,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Out of the box it is not possible, however with some coding or powershell you could maybe do what you want to do.

Good luck...

Author

Commented:
Hi Walter Curtis,

any chance you can point me towards a powershell script that could do this for me?

Thanks,
SharePoint AED
Distinguished Expert 2018
Commented:
Here is a link to SharePoint scripts:

https://gallery.technet.microsoft.com/office/site/search?f%5B0%5D.Type=RootCategory&f%5B0%5D.Value=sharepoint&f%5B0%5D.Text=SharePoint

What you need would be a custom script, use a script that enumerates your sub sites, then add a function that writes to a SharePoint list.

Then you can use that list as a source list for your lookup column.

Good luck...
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Information provided is accurate and correct.

Author

Commented:
I used the following approach https://www.youtube.com/watch?v=ESXbEESNytc.

My apologies for the late reply, took me a while to get all the parts working.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial