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
This link is helpful
https://www.damobird365.com/efficien-union-except-and-intersect-great-method/
Any other option?
Any other option?
Due to the number of items, the Flow has been running for more than 4 hours
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.
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