Delete something in list that are not in the other list
0
i want to delete data in list that are not exist in the other list both list are from the same identity but the other list i loop to search a specific data, and if the other list data exists datas that are not exist in the other list i want to delete it so the data in DB_GroupDivision_1 that are not exist in DB_GroupDivision_Compare will be deleted is there a way for this ?? thanks
asked
teuku ryan
5 answers
1
Your microflow should look something like this:
answered
Kasper de Graaff
2
Hi,
Use the list operation Subtract to remove the list DB_GroupDivision_Compare from the list DB_GroupDivision_1. You can delete the list that remains.
answered
Kasper de Graaff
1
For the objects that need to be deleted, add them to a new list, and then delete these objects using the delete activity and point to this list.
for finding data which is nor present in other list, use list operation (filter by expression) in that write a condition where $currentobject!=$listname. then use subtract activity to subtract the list which is not present.