How do you search a subset of things by the value of some attribute?

I am stumped and embarrassed. How do you search a subset of things by the value of some attribute? For example, say, there are millions of Users with an attribute of “gender” (a.i.female, male, etc.). There are companies with attribute of “employee” (a.i. list of users).

My workflow has found a company and set a state (say, current company) with, say, 10 employees and I want to set another state (type user) “first male employee” to the first instance of a male employee (a.i. user) of that company.

Seems like a simple expression. I want to search these 10 employees for a first instance of male and I have not been able to figure out the actual expression.

Anyone with a suggestion? Any pointers to a previous conversation on this topic.

Hello @seedling welcome to the community!

What you describe is straightforward functionality in Bubble

These videos may shed some more light on the subject:

Thank you kindly smarchan. The third video, at about 12 min, addresses the issue with the use of “filtered” option.