You’re offline. This is a read only version of the page.
85
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
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
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
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.
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
