Hello Everyone,
Can anyone suggest what is the best way to bulk update/create/delete SharePoint list items. I need to do this in bulk since the workflow will be processing 5000 to 10000 rows.
There are three file sources, SharePointList_1; SharePointList_2; Excel_file (uploaded in a document library), and a unique field EmployeeNumber in all three sources.
Below are the objectives of the workflow:
1. Update SharePoint List_2 items in bulk if EmployeeNumber matches Excel_file but does not return a match in SharePointList_1
2. Create SharePoint List_2 items in bulk if EmployeeNumber matches Excel_file but does not return a match in SharePointList_2
3. Delete SharePoint List_2 items in bulk if EmployeeNumber does not match Excel_file and SharePointList_1
I have seen an article from @Paulie78 and I was able to replicate to a certain extent
I
I am fairly new to Power Automate with very limited knowledge of json. So what I do is copy the solution word for word and just replace with the values that I used.
Thanks
You can also this template here for batch SharePoint updates:
I have seen the ways some other demonstrate batch updates & most still require around 1 action per row. This template is like 10 actions per 800 rows.
Hi @JQuema
If for SharePoint can you try batch to do CRUD operations?
ref link to get started or this to get started
Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.
Any ideas? I'm tagging top solution authors who can probably help.
Perhaps a function similar to SQL that will query the values from SharePoint List_2 that has a matching value in Excel_file but does not have a matching value in SharePointList_1?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2