Delete items of list with no parents

[Maxime.Schaller]

Hello all,

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,

Maxime

[abhay.kanik]

@Maxime.Schaller 

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

Abhay

[Maxime.Schaller]

Hi Abhay,

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.

Regards,

Maxime

[abhay.kanik]

@Maxime.Schaller 

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

[LipChean_Soh]

Hi @Maxime.Schaller 

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,

LipChean

[jimfeng5]

Hi Maxime,
Please share screenshots if you can. I tried to mimic your problem but I have no issue with deleting action using a system module.

Jim

[Maxime.Schaller]

Hi,

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:

Delete module:

The result with the filter:

Regards,

Maxime

[LipChean_Soh]

Hi @Maxime.Schaller 

At what part of the process are you stuck? 

It looks like you have all the elements needed.

Thanks,

LipChean

[Maxime.Schaller]

Hi LipChean,

The delete module doesnt contain the items with no parent.

Example with this one:

Not sure if it's because of the numbered list ?

[LipChean_Soh]

Hi @Maxime.Schaller 

Can you show us the formula of 'FIN3 Parent Account#.NoParent?', i.e. the property in the 'FIN3 Parent Account#' list?

Thanks,

LipChean