How to extract a list using a different Entitys list

Hi. I would like to achieve the following ListA is a list of EntityA and ListB is a list of EntityB. I want to extract data from ListA that has the same value in Column2 as the data in Column3 of listB.     I have come up with two methods. 1. using a double loop in Microflow 2. use left outer join in OQL to join two tables and filter by condition Is there any other way besides these?
1 answers

You can also use the find action (list operation) inside a loop of listA. If the item in listB is not found, remove iteratorListA from ListA using change list. Return ListA in the microflow.