Hi, I want to retrieve a list from the database and filter the items based of a second list. Almost like an inner join in SQL. But, I do not want to do this using a loop and querying the database for each line in the filter list. Regards
Danny de Beer
You can retrieve both lists and check in a nested nested loop. No need to retrieve new objects for every line.
In a microflow, add a list/list operation action and do an intersect between the 2 lists
I cannot do that, as the 2 lists are different objects, and that is not supported with list operation