Blog
Data - Retrieving news/forum/blog articles with RSS
June 26. 2021
If you want to build an app that retrieves, displays, aggregates, and saves news articles, one way to acomplish this is to use RSS. This post describes how to retrieve content by using the RSS connector in Power Apps.
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.
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, categoriesFor 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.
- Categories:
- data
Related posts
- Data - How to find the common rows from 3 or more collections
- Data - How to show the distinct rows from 2 data sources or collections
- Data - How to implement circular rotational date sorting
- Bug - What to do when the data section of the Power Apps Maker portal doesn't work
- Data - Combine columns from separate tables into a single table
- Formula - Transposing/converting rows to columns- an almost impossible task?
- Data - How to rename field names in a record
- Data - How to hide duplicate rows in a gallery / show distinct multiple columns in a gallery
- Data - How to sort by partial numbers in a text field
- Data - How to return the last record from a table
- Data - How to create bulk test/dummy records with random values
- Data - 3 things you should know before using the MySQL or PostgreSQL connectors
- Data - A walkthrough of how to migrate the data source of an app from Excel to Sharepoint
- Data - How to enforce unique values (or prevent duplicate values) in one or more columns
- Data - How much mobile data does Power Apps consume? What ways can we minimise this?
- Data - How to save and retrieve Google calendar entries
- Data - How to save and retrieve Google contacts
- SQL - Caution! This is how users can hack shared SQL connections
- SharePoint – 2 Mistakes to avoid when importing Excel data
- SQL - Don't let this DateTime bug catch you out!
- Settings - What's the purpose of the "Explicit Column Selection" Setting?
- SQL Server for Beginners Part 3 - Installing On-Premises Gateway
- SQL Server for Beginners Part 2 - Installing Management Studio
- SQL Server for Beginners Part 1 - Installing SQL Server
- Searching data–What you need to know about case sensitivity
- Images - How to create images that can change depending on data
- Excel - Reasons NOT to use Excel as a data source
- SharePoint - What you need to know about Filtering Data
- Formulas - Generating Row Numbers
