It would be helpful to use conditions “is in” and “is not in” in conditional formatting.
I would like to use it in such a way that the color is changed only when the array contains the contents of a record.
Hey @ai-ohara ,
Thank you for the feedback! I agree- we should add this to the existing condition type set. In the meantime, it would help the team to prioritise if other users upvoted this post!
2 Likes
Just bumping this to see if any progress has been made on this front @canaalpaslan.
I’m in a situation where I’d like to highlight a row if a certain table field value is listed in an array variable (in this case, it’s a numeric array, but I imagine the logic across the various types of arrays would be similar).
Hi @Preston thank you for the bump. We’re keeping an eye on threads like this and are prioritizing this against other requests based on upvotes. Keep the feedback coming - we try to slot in one or two requests like this in every sprint, but this one hasn’t made it yet.
A workaround could be to Join your array to a string and use the conditional formatting “contains” with the string.
However you always have to make sure, the string is the same as the actual array.
If the array is manipulated before entering the step or on one trigger only, you can use that trigger or the step enter. If it is hard to control, you could use a custom widget to always sync this array to a text variable…
1 Like
As shown in the figure below, even when I try to use “contains”, it only responds to exact matches. Is this the intended behavior?
I would like “contains” to work with partial matches.
Is there no issue with @Tadeu’s instance?
Is there any way to do this?
This approach will not work.
Because it will not look if the joined string contains the column value, but if your column value contains that sring.
1 Like