Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Issue showing images in email from URL

(0) ShareShare
ReportReport
Posted on by 25

Hello there,

 

I am working on a MS Flow in Power Automate that will run once a month and email out a list of new pages on a Sharepoint site. I use Get Files (Properties Only) on the sharepoint and direct it to Site Pages and apply a ODATA filter to show only those added and updated in the last 31 days. This works great, however I am trying to format a HTML table to show the banner image, name and description of the page:

 

Paul_Gibson_0-1645453863379.png

The issue is this works perfectly well in the Web version of Outlook, but not the desktop application. The Banner Image is a direct URL to where the image is stored. I have tried the following steps to no avail:

 

1) Added data:image/jpeg;base64 to the img tag, this only broke the Web version

2) Split the URL and created a path string to use Get File content using path and then using this file content composed this through base64 and used this, this still didn't work (it took more than 15 minutes to run a test so I cancelled this as with out this step it runs in 7 seconds).

 

As the banner image will be different for each page, I can not hard fix the file as I would normally so this needs to be possible using the files URL. I have included screen shots of my App and Web Mail to show what I mean:

 

Paul_Gibson_1-1645454408574.png

 

Paul_Gibson_2-1645454455026.png

 

  • mason007 Profile Picture
    mason007 31 on at
    Re: Issue showing images in email from URL

    Thanks so  much! I was able to use your first link and followed the video - https://www.youtube.com/watch?v=z32ng9_bCAY. I have it working!

  • mason007 Profile Picture
    mason007 31 on at
    Re: Issue showing images in email from URL

    Rafia2500, I couldn't follow your flow as not all the steps were visible. I could follow this one step by step and got it to work:

     

    https://powerusers.microsoft.com/t5/General-Power-Automate/Weekly-sharepoint-news-digest/td-p/197467

     

    But still don't know how to get the images into the email.

     

    mason007_0-1689546186581.png

     

    Is it possible for you to show your steps similar to the way it is in the above link? Or how I can incorporate the image into the one I have working now? Thanks again!

  • mason007 Profile Picture
    mason007 31 on at
    Re: Issue showing images in email from URL

    Thank you so much Rafia2500! I will work with this and post back results or issues I encounter. Appreciate this!

  • Rafia2500 Profile Picture
    Rafia2500 4 on at
    Re: Issue showing images in email from URL

    Rafia2500_0-1689138041654.png

     

    Rafia2500_1-1689138108964.png

     

    Rafia2500_2-1689138212746.png

    Rafia2500_3-1689138266354.png

     

    hi @mason007  I have shared the steps in my flow.. it will send email to the selected recipient the output of the last HTML  action...  you can add CSS of your choice. Hope this will help you to resolve the issue. I am using a condition + an saved image in my library because in my case I want that if the post do not have the image use my default image you can skip this image initialization + the condition... perhaps use the other steps in the condition to get the post + images. 

     

    If you still have any questions feel free to ask. 

    if this helps you kindly mark it as the solution. 

  • mason007 Profile Picture
    mason007 31 on at
    Re: Issue showing images in email from URL

    Hi Rafia2500! I wanted to have more than one article in the email - so the top 5 news post in a single email. I followed the above link (https://collab365.com/using-flow-sharepoint-news-notifications/) which worked for one news post but not more than that. So I wanted the email to look like below, where I can specify how many articles.

     

    In the very first question, it seemed that Paul Gibson had already had this set up but it wasn't showing images on Outlook desktop/client version. I want to automate the news posts (weekly) in an email to users, with a link to all the news. Does this help with what I'm asking? Thank you!

     

    mason007_0-1689079678826.png

     

  • Rafia2500 Profile Picture
    Rafia2500 4 on at
    Re: Issue showing images in email from URL

    Hi @mason007!  hope you doing great... I have managed to resolve the issue. Would be pleased to help if you can more elaborate on the issue you are facing. 

  • mason007 Profile Picture
    mason007 31 on at
    Re: Issue showing images in email from URL

    Paul Gibson - can you share your flow for your newsletter email? I used the below instructions, but it only has one article per email: https://collab365.com/using-flow-sharepoint-news-notifications/


    Thanks!

  • Re: Issue showing images in email from URL

    I was following your mentioned steps and after splitting I got this.. which I don't know how to use 

    Rafia1_0-1658317384034.png

     

  • Re: Issue showing images in email from URL

    thank you so much for your reply... which field did you add there? Kindly explain... if possible can you share the expanded screen shoots of your flow would be a great help.

    thanks again.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics