Hi, I'm new to Sharepoint and I have an issue where I'm not able to find a way to share list data. What I tried to do is have 3 sets of lists each with their own columns and columns that they share. Each list has a custom level of priviledges: LIST.A: Column1 Column2 Column3 Column4 Access by users set.ALIST.B: Column1 Column4 Column5 Access by users set.BLIST.C: Column1 Column2 Column4 Column6 Access by users set.C Is there a way to do this? Thanks,Nikola

Yes that helps. So if you enter an item in list one. It copies the columns shared to list 2 as a new item that you can go in and update. And also copies a couple columns to a new item in list 3 that also has its own columns to update?In that case you can set your three lists but your going to have an issue preventing people from modifying column 1 in list 2 and 3.But from a quick think through here you would setup a flow to trigger on new item creation on list 1 to copy the column data over to list 2 that you needed. Then a flow on list 2 that when new item created copy the columns over to list there that’s needed. Then you would edit the forms on list 2 and 3 to lock or make the fields from the other lists read only and only allow updating the unique columns to the respective list.The only problem thou if anyone figures out how to use quick edit on the list they can bypass the read only on those fields and change them since you can’t really lock down columns on SP if you have edit rights to the row.

Not sure what you mean by Share Data? You can setup site columns if you you mean that they share the same drop down data or base them off other lists, but if your talking about just showing different columns to different users you cannot do that out of the box there is no column level security.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 Column4LIST.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

Multiple sharepoint lists sharing same columns

Deleted
Aug 23, 2018
Not sure what you mean by Share Data? You can setup site columns if you you mean that they share the same drop down data or base them off other lists, but if your talking about just showing different columns to different users you cannot do that out of the box there is no column level security.

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.
- Nikola Nenadovic
  Brass Contributor
  Aug 23, 2018
  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.
  - jcgonzalezmartin
    MVP
    Aug 23, 2018
    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

Forum Discussion

Multiple sharepoint lists sharing same columns

Share

Resources