Answered

Saving a SharePoint List Image Column to a 2nd SharePoint List Image Column?

(0) Share

Report

Posted on by zoso2112

134

I am building a Flow to Get Items from a SP list per a filter query, then use an SP HTTP Request to retrieve one image. I am very close and in the 'Compose FileName' action, the output is a JSON object (see code snippet below).

{
  "fileName": "Reserved_ImageAttachment_[14]_[CaseLabelImage][36]_[7823efb7-f571-4428-90df-a3a48a5cf219][1]_[3].png"
}

I have tried the code snippet below for the Compose URL action but the output is just domain.com.

concat(
    'https://domain.sharepoint.com',
    json(body('Send_an_HTTP_request_to_SharePoint')?['value'][0]?['CaseLabelImage'])?['ServerRelativeUrl']
)

What is the next step to locate the image URL to save to the 2nd SP list?

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Suggested answer

Gopala_Krishna 1,495 on at

Like
a
(1)

Report
Copy link

Link copied!
There seems to be a problem with the JSON expression being utilized, Can you add this JSON expression into an independent compose action to check if it returns a valid output

json(body('Send_an_HTTP_request_to_SharePoint')?['value'][0]?['CaseLabelImage'])?['ServerRelativeUrl']
Verified answer

zoso2112 134 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gopala_Krishna - Thank you for your response. I finally got it working by updating the 'Compose FileName' action to the code you recommended minus the ['ServerRelativeUrl'] part.
json(body('Send_an_HTTP_request_to_SharePoint')?['value'][0]?['CaseLabelImage'])

Then I updated the 'Compose URL' action to the code below.
json(body('Send_an_HTTP_request_to_SharePoint')?['value'][0]?['CaseLabelImage'])?['fileName']

Thank you for helping me arrive at the solution!