filterByFormula find in array the exact value

Hello,

I’m trying to create a filterByFormula that finds a certain value in an array.

Here is an example. I have this array:

image

Using filterByFormula I want to get the values that have exactly the word Azure. So in this case it should get only the first Azure, not Azure Cloud.

I tried to use FIND OR SEARCH but this 2 return both these values.

Some kind of workaround I found doing the formula like this:

AND(OR(FIND('Azure,', ARRAYJOIN(Skills,','))))

So I’m converting the array into a string and then search for Azure,. Yes, that is a comma :slight_smile:

This way I’m able to select the Azure value.

But as you can see in the example above I also have Python and [emptyspace] Python (the brown one). If I use the above method I only get the first Python even thought I should get the second one too. This one is weird. I’m not sure why this is happening to be honest.

Is there a function to find a specific value in the array ? Not using SEARCH or FIND?

Thanks

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.