cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TimBourguignon
Resolver I
Resolver I

How to access one particular element of an RSS item?

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3
Brad_Groux
Community Champion
Community Champion

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: 

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
Community Support
Community Support

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:

5.PNG

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,403)