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
- Bulk Create - Instead of having two conditions; I enforced unique values in the field EmployeeNumber of Create SharePoint List_2, this way the 2nd condition 'does not return a match in SharePointList_2' will no longer be required
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
