FILTER ARRAY EXCEPT

[fgonzalez515]

Hello Community,

I have two tables "DTE" and "BCO". I want to get the "Table Except"
Use the concept of Except using Filter Array. I concatenate the items of each column of each table, but I can't get the expected result. Is the flow I made ok?

It is an example or test table

My Flow

[v-peijunz-msft]

Hi @fgonzalez515,

Based on your description, I have made a simple test for your reference.

1. I have a Excel file called FilterArray, it stores three tables (Table1, Table2, and Table3).

2. Here is my flow:

@and(equals(item()?['Rut'], items('Apply_to_each')?['Rut']),equals(item()?['CR Luciano'], items('Apply_to_each')?['Obra']))

length(body('Filter_array'))

3. Result screenshot:

Best regards,

Sylvia

[fgonzalez515]

Hi @v-peijunz-msft,

Thanks for you information.

Is there any other way to make the flow run faster?
The number of items to review is more than 10,000.

[fgonzalez515]

Any other option?
Due to the number of items, the Flow has been running for more than 4 hours

[fgonzalez515]

Any other option?

[fgonzalez515 · Accepted solution]

This link is helpful

https://www.damobird365.com/efficien-union-except-and-intersect-great-method/