I have a custom list for 'Products' in my top site collection, and I have two sub sites where I need to display the same information.
I have copied the Products list as a list template into b oth sub sites, and I can use the copy feature in Content & Structure to copy across data when an item is added or modified.
Any of the 3 lists can be modified by different users/departments I want to add an operation to the lists to automatically update when an item is modified or added. So, adding an item at top level will update the 2 sub site lists, and vice versa.
I am using SharePoint 365 Online. What's the best way to approach this?
I know I can't use an SP Designer workflow as it will not allow site to sub site copy - although I'm aware a custom workflow could be used if built in Visual Studio.
Another option is writing an event receiver in Visual Studio. I'm not sure if this can be written using the free Visual Studio application (VS Community)? And, I have not experience of writing code or using Visual Studio. Any thoughts/help would be much appreciated!