RSS Feed to Sharepoint List - Getting duration of video

(0) Share

Report

Posted on by sebkath14

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

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
sebkath14 101 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
sebkath14 101 on at

Like (0)

Report

Hi Expiscornovus,

I checked the outputs and there is no such information being triggered and retrieved. Seems I have to find another way 🙂

Best

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
sebkath14 101 on at

Like (0)

Report

Hi @Expiscornovus,

Thanks for this idea. My PA/Postman skills are likely limiting me on playing around with this idea but thanks anyway. Appreciated.

Was this reply helpful? Yes No