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:
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:
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!
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.
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!
Thank you so much Rafia2500! I will work with this and post back results or issues I encounter. Appreciate this!
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.
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!
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.
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!
I was following your mentioned steps and after splitting I got this.. which I don't know how to use
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.