Power Platform Community Forum Thread Details

Hello

I have created a workflow that reports entries in a SharePoint Excel in a Teams chat.
that works so far
Excel sometimes contains an image (as a link).
I would also like to display the picture (nit the link!) in a teams chat.

But I can't manage that. I only get the link in the message, but not the image itself

can someone tell me how to do this?

Categories:

Building flows

@FA-19021302-0,

Teams doesn’t render SharePoint images directly, you can convert the image to a Base64 string and use adaptive cards to display it.

Use the "Get file content" action in Power Automate to retrieve the image.
Ensure you retrieve the content as Binary.
Use the "Compose" action - base64(body('Get_file_content'))
Add a "Post an adaptive card" action.

{
    "type": "AdaptiveCard",
    "body": [
        {
            "type": "Image",
            "url": "data:image/png;base64, @{outputs('Compose')}",
            "size": "Medium"
        }
    ],
    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
    "version": "1.3"
}

Alternate Approach

Make sure the Images is shared with "Anyone with the link".
You use the direct URL instead of a SharePoint file path.
You can embeed the URL inside an Adaptive Card .

{
    "type": "AdaptiveCard",
    "body": [
        {
            "type": "Image",
            "url": "https://yourcompany.sharepoint.com/sites/library/image.png",
            "size": "Medium"
        }
    ],
    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
    "version": "1.3"
}