Pull image URL from Yammer Post

[Tono_Analyst2]

Hi,

I have a Yammer trigger 'When there is a new message in a group" and there is an image attached to the post. 

In the raw output, I can see that there is a field called "downloaded URL" which has the image download link. 

How can I extract this as a string from the output?

[Expiscornovus · Accepted solution]

Hi @Tono_Analyst2,

I am assuming you only have one attachment in the Yammer message?

If so, you could use the following expression to retrieve that download_url of the first attachment item as a string value:

triggerOutputs()?['body/attachments'][0]['download_url']

However, there also should be a sharepoint_web_url property (which gives you a direct link to the file instead of a download link). They might even be better in your setup:

triggerOutputs()?['body/attachments'][0]['sharepoint_web_url']

[Tono_Analyst2]

That's exactly what I was after, thank you!