Illustration of a person using a computer with connected data visualizations and technological icons. The text reads 'Sanitize RSS Feed Using SharePoint Power Automate' along with the website URL 'www.200oksolutions.com'. The design features a dark blue background with purple and blue accents
Home / PHP / Sanitize RSS Feed Using SharePoint Power Automate
PHP

Sanitize RSS Feed Using SharePoint Power Automate

Share this post on:

RSS feeds are a popular way to distribute news and updates, but sometimes they include special characters that can cause issues when processed or displayed. Fortunately, Power Automate provides a powerful way to handle and clean up these feeds. In this blog post, we’ll go through the process of removing special characters from a news RSS feed using Power Automate.

Prerequisites:

  • Microsoft account with access to Power Automate.
  • Basic understanding of RSS feeds and Power Automate flows.

Steps to Create flow:

  1. Go to [Power Automate] (https://flow.microsoft.com) and sign in with your Microsoft account.
Screenshot of the "Automated cloud flow" option in a flow creation menu. It is described as being triggered by a designated event.

2. Click on “Create” in the left-hand menu & Choose “Automated flow” to start with a flow that triggers automatically.

Screenshot of the Power Automate flow builder with the "When a feed item is published" trigger selected.

3. Select a trigger that fits your needs. For RSS feeds, you might use “When a feed item is published” or a similar RSS-related trigger. Configure the trigger with the URL of your RSS feed.

Power Automate flow builder with the "When a feed item is published" trigger selected. The user is configuring the RSS feed URL and advanced parameters for the trigger.

4. Click on New step.  Search for “RSS” and select “List all RSS feed items” or similar action depending on your trigger. Map the fields from the RSS feed to get the content you need. This often includes fields like the title, description, and link of the news item.

5. Click on New step then Search for and select “Compose” or “Data Operations – Compose.”

Power Automate Compose action with nested replace functions to clean up the variable 'test' by removing '&', 'nbsp;', and 'specialChar3'.


6. If you want to store the cleaned content in a SharePoint list or database, add the appropriate action (e.g., “Create item” for SharePoint). For now we are storing output in compose it self.

Power Automate flow test options dialog. Choose between manual or automatic testing, and view recent test results.


7. Save your flow and test it by triggering the RSS feed.

8. Verify that the special characters are correctly removed and that the cleaned content is stored or used as intended.

Power Automate Compose action with input text containing special characters like '&' and 'nbsp;'. The Compose action is used to remove these special characters from the input text.


9. Check the output in your storage system or destination to ensure the content appears as expected. As shown output of our input.

Conclusion:

By following these steps, you can efficiently remove special characters from news RSS feeds using Power Automate. This process ensures that your content remains clean and suitable for further use or display.

Related Post:

If you’re interested in learning more about managing content and user access within your organization, check out our guide on How to Enable and Manage Guest Users for Site Sharing in SharePoint. This post will help you streamline collaboration while ensuring security in SharePoint.