Common data model in Sharepoint Online

%3CLINGO-SUB%20id%3D%22lingo-sub-5300%22%20slang%3D%22en-US%22%3ECommon%20data%20model%20in%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5300%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20just%20making%20sure%20I%20understood%20things...%20If%20I%20set%20up%20the%20common%20data%20model%20(say%20I%20have%20a%20few%20customers%20in%20there)%20I%20can%20use%20those%20customers%20as%20meta%20data%20in%20Sharepoint%20Online%2C%20and%20use%20one%20of%20my%20customers%20as%20meta%20data%20on%20a%20file%20stored%20in%20a%20document%20library.%20Is%20that%20correct%3F%20Thanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-5300%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5582%22%20slang%3D%22en-US%22%3ERe%3A%20Common%20data%20model%20in%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5582%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Paul%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20this.%20I%20want%20to%20do%20exactly%20this%20except%20for%20when%20she%20selects%20lookup%20(at%201%3A45)%2C%20she%20has%20her%20customers%20in%20a%20SPO%20list%20and%20I%20have%20them%20in%20the%20common%20data%20model%20(%3CA%20href%3D%22https%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fannouncing-powerapps-common-data-model%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fannouncing-powerapps-common-data-model%2F%3C%2FA%3E).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20just%20realized%20that%20one%20way%20to%20do%20it%20is%20by%20doing%20a%20flow%20that%20sends%20sends%20new%20entries%20in%20the%20common%20data%20model%20to%20a%20sharepoint%20list.%20This%20is%20a%20decent%20workaround%20I%20guess.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5551%22%20slang%3D%22en-US%22%3ERe%3A%20Common%20data%20model%20in%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5551%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Magnus%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20did%20a%20little%20search%20and%20hope%20this%20video%20helps%20you%20with%20your%20creation%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DziVngsLQ94w%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DziVngsLQ94w%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5449%22%20slang%3D%22en-US%22%3ERe%3A%20Common%20data%20model%20in%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5449%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20if%20my%20question%20was%20a%20bit%20messy%20but%20yeah%2C%20you%20understood%20it%20right.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20a%20column%20to%20look%20values%20from%20another%20%22table%22%2C%20where%20this%20table%20is%26nbsp%3Bin%20the%26nbsp%3Bcommon%20data%20model.%20At%20least%20in%20my%20tenant%20I%20cannot%20understand%20how%20to%20do%20that%20(I%20can%20look%20up%20a%20value%20from%20another%20list%20in%20sharepoint%2C%20no%20probs).%3C%2FP%3E%3CP%3EI%20wonder%20if%26nbsp%3Bit%20is%26nbsp%3Ba)%20just%20not%20possible%20now%20b)%20not%20possible%20now%26nbsp%3Bbut%20will%20be%20later%20or%20c)%20possible%20now%20if%20you%20do%20it%20in%20a%20certain%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5337%22%20slang%3D%22en-US%22%3ERe%3A%20Common%20data%20model%20in%20Sharepoint%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5337%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20i%20understand%20your%20question%20right%20you%20want%20to%20create%20a%20List(table)%20with%20all%20your%20customers%20so%20you%20can%20reference%20them%20in%20a%20other%20List(table)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20this%20you%20could%20use%20a%20lookup%20column%20while%20creating%20the%20second%20list%20and%20add%20a%20column%20choose%20lookup%20and%20select%20the%20list%20with%20your%20customers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all, just making sure I understood things... If I set up the common data model (say I have a few customers in there) I can use those customers as meta data in Sharepoint Online, and use one of my customers as meta data on a file stored in a document library. Is that correct? Thanks for the help.

4 Replies

I hope i understand your question right you want to create a List(table) with all your customers so you can reference them in a other List(table)? 

 

For this you could use a lookup column while creating the second list and add a column choose lookup and select the list with your customers.

 

 

Sorry if my question was a bit messy but yeah, you understood it right.

 

I want a column to look values from another "table", where this table is in the common data model. At least in my tenant I cannot understand how to do that (I can look up a value from another list in sharepoint, no probs).

I wonder if it is a) just not possible now b) not possible now but will be later or c) possible now if you do it in a certain way.

 

Thanks for your help.

Hi Magnus,

 

i did a little search and hope this video helps you with your creation:

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

 

This video contains the steps to create a custom SharePoint Lookup Column at the top level site of a SharePoint Site Collection. You will see how to create t...

Hi Paul,

 

 

Thanks for this. I want to do exactly this except for when she selects lookup (at 1:45), she has her customers in a SPO list and I have them in the common data model (https://powerapps.microsoft.com/en-us/blog/announcing-powerapps-common-data-model/).

 


I just realized that one way to do it is by doing a flow that sends sends new entries in the common data model to a sharepoint list. This is a decent workaround I guess.