BackgroundThe original flow is created to change the file name according to a SQL lookup table in OneDrive and is working as it should. The files

It worked, thanks. Please note that I got it to work using the following setup as well

Solved: Action 'Send_an_HTTP_request_to_SharePoint' failed (Status code:400 -Error Details: Unexpected response from the service)

Action 'Send_an_HTTP_request_to_SharePoint' failed (Status code:400 -Error Details: Unexpected response from the service)

Background

The original flow is created to change the file name according to a SQL lookup table in OneDrive and is working as it should.
The files do exist in a SP library, and thus I will need to use "Send an HTTP request to SharePoint" to update the file name.
I used the same logic until Send_an_HTTP_request_to_SharePoint"

Send an HTTP request to SharePoint Setup (screenshot attached)

I checked the API on the URL by adding _api/lists/GetByTitle('ICC Immersion') in the browser and returning some XML values.
I used a variable for the ID to avoid apply to each loop

Headers

content-type: application/json

X-HTTP-Method: PATCH

OData-MaxVersion: 4.0

OData-Version: 4.0

If-None-Match: null

return: representation

If-Match: *

Results-Output

Body

{

"status": 400,

"message": "Unexpected response from the service\r\nclientRequestId: 768f8bf3-6b8f-4cfb-a873-51a342d2b5d4\r\nserviceRequestId: eee08ba0-7072-3000-08ed-8872c4507831",

"error": {

"message": "Unexpected response from the service"

"source": "sharepointonline-wus.azconn-wus.p.azurewebsites.net"

}

Headers

{

"Pragma": "no-cache",

"Cache-Control": "no-store, no-cache",

"Set-Cookie": "ARRAffinity=277305230731c420c53b2cf0ffa2c39168f1f53c56848d990;Path=/;HttpOnly;Secure;Domain=sharepointonline-wus.azconn-wus.p.azurewebsites.net,ARRAffinitySameSite=277305230731c420c53b2cf0fa2c39168f1f53c56848d990;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-wus.azconn-wus.p.azurewebsites.net",

"x-ms-request-id": "eee08ba0-7072-3000-08ed-8872c4507831",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Content-Type-Options": "nosniff",

"X-Frame-Options": "DENY",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"x-ms-apihub-obo": "false",

"Date": "Fri, 13 Jan 2023 16:06:36 GMT",

"Content-Length": "333",

"Content-Type": "application/json",

"Expires": "-1"

}