From static to live: Connect your SharePoint Copilot App to (live) external news
Give your Copilot-generated news board a live connection to external data—with Power Automate and a SharePoint list. In this second video demonstration, I extend the solution from Part 1 so that the dashboard can display updated news without recreating the HTML app. Why the first News Board needed an upgrade In the first video, I used a small Power Automate flow to retrieve news from an HTTP endpoint—an address that provides data from an external service. The flow saved the response as news-data.json in a SharePoint document library. Copilot then used that file to create an attractive HTML news board. However, the news entries were embedded directly into the generated HTML. The dashboard contained a snapshot of the data available when it was created. Updating the JSON file did not update the news board, because the app had no ongoing connection to its source. ...