Тёмный

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

Michael Alex
Подписаться 6 тыс.
Просмотров 19 тыс.
50% 1

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 58   
@zaktoubi6731
@zaktoubi6731 Год назад
the only video that makes my flow run smoothly, thank you. I spend 2 days searching on google with no hope.
@michaelalex2322
@michaelalex2322 Год назад
Glad it worked, this one was more difficult
@jhonrymat
@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
@michaelalex2322 Год назад
Happy it helped!
@Nazhoglit
@Nazhoglit 5 месяцев назад
thx this was my first approximation to the sharepoint rest API and its very easy to use, thanks you very much
@michaelalex2322
@michaelalex2322 5 месяцев назад
You are welcome!
@GeorgeZeidan
@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
@michaelalex2322 Год назад
No problem 👍
@raissacamargo4436
@raissacamargo4436 5 месяцев назад
Perfect video! Thanks
@suhaimsh2076
@suhaimsh2076 10 месяцев назад
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.
@csmtiltm5910
@csmtiltm5910 7 месяцев назад
Thanks, It was really helpful for me!!
@michaelalex2322
@michaelalex2322 7 месяцев назад
You're welcome!
@doribi05
@doribi05 7 дней назад
Thanks for the tutorial! I followed it play by play however when I get to the get file content step I do not have server relative url listed in my dynamic content and my second parse json is very short. I don't know what I did wrong.
@LEONARDOMARCELOZAMBRANOALTAMIR
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
@LetsTalkPowerBI
@LetsTalkPowerBI 10 месяцев назад
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
@VijayKumar-l4u4k
@VijayKumar-l4u4k Месяц назад
Hi Alex, thank you for the video, I got stuck to create a loop where I have 10 images in share point and I want all the images on one PDF. Could you please suggest. Your help is much appreciated. Thank you in advance.
@abuena73
@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?
@dabketroop
@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?
@barbaragualberto810
@barbaragualberto810 10 месяцев назад
Thank you very much! Genuine question though, how can I send this image as an attachment?
@mageshkrishnan7972
@mageshkrishnan7972 9 месяцев назад
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?
@leandroneets
@leandroneets 10 месяцев назад
thank you.
@michaelalex2322
@michaelalex2322 9 месяцев назад
You're welcome
@NikhilRaj-vy1vh
@NikhilRaj-vy1vh 6 месяцев назад
Image is not loading in outlook after this succesful flow. Can you please help here?
@MatthewNelson
@MatthewNelson 10 месяцев назад
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
@MatthewNelson 10 месяцев назад
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.
@Felix350z
@Felix350z 8 месяцев назад
4:28 Why is there a difference between what you copied from Compose and what you're pasting into Parse JSON?
@benjaminlahsen6721
@benjaminlahsen6721 10 месяцев назад
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
@narutostudio8264
@narutostudio8264 7 месяцев назад
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
@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
@michaelalex2322 Год назад
It should be 'TeamName'
@jagansenthilkumar8642
@jagansenthilkumar8642 Год назад
It is coming up with line of code than coming up with image
@kavyar2160
@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?
@shweta9128
@shweta9128 4 месяца назад
i am not able to get server relative uri. please help me
@LucasBarros-p4r
@LucasBarros-p4r 8 месяцев назад
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?
@PooraniNataraj
@PooraniNataraj 9 месяцев назад
Okay in email but not in team's chat. Its not working in any specific reasons.
@ResponsibleXI
@ResponsibleXI Год назад
How do I send the same image as in email attachment?
@jbo1253
@jbo1253 5 месяцев назад
Anyone know the file size or type restrictions?
@jbo1253
@jbo1253 5 месяцев назад
whenever i try to send a image that is larger than 700KB it shows up blank
@HPTeguh
@HPTeguh 7 месяцев назад
I don't know why I don't find ServerRelativeURL anymore in the schema
@JoelKehrer
@JoelKehrer 6 месяцев назад
I am having the same issue. Have you found any workaround?
@lulumedina8936
@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
@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
@lulumedina8936 Год назад
Nevermind, is fixed now! thank you! By any chance do you know How can I achieve this with multiple images?
@2011DAHP
@2011DAHP Год назад
HI @@lulumedina8936 Would you by chance tell me how you solved it? I have the same error
@victorialang8883
@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
@michaelalex2322 Год назад
Hmm, I'm not sure if you can. I don't think you can use html in an Excel action
@victorialang8883
@victorialang8883 Год назад
@@michaelalex2322 Thanks for your answer. So, how can we make the same work without html and email actions ?
@maloemalhen
@maloemalhen Год назад
Hi Michael! in 3:17 What if my result is in HTML format? :( { "d": { "Incident_x0020_Analysis": "​" } } It goes like this
@LicusYong
@LicusYong Год назад
hi may i know what is the expression you wrote on the condition (0.50) ?
@michaelalex2322
@michaelalex2322 Год назад
The expression in the Condition action was formatDateTime(items('Apply_to_each')?['Birthday'],'MM-dd')
@LicusYong
@LicusYong Год назад
@@michaelalex2322 how about the outputs?
@LicusYong
@LicusYong Год назад
@@michaelalex2322 how about the compose? what is the expression you wrote on (0.39)?
@parveen112233
@parveen112233 Год назад
Hi there, My test run goes smooth but the email comes without image. do you have any idea
@mitijan
@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
@jbo1253 5 месяцев назад
@@mitijan any idea on the max files size?
@pop5_
@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" }
Далее
Тренд Котик по очереди
00:10
Просмотров 279 тыс.
Тренд Котик по очереди
00:10
Просмотров 279 тыс.