Forum Discussion
Multiple sharepoint lists sharing same columns
You could use PowerApps to simulate security through obscurity to accomplish this but that's only thing I know of outside a custom developed solution.
Hi, thanks for your repsonse.
So what I want to do is have 3 listst that share some of the columns and each has its own set of columns. The first column (column 1) would be a unique column.
LIST.A: Column1(unique) Column2 Column3 Column4
LIST.B: Column1(unique) Column4 Column5
LIST.C: Column1(unique) Column2 Column4 Column6
In fact it's list level security. It's just that the lists are shareing the same entries just with some same and some different columns involved.
- If you mean the value of a column is shared by the three lists so when you update the value in one list it's reflected on the other, then this is not possible out of the box with lists...each list as an individual artifact is not related to the other lists but you can link lists using lookup columns
Ok so what are my possibilities for this problem? Cheers
Do you have a requirement there for security or is it that you just want to show different data sets to different users? If there's no security requirement around it, you could just use a single list with different views configured for each group of users. This way you have one version of the truth, i.e. one list item which is accessed by several different groups of users, but depending on the view will depend on the columns which are shown. This approach would give you the following:
List:
VIEW.A: Column1 Column2 Column3 Column4 Viewed by users set.A
VIEW.B: Column1 Column4 Column5 Viewed by users set.B
VIEW.C: Column1 Column2 Column4 Column6 Viewed by users set.C
