Skip to main content
Community site session details

Community site session details

Session Id : RLj+FQA5CpDeKCute25in4
Power Automate - General Discussion
Suggested answer

Bulk Update/Create/Delete SharePoint List

Like (1) ShareShare
ReportReport
Posted on 17 Jun 2022 05:11:34 by 10

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

  • lbendlin Profile Picture
    8,077 Super User 2025 Season 2 on 05 Aug 2024 at 20:24:58
  • Suggested answer
    Arnaud LG Profile Picture
    4 on 05 Aug 2024 at 14:45:37
    Bulk Update/Create/Delete SharePoint List
    You will need to rework the "MyFilter", but then you should be able to perform a bulk update:
    With(
      {
          tempTable:Filter(MySharePointList, MyFilter)
      },
      ClearCollect(_Batch,tempTable);
      ForAll(tempTable,Patch(_Batch, ThisRecord, {Status:{Value:"Validated"}}));
      Patch(
              MySharePointList,
              _Batch
          )
    );
  • takolota1 Profile Picture
    4,898 Moderator on 29 Aug 2022 at 01:31:45
    Re: Bulk Update/Create/Delete SharePoint List

    @JQuema @Shujaath_Khan 

     

    You can also this template here for batch SharePoint updates:

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-External-Data/td-p/1365410

     

    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.

  • Shujaath_Khan Profile Picture
    1,111 Super User 2024 Season 1 on 21 Jun 2022 at 10:51:17
    Re: Bulk Update/Create/Delete SharePoint List

    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.

     

  • JQuema Profile Picture
    10 on 21 Jun 2022 at 01:25:03
    Re: Bulk Update/Create/Delete SharePoint List

    Any ideas? I'm tagging top solution authors who can probably help.

     

    @Rhiassuring @Shujaath_Khan @DamoBird365  @ScottShearer 

  • JQuema Profile Picture
    10 on 17 Jun 2022 at 05:18:43
    Re: Bulk Update/Create/Delete SharePoint List

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete