Batch SharePoint API Calls from power automate

[Suchitra1996]

Hi,

I'm trying to implement the batch API calls to sharepoint list to create new items. The flow is getting executed successfully but the items are not getting created and I'm getting the below output from the http request .

{
  "$content-type": "multipart/mixed; boundary=batchresponse_cace2e0f-7b35-4382-af00-ad932f9e8888",
  "$content": "LS1iYXRjaHJlc3BvbnNlX2NhY2UyZTBmLTdiMzUtNDM4Mi1hZjAwLWFkOTMyZjllODg4OC0tDQo="
}

Originally, I wanted to add data from excel but for testing purpose, I hard coded the values (body below)

--batch_cd329ee8-ca72-4acf-b3bf-6699986af544
Content-Type: multipart/mixed; boundary="changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc"
Content-Transfer-Encoding: binary
 
--changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc
Content-Type: application/http
Content-Transfer-Encoding: binary
 
POST https://<tenant>.sharepoint.com/sites/<site>/_api/web/lists/GetByTitle('<title>')/items HTTP/1.1
Content-Type: application/json;odata=verbose 
{
    "__metadata": {
      "type": "SP.Data.<title>ListItem"
    },
    "Title": "Test"
}
--changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc--
--batch_cd329ee8-ca72-4acf-b3bf-6699986af544--

 Please let me know where I might be missing something.

Thank you in advance

[jinivthakkar]

@murshed @v-litu-msft I too tried everything nothing works, can you please post a working example ?

[v-litu-msft]

Hi @Suchitra1996,

I think the headers in your HTTP request are not correct, you could refer to by following screenshots to structure it:

For more details about lists and list items API, you could refer to this document, you will find the Create item API:

Working with lists and list items with REST | Microsoft Docs

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jinivthakkar]

@v-litu-msft thanks for your reply but I think the issue is with _api/$batch end point POST, the regular POST which you showed just works fine.

The issue is with batch insert operation like this 

https://ashiqf.com/2020/06/16/batch-sharepoint-requests-get-post-patch-delete-in-powerautomate-and-m...

Please help

[jinivthakkar]

@v-litu-msft one more similar blog/article but this also does not work :

https://wiliammbr.com/batch-insert-items-in-sharepoint-with-power-automate/

[Suchitra1996]

Hi @v-litu-msft,

This is the header of my request for the batch API request.

I have entered the batch ID in the header request and the same batch ID is in the body of the request.

I get the below output when I execute it:

While the flow ran successfully, there was no item created in the list.

[Anonymous]

Did you get this resolved? I got batch posts working

I can share if you are still trying to work on this I am typing on iPad right now but can share full solution if you need it

[swiftinitdotcom]

can you please share?

[Kem-El]

Late to the game on this, but you simply need to add a blank line between the start and end of the JSON data.

--batch_cd329ee8-ca72-4acf-b3bf-6699986af544
Content-Type: multipart/mixed; boundary="changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc"
Content-Transfer-Encoding: binary
 
--changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc
Content-Type: application/http
Content-Transfer-Encoding: binary
 
POST https://<tenant>.sharepoint.com/sites/<site>/_api/web/lists/GetByTitle('<title>')/items HTTP/1.1
Content-Type: application/json;odata=verbose 

{
    "__metadata": {
      "type": "SP.Data.<title>ListItem"
    },
    "Title": "Test"
}

--changeset_64c72699-6e7c-49c4-8d9b-6b16be92f7fc--
--batch_cd329ee8-ca72-4acf-b3bf-6699986af544--

[takolota]

Paulie provides a template for anyone trying to do this…

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

and there is also a batch update template…

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-Extern...

[alexa_028]

Hi @takolota 
I am using same template as Paula's and now I am getting failure at send Batch with Bad HTTP request 400.
I got this error message - 
The maximum number of bytes allowed to be read from the stream has been exceeded. After the last read operation, a total of 1055877 bytes has been read from the stream; however a maximum of 1048576 bytes is allowed.(…)

I tried using batch size to 750 and even 50 , but still it is same. Can you pls help?

[takolota]

How many columns are you using?

[alexa_028]

7 columns

[alexa_028]

The only thing I am doing here is that , putting Generate SP data inside an apply loop as I am getting mapping values from excel

[takolota]

@alexa_028 

You're not using the same as Paulie's default template because I don't see any reason why you would put that into an Apply to each. If that run was actually successful, I'd bet you'd get a copy of every Excel row into SharePoint FOR EACH excel row. So if you had 100 rows in excel it would copy all 100 rows 100 times for a total of 10,000 rows.

You do not need that Apply to each, the Select action already has a kind of internal Apply to each loop going through every value in the From field, in this case going through every value from the Excel list rows.

[alexa_028]

Hey @takolota 
I changed to the template and and now everything works but it doesn't add the data to sharepoint due to the error :

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":"A type named 'SP.Data.CoreHRListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type."}}}
--batchresponse_af4cf4cf-f945-46a2-913f-e1409e785318
Content-Type: application/http
Content-Transfer-Encoding: binary

Few things I did but no luck :
1. Removed apply each loop from GenerateSPData block

2. Changed the action formula from "trackedProperties" to "TrackedProperties"

[takolota]

@alexa_028 

What do you have for the CoreHR column in the GenerateSPData action? And what datatype is it in the SharePoint list?

[alexa_028]

Hi,

I have solved my issue using the comment from Will in this article. It was very helpful. Basically my sharepoint display name was not same as web address name.

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


More info posted here : https://powerusers.microsoft.com/t5/General-Power-Automate/ERROR-BAD-REQUEST/m-p/2331781#M138204

[takolota]

@alexa_028 

Are you working from an older version?
I thought I patched that common issue with an extra call to SharePoint to use the current list display name to get the original back-end name.

[NicPrad]

Hi, have you found any solution? 
I've the very same problem...