Flow to extract image from sharepoint list type image

[Francisco77]

Hi Community,

I have a SharePoint list with an image type column, from which I need to extract the image to add it to a part of the flow as variable input. I have seen several posts but since I am not very expert I have not been able to get the flow to work. I have seen that using "Send an HTTP request to ShaRepoint" the image is extracted, but I cannot do it.
Does anyone have a well explained flow that allows me to achieve this?.

As always, thank you all very much.

Francisco

[v-qiaqi-msft · Accepted solution]

Hi @Francisco77,

_api/Web/Lists/getbytitle('listname')/Items?$select=Test_Image

Note that the Test_Image is my Image column name, you need to replace it with your column name

replace(json(body('Send_an_HTTP_request_to_SharePoint')?['d/results']?[0]?['Test_Image'])?['serverRelativeUrl'],'/sites/wearsky','')

Note that wearsky is the site name on my side, so you need to replace it with yours.

Then you could get the file content.

[Francisco77]

Hi @v-qiaqi-msft 

First, thank for youre help¡. 

The "Send an HTTP request to SharePoint" step gives me this error. What could be the reason if the name of my Sharepoint list column is correct?.

Columna name is correct.

[v-qiaqi-msft]

Hi @Francisco77,

Not sure how you comfigrue the uri in the Http request.

The error means that you have refer to a wrong column name, flow does not recgonize the column name including space.

What's more, your image column name has space within, you should make sure you have got the real inner column name.

Find out the column from the outputs of your trigger.

A tip for you, never create a column name including any space, which brings you big trouble

[Francisco77]

Hi @v-qiaqi-msft 

In the "Compose" part of the flow this error is generated, do you know what could be causing it?.

The compose formula is, where Photo1 is the name of my column: 

json(body('Send_an_HTTP_request_to_SharePoint')?['d/results']?[0]?['Foto1'])

Thanks

[CloudLights_PK]

Hi Francisco,
mittlerweile ist viel einfacher. Http-Request sind nicht mehr nötig.
Da man in einer Liste immer nur ein Bild an einem Element speichern kann ist die Schleife nebensächlich.
Man muss nur noch die IDs einsetzen und den Dateityp bestimmten. Dies ist in der Regel .jpeg. Falls es unterschiedliche Typ sind kann man dies aus dem Dateinamen in "Get Attachments" auslesen.

Philipp