Forum Discussion
Nikola Nenadovic
Aug 23, 2018Brass Contributor
Multiple sharepoint lists sharing same columns
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 sha...
Deleted
Aug 23, 2018Yes 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.
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.
Nikola Nenadovic
Aug 24, 2018Brass Contributor
So you suggest using flow as the best solution to the problem here?
- Matt WestonAug 24, 2018Iron Contributor
Yes, given the additional information that you've provided I don't think there are many other options whilst keeping things out-of-the-box.
The way Deleted describes is pretty much the same as my option 2, where you use Flow to duplicate the content from your master list to the child lists. As you want this done automatically, that's the only way you're going to be able to do it.
If you were manually entering items into the child lists, you could have used lookup columns to your master list, which would then have allowed you to only have the unique "master" data stored once.