How to Send a SharePoint Image Column Picture in an Email Using Power Automate | 2023 Tutorial

Hi Everyone,

In this video, I demonstrate how to take a SharePoint Image List Column and send the image in an email. There are a few steps in this one and some custom expressions, so I will include the expressions below. Also, check out the guide I followed by TorbenP in the link below! Thanks!

WRITTEN GUIDE BY TORBENP:

Custom Expressions:

WILL HAVE TO REPLACE SOME VALUES WITH YOUR SHAREPOINT LIST/COLUMN NAMES

Send an HTTP Request to SharePoint (URI)

Uri: /_api/lists/getbytitle('birthday%20list')/items(items('Apply_to_each')?['ID'])/BirthdayImage

Get File Content

File Identifier: encodeUriComponent(replace(body('Parse_JSON_2')?['serverRelativeUrl'],'/sites/Marketing',''))

Send an Email HTML CODE

Code: img src='data:image/png;base64,base64(outputs('Get_file_content')?['body'])' /

If you enjoy my video feel free to like, comment, and subscribe!

#powerautomate #sharepointlist #sharepoint

[zaktoubi]

the only video that makes my flow run smoothly, thank you. I spend 2 days searching on google with no hope.

[GeorgeZeidan]

Thank you for sharing mate. The ideas in this video also helped me with another issue I was having. Thank you so much once again.

[jhonrymat]

despues de mil videos, por fin encontre la solucion guiado con tu video, muchas gracias. no entiendo como solo tiene 3 me gusta.
eres el mejor, saludos desde colombia

[Nazhoglit]

thx this was my first approximation to the sharepoint rest API and its very easy to use, thanks you very much <3

[csmtiltm]

Thanks, It was really helpful for me!!

[suhaimsh]

Hello @Michael Alex, you are a wonderful explainer, this your 2 videos for the Birthday flow has helped me resolve my query which was pending for a long. Can you please show us how to change the background of Email body as well please, this would be the perfect flow.

[abuena]

How about if the image column value is blank? Or you have more than one image column and one has value the other dont have? What does flow looks like?

[bwnvvlw]

Hi Michael,
Thank you so much for the solution. It helped me so much.
However, I have a error in the send of the email.
The email send without the image, although the flow run correctly and I verificated that the image was imported correctly too.
Any solution? or any problem that I don't consider?
Your answer would help me a lot
Thanks

[barbaragualberto]

Thank you very much! Genuine question though, how can I send this image as an attachment?

[dabketroop]

Great video, I have 3 image columns, followed your video, it works great however if I didn't add image to the column, I get error that it is empty, so I added ["string", "null"]. the 2nd Parse Json is giving me error. Any idea?

[ignacioarredondohernandez]

How can i do the same but store the photo in a sharepoint folder, not send by email?

[qeprzix]

When I run the flow, my compose box output is completely empty. Why is that?

[NikhilRaj-vyvh]

Image is not loading in outlook after this succesful flow. Can you please help here?

[LetsTalkPowerBI]

Hi :) the Video helped me a lot but maybe you could also mention that the Image in SharePoint is now a reserved Attachment and If you want a Image you have to diable the attacments in the SharePointList setting :) I searched yesterday nearly the whole day after this small detail and was wondering why my flow dosen't work :D

[mageshkrishnan]

Hi Michael,
Great session, working perfectly fine in a mail but Same process followed for posting the image in a team's chat but doesn't work. Could you help me out for posting the image in a team chat/channel?

[benjaminlahsen]

Hello! I have troubles with the Compose action. As soon as I run the flow the execution log says:


When in fact Parse Json is retriving the content form the SP list

[shweta]

i am not able to get server relative uri. please help me

[narutostudio]

I have followed the parson image json step but only the .png file appears without the serverurl of the parse image json, how can I solve it?

[Felixz]

4:28 Why is there a difference between what you copied from Compose and what you're pasting into Parse JSON?

[kavyar]

I followed the steps and got the result for first time, but when I tried the same steps for new list, I'm getting the mail without image. Everything is working fine till Parse Json but something is wrong in get file content which is giving too long output. Can you please help me to solve this problem?