Forum Discussion
Solved
Sharepoint Master list sync with List A.B,C etc
Hell Guys. I have a challenging issue. I have a Master List and another lists, let's say list A list B list C list D list E. I need when List A or B or C or D or E get a new Item it gets registered...
whissi SharePoint is not a full relational database platform so I don't think there is any way you can do this with just SharePoint lists, you are going to need to build several flows in Power Automate:
- a flow that triggers whenever an item is created in list A and creates an item in the master list. Same for each of list B, C, D and E. You'd need to make sure in the master list you had columns for the "original list" it was coming from and the original list ID.
- a flow that triggers whenever an item in the master list is modified. You would need to initialise a variable to hold the "original ID" number and include in your flow a switch control (a type of condition) that looks at which "original list" would need to be updated. In each case within the switch you would need an update item action for that particular list with ID from the variable.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- a flow that triggers whenever an item is created in list A and creates an item in the master list. Same for each of list B, C, D and E. You'd need to make sure in the master list you had columns for the "original list" it was coming from and the original list ID.
This depends on what you are trying to accomplish.
Do you really want the list items being copied and synced between the lists?
Then you will most likely need a PowerAutomate Flow that copies the items
Or do you just want a combined view of all items in the A,B,C,D and E lists?
In that case you could try to use the "Highlighted Content" Webpart or the PnP Search Webparts to aggregate Data from multiple lists into a single view... Or create a PowerApp.
Or just have one List with four views.
Do you really want the list items being copied and synced between the lists?
Then you will most likely need a PowerAutomate Flow that copies the items
Or do you just want a combined view of all items in the A,B,C,D and E lists?
In that case you could try to use the "Highlighted Content" Webpart or the PnP Search Webparts to aggregate Data from multiple lists into a single view... Or create a PowerApp.
Or just have one List with four views.
Hello Sven, its like Rob explained in his reply.
