There are array formulas available to filter list based on criteria and pluck specific field values in matching records: https://docs.workato.com/formulas/array-list-formulas.html
Send us a ticket, we will try our best to assist you with your problem
Search in list
I would love to see a new way to search on a list. Something like a lookup function to search for a value in a list and return another field in the matching record.