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
Solved! Go to Solution.
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']))
3. Result screenshot: