Forum Discussion
Multiple sharepoint lists sharing same columns
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
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.
So you suggest using flow as the best solution to the problem here?
- 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.
