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
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.
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.
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
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
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.
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?
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?
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
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.
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
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?
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
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.
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 !
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" }