Issues with getting image column images from a SharePoint image list using a HTTP request

[jojos_iq]

Hi everyone!

I've just started working with a SharePoint online list that has 12 image columns, and people add photos to these image columns. What we want to do is to grab these images from these columns and put them into a Document library. I understand how to make a file using Power Automate, I just don't understand I can grab the images from the 12 columns (keeping in mind that it can be up to 12 images, some will most definitely be null.)

So far, I have used the "Send an HTTP request to SharePoint" action to get some columns as a test (see image below):

and it is returning something, but I don't know if I am Parsing the JSON correctly. The HTTP request returns this:

	{
  "d": {
    "__metadata": {
      "id": "4b74297c-e528-4a09-bd19-ee20a39dafdb",
      "uri": "https://TENTANTNAME.sharepoint.com/sites/SITENAME/_api/Web/Lists(guid'71213af7-0205-4cbc-b3c2-254d310c7ac0')/Items(1)",
      "etag": "\"1\"",
      "type": "SP.Data.Image_x0020_column_x0020_content_x0020_testListItem"
    },
    "Category1": "{\"type\":\"thumbnail\",\"fileName\":\"image (2).png\",\"nativeFile\":{},\"fieldName\":\"Category1\",\"serverUrl\":\"https://TENTANTNAME.sharepoint.com\",\"fieldId\":\"3b9619ac-5c4f-4348-a5b2-2c90ddb0ce3c\",\"serverRelativeUrl\":\"/sites/SITENAME/SiteAssets/Lists/71213af7-0205-4cbc-b3c2-254d310c7ac0/image%20(2).png\",\"id\":\"9b63722b-6cf6-49d7-8b0c-5b9f6acea472\"}",
    "Category2": "{\"type\":\"thumbnail\",\"fileName\":\"image (1).png\",\"nativeFile\":{},\"fieldName\":\"Category2\",\"serverUrl\":\"https://TENTANTNAME.sharepoint.com\",\"fieldId\":\"3e2dbd81-723a-4f4c-b59a-13e76c99fadb\",\"serverRelativeUrl\":\"/sites/SITENAME/SiteAssets/Lists/71213af7-0205-4cbc-b3c2-254d310c7ac0/image%20(1).png\",\"id\":\"0974fa6d-05d5-41d2-9557-8ed15f2d172d\"}",
    "Category3": null
  }
}

using this output as the sample schema for the Parse JSON action, these are the dynamic content options I have to select:

I was thinking I would have the returned columns as selectable values, but I do not. Is anyone able to help with this please? Thank you!

Let me know if you need anymore information from me.

[eliotcole]

Hi, @jojos_iq, there will be cleverer ways to accomplish this (including selects with XML stuff going on) but for an easy solution I would:

Step	Action / Name	Notes
1	Initialize categoriesObjVar	Make an Object type variable with this name
2	Scope categoriesObjBuilder	Make a Scope action after that with this name
3	Send an HTTP request to SharePoint	Move this inside Scope categoriesObjBuilder as the first action
4	Condition category1	Make a condition with this name with the following: Left expression condition Right expression equals(body('Send_an_HTTP_request_to_SharePoint')?['Category1'], null) is equal to false
4.1	Compose addCategory1ToObj	In the Yes branch of Condition category1 make a Compose action with this name and the following expression: addProperty(variables('categoriesObjVar'), 'Category1', json(body('Send_an_HTTP_request_to_SharePoint')?['Category1']))
4.2	Set categoriesObjVar 1	After Compose addCategoryToObj add a Set variable action with this name and use the value of Compose addCategoryToObj
5-15	-	Repeat steps 4, 4.1, and 4.2, increasing the number each time until you have done all twelve

This would then just ensure that each of those Category values would be pure JSON and you could pick the values normally from it.

If there is no value there ... this should skip that key/value pairing.

[jojos_iq · Accepted solution]

UPDATE (mainly for anyone else who has this problem and my future self)

This isn't really a solution to the problem I was having, more so the solution I was trying to force was wrong in the first place (XY problem)

All I wanted to do was take these images from the image columns and put them into a document library. Turns out that the images in an image column actually live in the attachment column! Using the "Get attachments" action in Power Automate grabs all the images from the list item.

I used that plus "Get attachment content" + "Create file" to make new files in the chosen document library 🙂