delete all list items

[Anonymous]

Dear community,

I have created a SharePoint List where users can register themself as a visitor through a power app. 
At the end of the day I would like to clean this list by using a microsoft flow.

I already found the schedule function to trigger the flow at 0:00am. But there is no function to delete all the list items in a sharepoint list. Unfortunately  I could only find to delete one item, that needs to be specified as an unique id.

Does anyone now a quick solution to this? Thank you in advance.

[Anonymous · Accepted solution]

I have found the solution. I combined the "get items" and "apply each" operator.
For people who are interested, see https://docs.microsoft.com/en-us/flow/apply-to-each.

Here is an overview of my solution

[aweedman]

Hi. I just tried your method. It is sporadically deleting items and misses many.  Strange.

[WDRC]

All,

I need some help please.  I have unsubscribe email account that by its nature will trigger a flow that I want to delete that persons data from some SharePoint lists.  I have limited knowledge of the delete items action in o365 SharePoint.  What do I need to do to make the flow work below? 

 

The list has multiple fields and all should be deleted as part of the process.

Can someone please give me some guidance.

Regards

Andrew

[Shin]

in the Get Items section of your flow, try setting the number really high. The "Default" says it will get all items, however; it doesn't work. Instead set a item limit well beyond the total in the list to get a more consistent result.

[Rodolfo1840]

Same issue here.

Even if I try to select all items in SharePoint page and I click Delete. It won't delete everything....

[Rodolfo1840]

Just to clarify. The field is Top Count:

[beatz62]

You also need to switch on pagination in the action's settings (right clip on the ellipse) or it will only pick up the first 100 items

[Anonymous]

I understand this is an old issue, but I am still seeing a similar issue in sharepoint online.

In my list, I don't have many items so it deletes all successfully but then I get "Item does not exist" and workflow fails. Would really appreciate any help, thanks!

Item does not exist.

The page you selected contains an item that does not exist. It may have been deleted by another user.
clientRequestId: XXXX serviceRequestId: XXXX

[Rodolfo1840]

An alternative (if you are allowed), it's delete them programatically via PowerShell - https://www.crowcanyon.help/article/338/