I've created a visual work flow that has a fast lookup. The lookup basically finds the Account_Share records that have a parent account id equal to a variable.
I'd like to take this a step further and have it only return the Account Share records that have a parent account equal to the variable mentioned above AND are related to users that have a UserType of PowerPartner (this is stored in the user table).
How would I go about doing this? I would think that you could somehow reference fields in the user table since the Account Share table and the User table are related, but I can't seem to figure out how to enter cross-object criteria like this into the fast lookup window.
I'm thinking that I could do a fast lookup on the User table to return a sObject Collection of PowerPartner User Ids, and the iterate on that to get those users that have an Account Share record. I'm just not sure how to do that. Essentially, it seems like I need to use the User table "query" as a "sub-query". Can this be done in flows?