Unanswered

ERROR BAD REQUEST

(0) Share

Report

Posted on by Gorilla_8

I got this error on my flow:

HTTP/1.1 400 Bad Request
CONTENT-TYPE: application/json;odata=verbose;charset=utf-8

{"error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Invalid request."}}}
--batchresponse_fe7f85a1-d115-42d2-82bb-59cbe67ca499
Content-Type: application/http
Content-Transfer-Encoding: binary

HTTP/1.1 400 Bad Request
CONTENT-TYPE: application/json;odata=verbose;charset=utf-8

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Gorilla_8 are you getting this error in response of Send HTTP request to SharePoint action, if yes, can you expand that action and share screenshot of it to see the configure parameters in that action.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

@annajhaveri here

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@Gorilla_8 so it looks like you are performing some kind of batch operations in SharePoint, can you please elaborate whether you are trying to create/update/delete items from SharePoint list using batch operation?

Was this reply helpful? Yes No
Verified answer

Gorilla_8 on at

Like (0)

Report

@annajhaveri

I found the solution, it was the name of one of the actions

Thanks for the help!

Was this reply helpful? Yes No
Ahemed 23 on at

Like (1)

Report

@Gorilla_8 what is the solution for above ask

Was this reply helpful? Yes No
theacidday 5 on at

Like (0)

Report

What the solution???

Was this reply helpful? Yes No
alexa_028 63 on at

Like (0)

Report

Does anyone knows what is the solution and what changes needs to be done for action?
I am facing similar issue... I did like below but no success:
Updates:
actions('settings')?['TrackedProperties']['changeSetGUID']

Old:
actions('settings')?['trackedProperties']['changeSetGUID']

Was this reply helpful? Yes No
alexa_028 63 on at

Like (0)

Report

I am able to solve my issue following the article and recommendation by Will.

https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

Things I did :
1. Make sure column names in Sharepoint list and datasource are in same sequence and correct names.
2. Did the changes as described below:
Issue: Sharepoint List Display Name vs Web Address Name
The list name from Settings is used in multiple places. However, the formatting has to be adjusted based on the location it is used. In the batchTemplate the SPList name needs to be regular display name. In the GenerateSPData _metadata the needs to be the web address name. OP tried to help the _metadatafield by adding some replace values for underscores, but that only works if the name never changed.
If a Sharepoint list is created with the initial name “InitialSharePointName” and then the display name is changed to “New Display Name”, then it will never call the correct webaddress since the webaddress doesn’t change from initial name just like column names.
Solution to first issue: Add a second row in the Settings and differentiate the sharepoint display name and the sharepoint webaddress name.
Original Settings Format:
{
“siteAddress”: “https://OrgName.sharepoint.com/sites/SiteName/”,
“listName”: “ExampleListName”,
“batchSize”: 1000
}
New Settings Format:
{
“siteAddress”: “https://OrgName.sharepoint.com/sites/SiteName/”,
“SPListDisplayTitleName”: “(Copy Sharepoint Name from List Settings)”,
“SPListWebAddressName”: “(Copy list name section from the Web Address section in List Settings”,
“batchSize”: 1000
}
After Changing the settings you have to go into where they are used and update the expressions.
1. Batch Template – change the output of getByTitle in the PATCH statement to: PATCH @{outputs(‘settings’)[‘siteAddress’]}_api/web/lists/getByTitle(‘@{outputs(‘settings’)[‘SPListDisplayTitleName’]}’)/items(|ID|) HTTP/1.1
2. Generate SP Data – change the _metadata value field to contain json(concat(‘{“type”:”SP.Data.’, replace(replace(replace(outputs(‘settings’)[‘SPListWebAddressName’], ‘_’, ‘_x005f_’), ‘ ‘, ‘_x0020_’),’-‘,’_x002d_’), ‘ListItem”}’))
I hope this helps some people because this flow really helped me get what I needed and saved a massive amount of calls.

Was this reply helpful? Yes No