How to access one particular element of an RSS item?

[TimBourguignon]

I have an RSS Link containing a bunch of items like the following:

<item>
	 <title>CincyDeliver></title>
	 <description><p>CFPs Due: 2019-04-26</p><p>Conference Date: 2019-07-26</p><p>Location: Cincinnati, U.S.A.</p>></description>
	 <link>https://www.cincydeliver.org</link>
	 <guid isPermaLink="true">https://www.cincydeliver.org</guid>
	 <category>DevOps></category>
	 <pubDate>Fri, 26 Apr 2019 00:00:00 GMT</pubDate>
	 <eventStartDate>2019-07-26</eventStartDate>
	 <cfpEndDate>2019-04-26</cfpEndDate>
	 <isNew>false</isNew>
	 <location>Cincinnati, U.S.A.</location>
	 <perksList>None</perksList>
  </item>

The RSS connector successfully gets the Title, Description (summary) and Link (among others), but I cannot figure out how to access the other elements of the XML, for instance the "eventStartDate" and "cfpEndDate". Any idea?

Thanks!

[Brad_Groux]

You can use the xml() expression to parse XML content and the xpath() expression to select a particular XML node.

Compose 1:

<?xml version="1.0"?>
<Users>
           <eventStartDate type="System.String">2019-07-26</eventStartDate>
</Users>

Compose 2:

xpath(xml(outputs('Compose')),'string(/eventStartDate)')

The following links should point you in the right direction: 

• Use expressions in Flow actions
• HTTP – calling webservices, XML vs JSON
• A Visual Explanation of Flow Logical Expressions
• Parse XML Using Microsoft Flow (See Solution)

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. THANKS!

[v-bacao-msft]

Hi @TimBourguignon ,

Could you share screenshots of Flow configuration?

Basically, as long as the RSS feed URL is populated in the trigger or action associated with RSS connector, Dynamic content can display all elements contained in the item.

Is it convenient for you to provide the corresponding RSS feed URL? I tested it on my side using the feed URL corresponding to MS Flow Blog, all the elements in the item can be obtained.

Image reference:

If you can't get the corresponding Dynamic content when you reference element, it may be because the type does not match, you could use Compose to store the corresponding Dynamic content.

Best Regards,

[TimBourguignon · Accepted solution]

Thanks for both your responses. I just realized that the feed (https://feeds.cfpland.com/v2/rss/cfps) is the problem.

It was not created correctly and thus the fields I am trying to access are not available: https://validator.w3.org/feed/check.cgi?url=https%3A%2F%2Ffeeds.cfpland.com%2Fv2%2Frss%2Fcfps