Power flow set Sharepoint list thumbnail field

(0) Share

Report

Posted on by Meekou

Hi,

I create a list with "thumbnail" field which will show as an image column.

I try to update it from Power flow with "Send an HTTP request to SharePoint".

I know we can update "Hyperlink" field like below:

{
"__metadata": {
"type": "SP.Data.ListListItem"
},
"Image": {
"Description": "Google",
"Url": "https://th.bing.com/th/id/OIP.jtzLV8nbTiaPVkbonKgPJAHaDk?pid=ImgDet&rs=1"
}
}

But, I need the "thumbnail" field type

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

Hi @Meekou,

Just to double check. You are talking about using a hyperlink for an image. That suggests that your are using a field which is of type Hyperlink or Picture? However, there is also a Thumbnail data type (see the screenshot below with an example of list settings with the two different data types).

But as far as I am aware the Thumbnail type of column requires you to upload the image instead of using a hyperlink. In that case the REST API method and the body would be something totally different. From what I can see in the Developer toolbar that would require requests with the UploadImage & AddValidateUpdateItemUsingPath methods instead.

Was this reply helpful? Yes No
Meekou on at

Like (0)

Report

Thanks for your response, @Expiscornovus .

I am using the "TestImage Thumbnail", and yeah, I want to upload the image from Power app.

Could you share how to achieve this?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @Meekou,

Just tested a couple of things. It looks like if your file is already stored somewhere in SharePoint you could use one POST request with the AddValidateUpdateItemUsingPath method.

Below is an example.

_api/web/lists/getbytitle('@{variables('ListName')}')/AddValidateUpdateItemUsingPath

Body of the request.

Be sure to change the variables, the field names and the GUIDs of my image file with your specific details

{"listItemCreateInfo":{"__metadata":{"type":"SP.ListItemCreationInformationUsingPath"},"FolderPath":{"__metadata":{"type":"SP.ResourcePath"},"DecodedUrl":"/sites/@{variables('SiteName')}/Lists/@{variables('ListName')}"}},"formValues":[{"FieldName":"Title","FieldValue":"Testing Requests Again","HasException":false,"ErrorMessage":null},{"FieldName":"TestImage","FieldValue":"{\"type\":\"thumbnail\",\"fileName\":\"@{variables('fileName')}\",\"nativeFile\":{},\"fieldName\":\"TestImage\",\"serverUrl\":\"https://@{variables('YourDomain')}.sharepoint.com\",\"fieldId\":\"aad48642-2801-43c2-9394-d454f9d9ea35\",\"serverRelativeUrl\":\"/sites/@{variables('SiteName')}/SiteAssets/Lists/6b80aa3f-ef25-469f-9f07-8c4dd26aedec/@{variables('fileName')}\",\"id\":\"6e2fdb29-48fe-4e27-8350-4554851d58ea\"}","HasException":false,"ErrorMessage":null},{"FieldName":"ContentType","FieldValue":"Item","HasException":false,"ErrorMessage":null}],"bNewDocumentUpdate":false,"checkInComment":null}

Was this reply helpful? Yes No
Meekou on at

Like (0)

Report

Does it mean I need to upload file to sharepoint first, and then try with your solution?
I will make a try.
Thanks a lot.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Meekou,

Yes, in this approach I assume the file is already uploaded in a library in SharePoint.

Was this reply helpful? Yes No
Meekou on at

Like (0)

Report

I tried, it seems the body is much complex, I tried to replace the variables with mine onw. But, the flow keeps running more than 3 minutes and keep retry.

What should be for id? And, should I include ""FieldName": "ContentType","?

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @Meekou,

The id would be the guid of the file. In my tests I have not tried leaving out the ContentType field value. But it is worth a shot. It might not be needed to get this request working.

I will also try and see if I can simplify the body as well by not using metadata.

Was this reply helpful? Yes No
Hrdy 4 on at

Like (0)

Report

Thank you @Expiscornovus really helpful

Was this reply helpful? Yes No
ganeshsanap 1,551 on at

Like (2)

Report
@Meekou @Hrdy
You can now Create an Image Column in SharePoint/Microsoft Lists and use it instead of using Hyperlink/Picture column.

SharePoint/Microsoft Lists image columns now also supports displaying images in power apps, adding/updating images from Power apps and Power automate:
Power Apps can now display images from SharePoint Online/Microsoft Lists
Add, update, or delete images in SharePoint/Microsoft Lists using Power Apps
Add an image to SharePoint Image columns using Power Automate
Please click Accept as solution & 👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

Was this reply helpful? Yes No