I'm having users select values with a multi select picklist (the worst) in the flow that correspond to values in a field on the account, let's say industry. They select Industry1 and Industry2. I want to do a fast lookup where it finds any account that has either Industry1 or Industry2 selected.
Is there any way to do a lookup where one of the values can be either or?
I've tried delimiting the field input value with ; and , and neither worked. As it stands I need to do a lookup for all accounts, then Loop through them all and check if they have the appropriate field value based on what the user selected.