Question edited per feedback...
The problem at its core: I need to be able to assign net new accounts to various groups of people based on a large list of billing zip codes. In some cases, I only need to assign based on the billing State. I'm not a programmer, so I would like to accomplish this with a lightning Flow.
Not sure if this is important or if it will serve to confuse things further, but here's what I've already built in an attempt to solve this:
Objects I've created:
- Zip Code Group - to house groups of zip codes
- Zip Code Group Member (Master-Detail Relationship) - basically, zip codes
- Record Assignment Group (groups of users based on region)
- Record Assignment Group Member (the users)
I have an Account-based record-triggered flow. Here's what is already working in the flow: When an account is created, if billing state = "x", assign new account to a group member in the appropriate Assignment Group. This already works. However, when I attempt to reference the list of zip codes in the decision element, it doesn't pull back expected result.
I built the flow with a Get Records element to get all Zip Code Group Member records, and next, I have a decision element that includes filters for "Billing State/Province", but I can't figure out how to reference the Zip codes in a filter. I've tried Collection Filters, and the debug log DID show the Collection Filters pulled back results, however when I attempted to filter in the decision element on items in Collection Filter, it returned null.
How can I accomplish the above requirement?