Best way to reuse a list across multiple sites in a tenant

%3CLINGO-SUB%20id%3D%22lingo-sub-196979%22%20slang%3D%22en-US%22%3EBest%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196979%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20list%20of%20data%20that%20will%20be%20reused%20in%20many%20site%20collections%20in%20our%20tenant.%20In%20this%20example%2C%20let's%20call%20it%20%22Department%22.%20Traditionally%2C%20this%20would%20be%20done%20using%20Managed%20Metadata%2C%20but%20it%20seems%20like%20this%20feature%2Ffunction%20has%20been%20largely%20ignored%20(along%20with%20Content%20Types)%20by%20Microsoft%20lately.%20They%20keep%20making%20it%20easier%20for%20end%20users%20to%20create%20new%20lists%20and%20columns%20%22on%20the%20fly%22%20-%20which%20is%20fantastic%20until%20a%20users%20comes%20to%20us%20wanting%20to%20standardize%20a%20column%20definition%20across%20multiple%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20back%20to%20the%20question%2C%20is%20Managed%20Metadata%20still%20the%20best%20way%20to%20do%20this%3F%20I've%20also%20considered%2Ftried%20a%20Site%20Column%20in%20the%20Content%20Type%20Hub%20that%20is%20a%20lookup%20to%20a%20list%20in%20that%20site.%20However%2C%20Lookups%20have%20always%20been%20a%20little%20finicky%2C%20especially%20when%20custom%20forms%20(InfoPath%20or%20PowerApps)%20come%20into%20the%20picture.%20Is%20there%20a%20way%20to%20create%20a%20table%20in%20Azure%20and%20link%20to%20it%20in%20a%20way%20that%20it%20could%20be%20the%20data%20source%20for%20a%20Site%20Column%20(that%26nbsp%3B%3CEM%3Ewasn't%3C%2FEM%3E%20a%20Lookup)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-196979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197018%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197018%22%20slang%3D%22en-US%22%3E%3CP%3EThey%20can%2C%20but%20you%20need%20custom%20code%20to%20get%20them%20back%20out%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBtw%2C%20most%20of%20the%20people%20in%20this%20network%20have%20shared%20their%20real%20name%2C%20you%20may%20get%20more%20responses%20if%20you%20do%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197010%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197010%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20try%20external%20data%20column%20to%20reference%20data%20from%20azure%20table%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197009%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197009%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20so%20MM%20is%20the%20best%20way%20for%20a%20single%20value%20(e.g.%3A%20%22Department%22).%20What%20if%20we%20expand%20the%20scope%20a%20bit%20to%20include%20a%20list%20with%20multiple%20columns.%20For%20example%2C%20we're%20a%20University%20where%20a%20lot%20of%20things%20occur%20or%20relate%20to%20cycles%20like%20academic%20years%20or%20terms.%20I'm%20working%20on%205%20different%20projects%20now%20that%20all%20involve%20a%20%22Term%22%20field%20in%20a%20form%2C%20list%20or%20app.%20At%20the%20University%20level%2C%20a%20Term%20has%20a%20title%20(%22Fall%202018%22)%2C%20code%20(%22201815%22)%2C%20start%20date%2C%20and%20end%20date.%20We%20can%20create%20a%20content%20type%20in%20the%20content%20type%20hub%20for%20%22Term%22%20which%20has%20those%20columns%2C%20but%20this%20would%20still%20require%20each%20site%20to%20have%20its%20own%20%22Terms%22%20list%20using%20that%20content%20type%2C%20but%20with%20items%20created%2Fmanaged%20by%20the%20site%20owner%20(or%20a%20member).%20This%20is%20how%20we%20did%20it%20in%20SP2010%2C%20but%20it%20wasn't%20an%20ideal%20solution.%20I%20have%20to%20imagine%20that%20there%20is%20a%20better%20way%20in%20Office%20365%2C%20but%20not%20sure%20what%20it%20is.%20I%20don't%20think%20Managed%20Metadata%20terms%20can%20have%20%22properties%22%2C%20can%20they%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-196990%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-196990%22%20slang%3D%22en-US%22%3E%3CP%3Eyes%20it%20is%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506868%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F86417%22%20target%3D%22_blank%22%3E%40ChadKealey%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20issue.%20Did%20you%20resolve%20it%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1510188%22%20slang%3D%22en-US%22%3ERe%3A%20Best%20way%20to%20reuse%20a%20list%20across%20multiple%20sites%20in%20a%20tenant%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510188%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721497%22%20target%3D%22_blank%22%3E%40danielmoral%3C%2FA%3E%26nbsp%3BNo%2C%20I%20gave%20up%20or%20found%20workarounds.%20For%20example%2C%20I%20often%20used%20those%20lists%20to%20feed%20a%20site%20column%20that%20would%20be%20used%20throughout%20a%20site%20collection.%20Instead%2C%20I%20use%20a%20%22master%22%20list%20in%20one%20site%20in%20multiple%20PowerApps%20or%20flows.%20It%20requires%20a%20bit%20of%20creativity%2C%20but%20it%20works.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20reality%2C%20I%20probably%20should%20be%20using%20managed%20metadata%2C%20but%20we%20have%20too%20many%20competing%20agendas%20for%20any%20departments%20to%20agree%20on%20a%20taxonomy.%20Such%20is%20life%20in%20academia.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

I want to create a list of data that will be reused in many site collections in our tenant. In this example, let's call it "Department". Traditionally, this would be done using Managed Metadata, but it seems like this feature/function has been largely ignored (along with Content Types) by Microsoft lately. They keep making it easier for end users to create new lists and columns "on the fly" - which is fantastic until a users comes to us wanting to standardize a column definition across multiple lists.

 

Anyway, back to the question, is Managed Metadata still the best way to do this? I've also considered/tried a Site Column in the Content Type Hub that is a lookup to a list in that site. However, Lookups have always been a little finicky, especially when custom forms (InfoPath or PowerApps) come into the picture. Is there a way to create a table in Azure and link to it in a way that it could be the data source for a Site Column (that wasn't a Lookup)?

6 Replies

OK, so MM is the best way for a single value (e.g.: "Department"). What if we expand the scope a bit to include a list with multiple columns. For example, we're a University where a lot of things occur or relate to cycles like academic years or terms. I'm working on 5 different projects now that all involve a "Term" field in a form, list or app. At the University level, a Term has a title ("Fall 2018"), code ("201815"), start date, and end date. We can create a content type in the content type hub for "Term" which has those columns, but this would still require each site to have its own "Terms" list using that content type, but with items created/managed by the site owner (or a member). This is how we did it in SP2010, but it wasn't an ideal solution. I have to imagine that there is a better way in Office 365, but not sure what it is. I don't think Managed Metadata terms can have "properties", can they?

Did you try external data column to reference data from azure table?

They can, but you need custom code to get them back out, 

 

Btw, most of the people in this network have shared their real name, you may get more responses if you do the same.

@ChadKealey 

I have the same issue. Did you resolve it?

Thanks

 

@danielmoral No, I gave up or found workarounds. For example, I often used those lists to feed a site column that would be used throughout a site collection. Instead, I use a "master" list in one site in multiple PowerApps or flows. It requires a bit of creativity, but it works. 

 

In reality, I probably should be using managed metadata, but we have too many competing agendas for any departments to agree on a taxonomy. Such is life in academia.