Add Image from URL to image column in Sharepoint

[cha_cha]

Hello all,

I am trying to upload an image from a URL to an image column in my PowerPoint.

But I am unsure how to parse the image from URL to content for this field. 

Please share if you have a similar experience.

[v-bofeng-msft · Accepted solution]

Hi @cha_cha ,

I've made a test for your reference:

1\I assume there is an image:

https://images.pexels.com/photos/1561863/pexels-photo-1561863.jpeg

2\My SP List

3\My flow

{
  "__metadata": {
    "type": "SP.Data.Bof005ListItem"
  },
"Title":"xxx",
  "MyImageColumn": "{\"type\":\"thumbnail\",\"fileName\":\"pexels-photo-1561863.jpeg\",\"fieldName\":\"MyImageColumn\",\"serverUrl\":\"https://images.pexels.com\",\"serverRelativeUrl\":\"/photos/1561863/pexels-photo-1561863.jpeg\",\"id\":\"e1d61f2d-e0a3-46a0-9c0d-de31845b5422\"}"
}

Result:

Best Regards,

Bof

[cha_cha]

Hello @v-bofeng-msft 

How to resolve the type part?

My list's name has a space in it: so instead of SP.Data.ListName I use SP.Data.List_x0020_Name but it's not working. Can you please advise the format of this?

[cha_cha]

Hello,

I just figured I'm missing the ListItem name. It's sorted now. I still need to figure out how to track the right image, but the HTTP request is working fine now. Thank you very muchie.

[JasonWS]

Sorry to revive this. I have this working, the images show up in SharePoint just fine, however they are not pulling into PowerApps properly. Is there any workaround for this? The image value itself appears to be non-blank, however it is visibly empty.

The images in this screenshot are being provided by a Coalesce() function using SampleImage as the second item. So you can see the images are non-blank, however they do not show. In SharePoint, these items show fine, and these were generated from Power Automate. Power Automate is getting items from a different site, creating a new item via a Create Item action, then utilizing Send HTTP actions to add those added images to the column.

[JasonWS]

I solved my question, with the help of Copilot! I needed another Send HTTP Request action in between to get the image by serverRelativeUrl to be able to grab the UniqueID of the created image. I was generating a random ID. It is now pulled into Power Apps properly.