Power Platform Community Forum Thread Details

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.

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

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

Thank you 🙂

Categories:

General topics

Hi @jharville ,

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

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).

You can try the following flow:

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

Then enter the following expression for the Map value

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:

{
 "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