I was working with a group this week that was looking to pass in an array of values as a lookup filter. The equivalent of a SQL "IN" statement seemed to make the most sense, but that is not a currently supported option.
The best option at the moment is to parse the array into separate fields and use up to 5 values to search the table. Any more than 5 options is not allowed due to the filter constraints.
Anyone else run into other conditions they couldn't account for with the existing lookup element?
Please sign in to leave a comment.