Answered

Send an HTTP request to sharepoint Unexpected response

(0) Share

Report

Posted on by DanuRan

Hi,

I am working on this flow where I need to create columns on a SharePoint list. This request works when it is outside the Apply to Each Loop

However when I put the same request inside the Apply to each loop with iterative input for the title it gets the error

{

"status": 400,

"message": "Unexpected response from the service\r\nclientRequestId: 8acb2d25-c7ae-491f-a1d3-835198571358\r\nserviceRequestId: 48bce4a0-a0b2-7000-5dbf-aec7e93ab9ba",

"error": {

"message": "Unexpected response from the service"

"source": "sharepointonline-ne.azconn-ne-002.p.azurewebsites.net"

}

Below is the flow.

Although there is an error like that the columns in the list are correctly created as per the inputs of the loop.

Appreciate any inputs on why this is happening.

Thank you in advance

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Srini007 3,327 Super User 2025 Season 2 on at

Like (1)

Report

Hi @DanuRan

usually when you are hard coding the values that was working fine, so usualy 400 error code denotes that you are passing a wrong request

Can you check the variables you are passing there have the correct values? That will help why that is getting failed, maybe you can place a compose and see the values before passing to the HTTP request

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

A couple things to check:
Does your column name have any strange characters?
Is your column name blank/null?

Was this reply helpful? Yes No
DanuRan 12 on at

Like (0)

Report

Thank you for the response.

It turns out that the following instance is the one causing the error. "name": "ID",.

I am not sure why "ID" is causing the error. Its in an array and a string just as other items in the variable. When I removed it it worked.

{
"description": "test",
"enforceUniqueValues": false,
"hidden": false,
"indexed": false,
"name": "ID",
"text": {
"allowMultipleLines": false,
"appendChangesToExistingText": false,
"linesForEditing": 0,
"maxLength": 255
}
}

Was this reply helpful? Yes No