Get file from SharePoint list with Power Automate

(0) Share

Report

Posted on by hongkong

277

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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
hongkong 277 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No