Hello @fgonzalez515
As long as RUT FOLIO and CR form a unique key that is different for every row in the table…
I would use two Excel List rows actions to get both the tables in Power Automate..
Then use a Select action and in the array From input field, use the intersection expression on the values output of both the Excel List rows, like: Intersection(values(List rows 1), values(List rows 2)). That should generate an array with only the matching values between the two tables. In the Key field just put “Key” and in the value field put item()?[‘RUT’] item()?[‘FOLIO’] item()?[‘CR’] just enter each expression one after the other so it basically concatenates them. That should generate a unique key for each of the matching items in the two tables.
Then use a Filter array action with the BCO table’s Values output in the From array input.
In the filter conditional use String(Body(‘Select’)) Does not contain item()?[‘RUT’] item()?[‘FOLIO’] item()?[‘CR’]
That should check if the list of unique keys from the matching records contains the unique key of each record from the BCO table and only return the records not in the matching records list.
From there you can use a Parse JSON on the Filter array action to get the records into dynamic content.
That should accomplish things in a really efficient way incase you have a lot of records.
