Efficient way to check all values of an array to datatable?

Hi UiPath,

Let say I have an array of string.


myArray = {“Banana”,“Apple”,“Kiwi”,“Pineapple”}

and I have an excel file that was save in a datatable below:


My goal is checking every value from the myArray variables to all rows in the datatable.

Hope this question makes sense.


in general we can do it with All / Any

maybe it can be specified more in detail on what return is needed like

true - all array values were found in any rows
true - any array value was found in any rows

a report which array value was found in which row (index) …