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
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