Get file from SharePoint list with Power Automate

[hongkong]

I have a SharePoint online list with a "Thumbnail" field. A image is uploaded to this field.

How can I get this file from Power Automate?

I am able to use http call like below:

_api/web/lists/getbytitle('ListName')/items(1)?$select=myPictureField

to get the metadata of that picture. But how can I get the file? I would like to insert this image into a word template.

[v-yueyun-msft]

Hi , @hongkong 

According to your description, you want to get the file content of the Thumbnail field image.

This is my sharePoint list:

You can refer to this :

We can get this return from the Http request:

Then we can use this action to get the file content:

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['ImageTest'])?['fileName']

For more information, you can refer to this:

Get SharePoint List Image in Power Automate - Torben Pedersen

Best Regards,

Yueyun Zhang

[hongkong]

Thanks for your tips. 

I think your sample of "get file content using path" is trying to get the Attachments? Could you please show me how to get the "Attachments" field?

It is because the image I uploaded to thumbnail field have a path like this:

https://{sharepoint site url}/SiteAssets/Lists/xxxxxxx-xxxx-4618-a45c-444444488888/myimage.png

attachments path like this:

https://{sharepoint site url}/SiteAssets/Lists/{list name}/Attachments/{id}/myimage.png

[v-yueyun-msft · Accepted solution]

Hi , @hongkong 

Thanks for your response! The url is just we the browser url after we clicking the image:

The Attachments is not a field , it is just the substring of my browser url. You can click the image in your column, and you can see the url in your browser. We just need to get 2 parameters.

One is the ID of this Item, another is the filename of your picture.

Best Regards,

Yueyun Zhang