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, 2018I think we get the whole column thing. What we don’t understand is the actually data in the lists. This data being entered is all unuiqe to each list? No relation to each other other than they are Input with similar columns?
Nikola Nenadovic
Aug 23, 2018Brass Contributor
Let me try to explain this way:
LIST1
COLUMN1: Project code(unique)
calculated value based on other columns
COLUMN2: Project name
COLUMN3: Project details
COLUMN4: Deadline 1
COLUMN5: Deadline 2
COLUMN6: Status (copy from list 3)
LIST2
COLUMN1: Project code(unique) (copy from list1)
COLUMN2: Project name (copy from list1)
COLUMN3: Deadline 2 (copy from list2, column5)
COLUMN4: Specification
LIST3
COLUMN1: Project code(unique)
COLUMN2: Project name (copy from list1)
COLUMN3: Specification (copy from list2)
COLUMN4: Status
- 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.
- Nikola NenadovicAug 24, 2018Brass Contributor
So you suggest using flow as the best solution to the problem here?
- DeletedAug 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.