Answered

Send an HTTP Request to SharePoint Issue

(1) Share

Report

Posted on by doughpii

Hello!

I have currently have the following flow call that works in adding an image to a sharepoint list:

"inputs": {
    "parameters": {
      "dataset": "https://CLIENTSITE.sharepoint.com/sites/[...]",
      "parameters/method": "POST",
      "parameters/uri": "_api/web/lists/getbytitle('titlenospaces')/items(@{outputs('Create_item')?['body/ID']})",
      "parameters/headers": {
        "Accept": "application/json;odata=verbose",
        "Content-Type": "application/json;odata=verbose",
        "If-Match": "*",
        "X-HTTP-Method": "MERGE"
      },
      "parameters/body": "{\n  \"__metadata\": {\n    \"type\": \"SP.Data.Sample_x0020_ListListItem\"\n  },\n  \"Photo_x0020_of_x0020_Observation\": \"{ \\\"type\\\": \\\"thumbnail\\\", \\\"fileName\\\": \\\"@{items('Apply_to_each_2')['name']}\\\",\\\"serverUrl\\\": \\\"https://CLIENT.sharepoint.com\\\",\\\"serverRelativeUrl\\\":\\\"/sites/[...]/Microsoft Forms/[...]/Attach a Photo/@{items('Apply_to_each_2')['name']}\\\" }\"\n}\n"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "connection": "shared_sharepointonline",
      "operationId": "HttpRequest"
    }
  },



This successfully adds images to the SP list and are visible on the SP Site. However, they are not visible on PowerApps (even the default template) unlike adding the image manually on the Sharepoint List. Is there anything I'm missing on the body or headers? 



Thanks in advance for tips!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 69,123 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Does, the file name items('Apply_to_each_2')['name'] have an appropriate file extension as part of the name?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
doughpii 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Paul,

Thank you for your reply. The file name items('Apply_to_each_2')['name'] includes the appropriate file extension, this is an example of a last run:

bug_doughpii.png

Was this reply helpful? Yes No
Verified answer

doughpii 22 on at

Like (0)

Report
Copy link

Link copied!

Solution + Workaround found:

Solution:
After inspecting the SP list and comparing the image files between REST calls and manually inserting it, a REST Call does not actually insert the image into the SP list/site. It simply points the source of the image to the one specified in (serverUrl/serverRelativeUrl). As such, the folder has to be shared with the client's internal environment so its visible to everyone except external users. In addition, the (serverRelativeUrl) was also added to the PowerApps' database.

Workaround:
Instead of using the HTTP call in power automate, you can instead use 'add attachment to item' after getting the file content with an appropriate connector. Then point the image in PowerApps to first(attachments).

Was this reply helpful? Yes No