Aug 11 2016 02:16 PM
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.
Aug 11 2016 10:33 PM
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.
Aug 12 2016 02:49 PM
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.
Aug 14 2016 10:35 PM
Hi Magnus,
i did a little search and hope this video helps you with your creation:
https://www.youtube.com/watch?v=ziVngsLQ94w
Aug 15 2016 05:39 AM
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.