You’re offline. This is a read only version of the page.
101
Hi Power Automate community,
I am storing new items of RSS feeds (RSS item = publishing of videos) in a Sharepoint list. Everything is working well when it comes to applying the Dynamic Content to the columns of the list. However, the Dynamic Content is limited to a few 'data points' like Feed Title (title of video), Item URL (link to video), Feed Summary (video description) and a few more. Additionally, I need the duration (in seconds) for each video to be stored in the Sharepoint list as well. The duration is published as part of the <media:player> tag, sample of the feed below:
Is there a way to retrieve the duration of each RSS video item? If so, what would be the smartest approach in order to execute it within Power Automate?
Thanks in advance for your help.
Best
Hi @Expiscornovus,
Thanks for this idea. My PA/Postman skills are likely limiting me on playing around with this idea but thanks anyway. Appreciated.
Hi @sebkath14,
One approach could be to create a Postman collection for your rss feed. Export that and import it into the Power Platform as a custom connector. After that you should be able consume all the properties of your feed.
However, this does require some additional xml logic/xpath logic in your flow setup. And the easiest version of that approach is not trigger/webhook based, but probably on a schedule.
Hi @sebkath14,
I don't think it is possible with that trigger action. If you want to use it in your flow it should be at least available in the outputs of your trigger action. But unfortunately I don't see any media content tag being retrieved.
Can you also double check this in your outputs?
Hi Expiscornovus,
It's a very simple flow that is working well for each output that is detected as Dynamic content (screenshot blow). My assumption is that the <media:content> tag is not part of the official RSS specification and thus not supported by the connector.
Would it be possible to retrieve the information through analysing the string and somehow extract the part of the string that can be found between duration="number". My feeling says that this should be achievable though I am lacking the skill for this. lol
Best
Hi @sebkath14,
Just to double check. Which actions are you using in your flow setup? Can you share a screenshot.
Btw, I just tried a couple of RSS feeds with media contentn (like CNN video feed). When I use the List all RSS feed items action I don't see the media:content elements at all in the output of that specific action. Might be a limitation of the connector.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
