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

No video

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

Рет қаралды 18,255

Michael Alex

Күн бұрын

Пікірлер: 56

@zaktoubi6731 Жыл бұрын

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

@michaelalex2322 Жыл бұрын

Glad it worked, this one was more difficult

@Nazhoglit 4 ай бұрын

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

@michaelalex2322 4 ай бұрын

You are welcome!

@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

@michaelalex2322 Жыл бұрын

Happy it helped!

@raissacamargo4436 4 ай бұрын

Perfect video! Thanks

@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.

@michaelalex2322 Жыл бұрын

No problem 👍

@suhaimsh2076 8 ай бұрын

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.

@LetsTalkPowerBI 9 ай бұрын

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

@csmtiltm5910 6 ай бұрын

Thanks, It was really helpful for me!!

@michaelalex2322 6 ай бұрын

You're welcome!

@user-bw8nv9vl1w Жыл бұрын

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

@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?

@abuena73 Жыл бұрын

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?

@leandroneets 8 ай бұрын

thank you.

@michaelalex2322 8 ай бұрын

You're welcome

@barbaragualberto810 9 ай бұрын

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

@mageshkrishnan7972 7 ай бұрын

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?

@MatthewNelson 9 ай бұрын

Thank you for the information. This was a great video and i was able to get it without much issue. I am wondering if you might also have information on how to now add a photo to another list. This is a great video to get the image. But i seem to be hitting blocks on trying to figure out how to pull an image from a sharepoint list (this video) and place it in another list. any help or guidance would be greatly appreciated. Thank you

@MatthewNelson 9 ай бұрын

I got it figured out maybe it will help others but this is what i did. In short what i wanted was that i have a core sharepoint list and a 2nd list. The core list keeps the main information. When i add a new sharepoint item to the 2nd list it pulls all the information from the core list and updates the 2nd list information. Using this video and the information below. I was able to capture the photo from the core list now and add it to the 2nd list. I am not sure why this has to be so difficult but at least we know their is a solution. In short i added a " Send an HTTP request to SharePoint" before the email and used the JSON's from the video to get the information needed. Method: POST URI: same as when you did for the Get action but at the end add "/Items(item ID)" of the item you are wanting the photo to be added to. Headers content-type:application/json;odata=verbose accept:application/json;odata=verbose If-Match:* X-HTTP-Method:MERGE Body: { "__metadata": { "type": "SP.Data.(List Name)ListItem" }, "Title": "(Item title)", "(Photo Column name)": "{\"type\":\"thumbnail\",\"fileName\":\"(file name from Json)\",\"nativeFile\":{},\"fieldName\":\"(photo column name where the photo is from)\",\"serverUrl\":\"(Sharepoint URL)",\"fieldId\":\"(field ID from where the photo is from)\",\"serverRelativeUrl\":\"/sites/SiteAssets/Lists/(list asset folder name)/(file name from Json)\",\"id\":\"(ID of list item where the photo came from)\"}" } Again thank you for posting your video i would not have been able to accomplish this without it.

@benjaminlahsen6721 9 ай бұрын

Hello! I have troubles with the Compose action. As soon as I run the flow the execution log says: The execution of template action 'Aplicar_a_cada_uno' failed: the result of the evaluation of 'foreach' expression '@body('Análisis_del_archivo_JSON')?['body']?['d']?['results']' is of type 'Null'. The result must be a valid array When in fact Parse Json is retriving the content form the SP list

@Felix350z 7 ай бұрын

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

@NikhilRaj-vy1vh 4 ай бұрын

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

@shweta9128 2 ай бұрын

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

@jagansenthilkumar8642 Жыл бұрын

It is coming up with line of code than coming up with image

@narutostudio8264 6 ай бұрын

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?

@zanemoore6773 Жыл бұрын

For the file identifier line of code- what do you do if your share point has a space? Is it ‘Team Name’ or ‘TeamName’ Thanks in advance!

@michaelalex2322 Жыл бұрын

It should be 'TeamName'

@kavyar2160 Жыл бұрын

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?

@user-qe1pr2zi2x 6 ай бұрын

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

@ignacioarredondohernandez2176 Жыл бұрын

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

@user-lz2vn7gl7q 7 ай бұрын

Okay in email but not in team's chat. Its not working in any specific reasons.

@lulumedina8936 Жыл бұрын

This is very useful! Thank you so much! My flow got an error though, with the Get file content it says "File not Found" I've been doing a lot of changes into the path of the sites but still not working, any thoughts? thank you in advance! You just earned a new subscriber

@michaelalex2322 Жыл бұрын

Thanks for the sub Lulu! And I would recommend looking at this guide torbenp.com/2022/07/get-sharepoint-list-image-in-power-automate/? . It goes into more detail and might be able to resolve your issue. This Flow is more complicated to do and some simple grammar mistakes could cause it to fail.

@lulumedina8936 Жыл бұрын

Nevermind, is fixed now! thank you! By any chance do you know How can I achieve this with multiple images?

@2011DAHP Жыл бұрын

HI @@lulumedina8936 Would you by chance tell me how you solved it? I have the same error

@jbo1253 4 ай бұрын

Anyone know the file size or type restrictions?

@jbo1253 4 ай бұрын

whenever i try to send a image that is larger than 700KB it shows up blank

@victorialang8883 Жыл бұрын

Hi, How can we use this flow without the Email Action but with an Excel Action in order to have the image in an excel table or an excel sheet ? Thank you in advance for your answer !

@michaelalex2322 Жыл бұрын

Hmm, I'm not sure if you can. I don't think you can use html in an Excel action

@victorialang8883 Жыл бұрын

@@michaelalex2322 Thanks for your answer. So, how can we make the same work without html and email actions ?

@maloemalhen 11 ай бұрын

Hi Michael! in 3:17 What if my result is in HTML format? :( { "d": { "Incident_x0020_Analysis": "" } } It goes like this

@HPTeguh 5 ай бұрын

I don't know why I don't find ServerRelativeURL anymore in the schema

@JoelKehrer 5 ай бұрын

I am having the same issue. Have you found any workaround?

@parveen112233 Жыл бұрын

Hi there, My test run goes smooth but the email comes without image. do you have any idea

@mitijan Жыл бұрын

It might be the file type or size. I changed the file type to jpeg and it's now previewing but the file is grainy so working to fix that now.

@jbo1253 4 ай бұрын

@@mitijan any idea on the max files size?

@LicusYong Жыл бұрын

hi may i know what is the expression you wrote on the condition (0.50) ?

@michaelalex2322 Жыл бұрын

The expression in the Condition action was formatDateTime(items('Apply_to_each')?['Birthday'],'MM-dd')

@LicusYong Жыл бұрын

@@michaelalex2322 how about the outputs?

@LicusYong Жыл бұрын

@@michaelalex2322 how about the compose? what is the expression you wrote on (0.39)?

@pop5_ Жыл бұрын

Hey there! I got this error at "get file content" : { "status": 400, "message": "Route did not match clientRequestId: 4e643c50-ae7d-41cb-ae67-9ab9e34ac181 serviceRequestId: 4e643c50-ae7d-41cb-ae67-9ab9e34ac181" }