I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action.
Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually.
Thanks for your help,
Go to Solution.
Another possibility is that these 3 lists have selective access turned on and you've granted yourself the R/W access to the Top Level Item from FIN1.
Members without parents can't be seen by you in the module though you can see them in the List as the workspace admin.
View solution in original post
You can use delete from list using selection.
create a module with the list and a boolean line item and put the formula= isblank(parent(item(list)))
It will make true for all the items which does not have a parent and you can use that line item for your delete action.
Thanks for your reply.
When i create a module with this list i cannot see the list items with a blank parent so my delete condition is always false.
Are you using a subset of list in module?
I haven't seen what you are saying ever before. Please share SS if possible.
If an item in list and its used in module I am 100 percent sure that it will be there in module
I have 2 lists with parent child relationship shown above.
All members from L2 Account have parents, except X.
1. A system module is created, where the 'Delete?' line item checks if L2 Account has any parents.
Create and run the above action, and X (or any new L2 Account members in the future without parents) will be deleted.
Thanks for all replies.
I forgot to mention that this is a numbered list, I dont know if that makes a difference.
See below the screen-shots:
The goal is to delete items of FIN3 numbered list
Example of item with no parent in the list:
The result with the filter:
At what part of the process are you stuck?
It looks like you have all the elements needed.
The delete module doesnt contain the items with no parent.
Example with this one:
Not sure if it's because of the numbered list ?
Can you show us the formula of 'FIN3 Parent Account#.NoParent?', i.e. the property in the 'FIN3 Parent Account#' list?