each of our leads has a "rep" (lead owner) field attached to it. We have another field called "isRep" to show which of our records belongs to a rep (someone that owns leads).
I would like to send emails to all records where the lead owner's state is California. How can I do that?
I do not want to add a lead owner state col. I am using this as an example. In reality I will have other flows that set the status of a rep record 's column of sendClientEemails to yes or no. So it is actually more like sending email to records where records' lead owner's value of "sendClientEemails" email is "yes".