From the course: Excel: Automating Tasks with Power Automate

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Retrieving data from external sources

Retrieving data from external sources - Microsoft Excel Tutorial

From the course: Excel: Automating Tasks with Power Automate

Start my 1-month free trial Buy for my team

Retrieving data from external sources

“

So far, we've focused on using internal data in Power Automate, like adding form data to Excel or sending emails based on workbook data. But Power Automate can also handle external data such as RSS feeds. RSS feeds provide regularly updated content like news or blog posts. Automating the process of adding these updates to an Excel table allows analysts to track trends in real time without manual input. Although Power Query is often used for importing external data into Excel, it struggles with real-time updates like those from RSS feeds. Power Automate, on the other hand, is better suited for handling live data feeds, making the automation process smooth and efficient. For dynamic data like RSS feeds, Power Automate is more effective, while Power Query excels at batch processing and manual refreshes. Let's walk through how to automate RSS data collection into Excel. I provided a starter file retrieve-rss-feed.xlsx. We'll use this file to store the post date, summary, and link from…

Contents