Delete all items from a SharePoint list

[manu59]

Hi all,

I want to create a flow to delete all items from a SharePoint list.

With actions "Get items" and "Delete item" for each item I get, the flow works ... but it is very long, there are near 10000 items in the SharePoint list.

Do you know if there is an "Http request" action or something else to be more efficient ?

Best regards

[abm]

Hi @manu59 

Please follow this link

https://alextofan.com/2019/08/22/how-to-get-more-than-5000-item-from-sharepoint-online-in-flow/

Thanks

[v-bacao-msft · Accepted solution]

Hi @manu59 ,

First, you need to set Pagination to get the maximum number of return items in order to remove the expected items.

Secondly, in order to provide the execution speed of the action in Apply to each, you can set Degree of Parallelism:

Please try to make the above changes and see if the execution of Flow is in line with your expectations.

Image reference:

Best Regards,

[manu59]

Hi,

I succeded to create the flow.

But it takes too long time to run = 1 hour to delete 8000 rows in a SharePoint list !

Have any ideas, something like an http request ?

Best regards

[neo1113]

thank you for sharing! this helps me a lot in my current process.

[mah565]

Why I cannot find these two flows in the list?      Get Items       and          Delete Item 

Where can I find them?

[ChristiaanNL]

@mah565  You can find the two actions under the Actions tab

Currently according to the screenshot your are looking under the triggers section