Answered

Delete all items in SP List stops at 100

(1) Share

Report

Posted on by dflemming

Can anyone help with this? I'm trying to delete all items in a SharePoint List before refreshing it. The list has about 300 items in it but the delete action in my flow only does 100. There is only one view and there are no filters on it. I can't see what is preventing the whole list from being deleted.

Kind Regards, Dale

SPlist 100.jpg

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

sudharsan1985 1,325 on at

Like (0)

Report

Hi @dflemming
How are you trying to fetch all the items from the list. When I see the screenshot below, the items retrieved is only 100. If you are using the default 'Get Items' action, try to check the limit and also check whether you are trying to receive the items based on the view. If you still not able to get all the items from the default action, try to use REST API with ID column on the select fields and then loop in through the items to delete. I suggest you use the batch command to delete the items instead of deleting an individual item.

Was this reply helpful? Yes No
Verified answer

dflemming 85 on at

Like (2)

Report

I just found this which fixed my problem. https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-stops-at-100-items/m-p/396985
My pagination was set to default which must be 100. I'm overriding it now an all is working.
Thanks for your prompt response.
Regards, Dale

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @dflemming,

I am glad your problem has been solved by yourself. Generally, the new create Get items will have a default limitation of return is 100, if you want to return more, setting pagination is the way out.

If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No