Delete multiple items/rows from list.(more than 5000)
I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties.
If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than 1.
One way is to export the properties and delete whole list and then create another list ,add properties....
But I'm looking for another bulk deletion of items from the list, where i can delete all the items and not individual.
Kindly help me out.
Do have a look at the link below:
Put in the formula Delete = True to select all entries.
My bad, was not able to explain comprehensively.
PFB the steps
1. Lets assume a list Lis1 as below. This has 1000 Items
2. Now Create a line item with applies to as this list, format as boolean and mark it true. If you want to delete specific then only mark those
3. Now in Actions, create an action of type 'Delete from List using selection' and point to this line item
Run this action, and it will delete the items
Delete from List using selection is the way you can achieve this. Please check this action in the Settings>Actions. You will have to create a boolean line item with applies to on this dimension and then point this to the particular action as defined
Hope this helps
Thanks for the prompt reply.
Delete from list using selection would required selection of items more than 5000 times.
That would be same as selecting/deleting from list.0
Thank you for the prompt reply.
I have tried that method but that would required another clicking 5000times to the rows to delete.
Any other method to delete under 10click (10 is also more but would be less than 5000)
It was mentioned in my previous post, but i'll repeat.
Put in the formula 'Delete = True' in the module to select all entries automatically.
Thank you Akhil.
This worked but in module!
it took me a lil time to understand!!
Anyways, Thanks a lot.0