FILTER ARRAY EXCEPT

(0) Share

Report

Posted on by fgonzalez515

296

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
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

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

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

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Any other option?

Was this reply helpful? Yes No
Verified answer

fgonzalez515 296 on at

Like (0)

Report

This link is helpful
https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

Was this reply helpful? Yes No