How to extract a list using a different Entitys list
0
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?
asked
Megumi Koshiba
1 answers
0
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.