Forum Discussion
Display custom list data in web part in another SharePoint Online site collection
Arnie_Howes you don't need to build your own web part, this can be done with a flow in Power Automate. Basically you have your main list and on the other site you have another list that is exactly the same structure and you use the flow to copy the items to the second list whenever an item is created or modified. Then you display the data from that second list in a list web part on a page on the second site. If it doesn't need to be in exactly real time then you could have it run once a day for example or ever 2 hours or on whatever schedule you need using the Recurrence schedule trigger.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Rob, if you use a Flow, does the secondary list have to be the exact same structure as the primary. I have a challenge where I have a master list (locations) that has lots of detail that most teams don't need. (we are the IT group). In a perfect world, we would have specific views on different pages of our intranet site that were tailored to the page s department like sales or HR.
- No it doesn't have to have exactly the same structure.
Thanks, RobElliott. I had previously thought of that, but was hoping someone had a silver bullet that didn't require duplicating. So far, that seems to be the best solution!
Arnie_Howes with the Power Apps app solution, unlike the flow, you aren't duplicating the list. It is working with the live list on the main site and displays it.
Rob
