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.
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
- Thanks Rob, its exactly as you said, the issue is that I don't know how to do the 2nd point as I am only new to Power automate and know the basics, if you can direct me or have any example i can read, I will be thankful to you.
