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”)
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:
