Answered

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

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

eliotcole

4,390 Moderator on at

Like (0)

Report

Copy link

Link copied!

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

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.

Was this reply helpful? Yes No

Verified answer

jojos_iq 90 on at

Like (1)

Report
Copy link

Link copied!

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 🙂

Was this reply helpful? Yes No