power apps bulk insert from json to sharepoint

[JitenderSinghEH]

Hi All 

i got json file from my client every day which contain around 1million records

i need to put those records in a sharepoint?

but apply to each is taking too long and i also have 100k limit?

can anybody help me in achieving this?

thanks

[takolota · Accepted solution]

@JitenderSinghEH 

You may need to learn how to set-up batch actions for SharePoint.

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

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

[JitenderSinghEH]

but i think batch action can get only 1000 rows, that will not be good 1million records.

do you have any another suggestion?

[takolota]

@JitenderSinghEH 

I suggest downloading the templates and looking over how the Do until loops work to continually send batches of 800-1000 rows until it has updated your 1 million records.

[JitenderSinghEH]

ok i will try, thanks for the help