Filter two lists to find missing items and store them in an excel file

[zainab1]

I have two lists of customers list1 all customers list2 deleted customers.

I want to filter deleted customers from all customers and store remaining customers of list1 in an excel file. I am using Filter Array action but its is not working I tried adding both lists' customer id's in varaibles and them filter array for these two variables but still my filtered arary is showing all customers from customer list.

Please help me filter this out

Thanks!

[v-yetonggu-msft]

Hi @zainab1 ,

I did a test for your reference.

In my scenario:

My Flow:

I initialize three array variables.
The AllDisk variable contains all ID.
The Disk variable contains the ID that we want to delete.
The remaining customers ID variable is the ID we want to keep.

Using 'Apply to each' and 'Filter array'.
When the ID in Disk is equal to the ID in AllDisk, length(body('Filter_array')) is equal to 1, not equal to 0, and no operation is performed when entering the no branch.
When the ID in Disk is not equal to the ID in AllDisk, length(body('Filter_array')) is equal to 0, enters the yes branch, and is appended to the remaining customers ID variable.
(As long as the ID in Disk is not equal to the ID in AllDisk, we append this ID to the remaining customers ID variable)
After many loops like this, the AllDisk variable filters the Disk variable.

item()?['ID']
items('Apply_to_each')?['ID']
length(body('Filter_array'))
{
  "ID": @{items('Apply_to_each')?['ID']}
}

Best Regards,

Sunshine Gu

[zainab1]

Hi, 

Thank you for your response.

I am trying out your solution but I get error in the condition field

length(body('Filter_array'))

[zainab1]

All the conditions are getting false and I am getting null array at the end .

Filter array: @equals(item()?['ID'], items('Apply_to_each')?['ID'])

Condition: Length(Body('Filter_array')) is equal to 0

I am unable to add this same code for saving filtered array in the variable 

{
  "ID": @{items('Apply_to_each')?['ID']}
}

so instead I am using this

 {
"ID": items('Apply_to_each')?['ID']
}