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

hello everyone Michael back with another video in this video I'm going to show you how to send an image from a SharePoint list image column in a send an email in power automate enjoy SharePoint teams power automate power-ups videos feel free to subscribe because I'll be putting out more videos in those areas so let's get into the video so I'll be using a previously made below my birthday email flow that pretty much just sends at today's date equals this birthday right here then it's going to send an email to that person saying hey happy birthday hope all is well and if you want to go see that video it'll be in the description so I'm just grabbing uh items I'm grabbing all the items from the SharePoint list so I'm doing a quick check to see if the today's date is equal to the date in the SharePoint list and now I want to add an image to that so I have two images linked and I made these birthdays the same I'm actually using a guy by Orbin P I'll send the link in the description so you can follow along I'm just making a video of how to do it so if today's date is equal to the date in my birthday I want to send the image along in this file so the first action we have to do send in HTTP request to SharePoint so this is going to grab the image I will use the marketing SharePoint the get method because I want to grab something then for the URI all right so in my case for the SharePoint list it's going to be so backslash underscore API slash list slash get by title and in parentheses and single quotes it's birthday space so the space will be percent sign 20 list and this comes from this name right here birthday list that's going to be backslash items um parentheses to get items ID so in my case it'll be the supply to each since I'm looking at every single Row in this SharePoint list has to go through each one so in this case if it was the first row on the list it would just look at this list and grab that ID and then you want to do backslash the column name in my case it's birthday image and to get that column name you want to go click on the gear icon in your SharePoint list list settings birthday image so as you can see has a space right here but if we look at the URL this is the correct column name you want to use there's no space there so we won't include a space and our URI and that is all we need for this step Next Step actually let me drag this above since I need to grab the image first to send in the email all right so let's go ahead and run this flow I want to cancel this because I don't want to send the emails yet so I will do has failed and that's just going to not send out the emails when I run this flow all right we'll go ahead and test it manually okay let's go into our first item and just grab the output so if it works correctly you'll see the image right here this code on my case I have a picture of a rhino and has the file name right here so I know it's the grabbing the correct picture let's go back to edit and then we want to do another step in this step we want to do parse Json and for the content I want to use the body from the Sun HTTP request and then for the generate from sample you're going to use the output from the HTTP requests which I copied so it'd be the column name all right let's go ahead and do a compose action now and from the parse Json I want to grab the birthday image or whatever your column name is let's go ahead and press save now you want to get this output test manually all right we're going to copy this output so we're gonna actually delete this compose statement now and add another parse Json so we're going to use the birthday image now and for the schema we're going to generate from sample and use the copied output from the post name we just deleted and it should give you a schema next we're going to get the file content so it'll be file content or just get file content and none of the other SharePoint ones I'm gonna use marketing then for the file identifier it's going to be in code gri component replace and then for the parse json2 which is the second parse Json step so whatever you renamed it or if you left it like this you're going to want to get the server relative URL and you just want to put that in the parentheses for the replace statement and after the bracket you want to put single quote backslash sites backslash your SharePoint site name so in my case it's marketing if I close the single quotes and then you just want to do two single quotes with nothing in between it and I'll put some of the code in the description but I will recommend with the website where I'm following the guy from for all these steps oh we got the encode URI component in the get file content so now in our send an email step I have what previously I had so just a good morning we'll see happy birthday hope you have a great day so now we have to add some HTML code so if you click on this code view button right here it'll actually bring you the HTML of the email and these BRS they mean breaks Libya new line so after my message I want to include the image so this is what the code will click bracket IMG space SRC equals single quote data colon image slash PNG semicolon base64 comma and then we wanted to use an expression this would be base 64. now if we go back to our Dynamic content you want to click on the file content and that'll bring you the outputs of the git file content body go ahead and press OK a single quote to close up the single quote after the equal sign and then we will close the bracket with the backslash closing bracket all right and then I will include a break just so there's a space from the image from the thanks let's go ahead and save this all right and then we will test it we'll see if my code is correctly written right the flow is successfully Ran So on my birthday list I have two birthdays today and these are the images so let's go to my email all right these are some old ones and these are the new ones so we have Danny's birthday today we just want to wish you Happy Birthday and here's the image picture of Geodude and that matches our image online and then we have a picture of a rhino for Mo we just want to wish you happy birthday we hope you have a great day Moe and the picture of the Rhino will that'll be how you add an image from a SharePoint list image column to your emails it's a lot harder it shouldn't be this hard I hope Microsoft makes an easier way to do this by just uh adding the image to the dynamic content but maybe in the future um definitely check out the guide that tarbon P wrote and explains these steps in more detail and how to set the width and height of your pictures in the output that'll be a video for today I hope you enjoyed it if you like the video feel free to like comment subscribe if you have any questions leave them in the comments down below and I will catch you in the next one

Channel: Michael Alex

Views: 13,937

Keywords: Microsoft, Microsoft Forms, Forms, Microsoft SharePoint, SharePoint, Teams, Power Automate, Power Platform, Microsoft Flow, Flows, Automation, Tutorial, Guide, 2022, Microsoft Outlook, Outlook, Email, image column, image, image power automate, sharepoint image column, sending an image, image to power automate, sending images

Id: gg66XkEG7xQ

Length: 8min 24sec (504 seconds)

Published: Thu Feb 09 2023