Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to scan an RSS Feed and pull a variable/certain words (mentioned multiple times in that feed) to Power Automate as a dynamic variable.

(1) ShareShare
ReportReport
Posted on by

Hello all!

 

If I wanted to scan an RSS Feed and pull a variable (mentioned multiple times in that feed) to Power Automate, would you have any advice on this? I'm using the RSS Feed on the Microsoft O365 Roadmap and trying to manually pull items that have a current state categorization ('In Development', 'Rolling Out', 'Launched') and reference them as dynamic variables in Power Automate (that I plan on pulling into a Microsoft Planner), but running into issues. The RSS action for Power Automate helps pull all other variables except these current state variables when I try to use it, and I'm thinking it may be possible through manually parsing through the code and pulling/collecting info from there.

 

jharville_0-1720629518078.png

 

 

Every input parameter is available in the 'Preview' action except this state variable:

 

 

jharville_1-1720629409890.png

 

The RSS URL: https://www.microsoft.com/en-us/microsoft-365/RoadmapFeatureRSS/

 

 

Thank you 🙂

 

J

 

  • Ellis Karim Profile Picture
    Ellis Karim 10,511 on at
    Re: How to scan an RSS Feed and pull a variable/certain words (mentioned multiple times in that feed) to Power Automate as a dynamic variable.

    Hi @jharville ,

     

    I'm looking at the RSS feed and I see that the category property is an array with multiple values:

     

    2024-07-11_18-10-19.PNG

    It seems that you only want the RSS feed items that contain one of the following values in the categories (array):

    •  "In development"
    • "Rolling Out"
    • "Launched"

    We could add a new property called "status". The "status" property would be used to store the category value: "In development", "Rolling Out", "Launched" or null (empty). 

     

    2024-07-11_18-23-04.PNG

    You can try the following flow:

     

    2024-07-11_18-40-27.PNG

    Make sure you set the Select mode to "text mode" as shown below:

    2024-04-09_14-32-36.PNG

    2024-04-02_23-22-04.PNG

    Then enter the following expression for the Map value

    2024-07-11_18-41-19.PNG

     

    addProperty(
     item(), 'status',
     coalesce(
     if(
     contains(item()?['categories'], 'In development'), 
     'In development', 
     null
     ),
     if(
     contains(item()?['categories'], 'Rolling Out'), 
     'Rolling Out', 
     null
     ),
     if(
     contains(item()?['categories'], 'Launched'), 
     'Launched', 
     null
     )
     )
    )

     

    addProperty(item(), 'status', ...) - Adds a new property status to the current RSS feed item().

     

    The status property is set to:

    • 'In development' if found in categories, otherwise, the status property will be set to null.
    • Else 'Rolling Out' if found in categories, otherwise, the status property will be set to null.
    • Else 'Launched' if found in categories, otherwise, the status property will be set to null.

    The coalesce function returns the first value that is not null from a list of values. It will try all the if conditions. If all the values are null, coalesce returns null.

     

    You could use the "status" property to filter the RSS feed items and remove items that don't contain the category value "In development", "Rolling Out" or "Launched". The "status" property in this case will have been set to null and we can remove this "null" value items using the following Filter array action:

     

    2024-07-11_18-59-04.PNG

     

    2024-07-11_18-54-41.PNG

     

     

    {
     "id": "393936",
     "title": "Outlook: Entry point change - apps when reading emails moved to the ribbon",
     "primaryLink": "https://www.microsoft.com/microsoft-365/roadmap?featureid=393936",
     "links": [
     "https://www.microsoft.com/microsoft-365/roadmap?featureid=393936"
     ],
     "updatedOn": "2024-07-11 06:15:44Z",
     "publishDate": "2024-04-20 05:15:35Z",
     "summary": ",The Apps flyout and entry point for pinned apps will be moved to the Home tab in the Ribbon in the New Outlook and Outlook for Web. #newoutlookforwindows<br>GA date: September CY2024<br>Preview date: August CY2024",
     "copyright": "",
     "categories": [
     "In development",
     "Targeted Release",
     "Preview",
     "General Availability",
     "Desktop",
     "Web",
     "Outlook",
     "Worldwide (Standard Multi-Tenant)"
     ],
     "status": "In development"
    }

     

     

    Hope this helps.


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard