Data - Retrieving news/forum/blog articles with RSS

RSS (Really Simple Syndication) feeds make it possible to retrieve updates to blog sites, forums, social media, and news sites. An RSS feed contains XML that describes newly published content. This typically includes an article title and description, author, web link, and other details.

RSS feeds were very popular around 10 years ago. They are less popular today, but still serve a useful purpose if we want to retrieve content from web sources that provide RSS feeds.

Finding RSS feed URLs

Most news websites provide RSS feeds, and a search on the web can reveal the URL. For example, the following site returns a list of RSS address for popular UK news websites.

https://blog.feedspot.com/uk_news_rss_feeds/


Another useful resource is this article from Zapier. This post describes how to find the RSS URL for a wide range of websites. For example, the RSS feed address for most Wordpress based blogs/websites is to append /feed to the end of the website address.

How to retrieve a RSS feed from Power Apps

To consume a RSS feed from Power Apps, we add a data source using the RSS connector.


The RSS connector provides a method called ListFeedItems. This method accepts an RSS feed URL, and the formula beneath shows the syntax to retrieve an RSS news feed from the BBC.

RSS.ListFeedItems("http://feeds.bbci.co.uk/news/uk/rss.xml")
We can apply this formula directly to the Items property of gallery as shown below, or we could collect the output to a local collection, and save the content to a database.



The fields that we can access from an RSS feed include the following:

id, title, primaryLink, links, updatedOn, publishDate, summary, copyright, categories
For more details on the RSS connector, we can refer to the documentation here:

Conclusion

We can retrieve recent news, forum, social media, and blog content by accessing RSS feeds. This post described how to access RSS feeds by using the RSS connector.

Related posts

Data - How to remove trailing comma all rows in a table
February 20, 2025
Data - How to find the common rows from 3 or more collections
October 06, 2024
Data - How to show the distinct rows from 2 data sources or collections
February 26, 2024
Data - How to implement circular rotational date sorting
February 21, 2024
Bug - What to do when the data section of the Power Apps Maker portal doesn't work
June 18, 2023
Data - Combine columns from separate tables into a single table
October 13, 2022
Formula - Transposing/converting rows to columns- an almost impossible task?
September 23, 2021
Data - How to rename field names in a record
July 14, 2021
Data - How to hide duplicate rows in a gallery / show distinct multiple columns in a gallery
July 09, 2021
Data - How to sort by partial numbers in a text field
June 23, 2021
Data - How to return the last record from a table
June 19, 2021
Data - How to create bulk test/dummy records with random values
June 18, 2021
Data - 3 things you should know before using the MySQL or PostgreSQL connectors
May 11, 2021
Data - A walkthrough of how to migrate the data source of an app from Excel to Sharepoint
April 26, 2021
Data - How to enforce unique values (or prevent duplicate values) in one or more columns
April 19, 2021
Data - How much mobile data does Power Apps consume? What ways can we minimise this?
March 28, 2021
Data - How to save and retrieve Google calendar entries
March 14, 2021
Data - How to save and retrieve Google contacts
March 10, 2021
SQL - Caution! This is how users can hack shared SQL connections
January 23, 2021
SharePoint – 2 Mistakes to avoid when importing Excel data
January 10, 2021
SQL - Don't let this DateTime bug catch you out!
January 05, 2021
Settings - What's the purpose of the "Explicit Column Selection" Setting?
January 04, 2021
SQL Server for Beginners Part 3 - Installing On-Premises Gateway
January 24, 2019
SQL Server for Beginners Part 2 - Installing Management Studio
January 14, 2019
SQL Server for Beginners Part 1 - Installing SQL Server
January 04, 2019
Searching data–What you need to know about case sensitivity
December 27, 2018
Images - How to create images that can change depending on data
November 09, 2018
Excel - Reasons NOT to use Excel as a data source
September 25, 2018
SharePoint - What you need to know about Filtering Data
September 16, 2018
Formulas - Generating Row Numbers
April 05, 2018