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
@Nazhoglit4 ай бұрын
thx this was my first approximation to the sharepoint rest API and its very easy to use, thanks you very much
@michaelalex23224 ай бұрын
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!
@raissacamargo44364 ай бұрын
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 👍
@suhaimsh20768 ай бұрын
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.
@LetsTalkPowerBI9 ай бұрын
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
@csmtiltm59106 ай бұрын
Thanks, It was really helpful for me!!
@michaelalex23226 ай бұрын
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?
@leandroneets8 ай бұрын
thank you.
@michaelalex23228 ай бұрын
You're welcome
@barbaragualberto8109 ай бұрын
Thank you very much! Genuine question though, how can I send this image as an attachment?
@mageshkrishnan79727 ай бұрын
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?
@MatthewNelson9 ай бұрын
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
@MatthewNelson9 ай бұрын
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.
@benjaminlahsen67219 ай бұрын
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
@Felix350z7 ай бұрын
4:28 Why is there a difference between what you copied from Compose and what you're pasting into Parse JSON?
@NikhilRaj-vy1vh4 ай бұрын
Image is not loading in outlook after this succesful flow. Can you please help here?
@shweta91282 ай бұрын
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
@narutostudio82646 ай бұрын
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-qe1pr2zi2x6 ай бұрын
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-lz2vn7gl7q7 ай бұрын
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
@jbo12534 ай бұрын
Anyone know the file size or type restrictions?
@jbo12534 ай бұрын
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 ?
@maloemalhen11 ай бұрын
Hi Michael! in 3:17 What if my result is in HTML format? :( { "d": { "Incident_x0020_Analysis": "" } } It goes like this
@HPTeguh5 ай бұрын
I don't know why I don't find ServerRelativeURL anymore in the schema
@JoelKehrer5 ай бұрын
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.
@jbo12534 ай бұрын
@@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" }
@ResponsibleXI Жыл бұрын
How do I send the same image as in email attachment?