Check if a value is IN a list

1

Hi everyone,
In the following table (Companies E&B), column “AUTRE NOM” I have a list of names separated with a comma “,”.
I want to check if a certain the value of “Company_AI” is IN the list
I used the following formula, which is not working :

ForEach([Companies E&B].[AUTRE NOM], CurrentValue.Contains(thisRow.Company_AI)=“false”)

image
image1302×351 33.7 KB

2

Hi Zainab,

It is always very helpful if you could share a link to the doc where you are having problems, or at least a sharable copy.

I do not see a column called Company_AI in the screenshot? I also do not know what you mean with “list.”

However, below is a comparison of all the different variations in which you can search for something in a list/table:

1 Like
3

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