Enumlist with valid if select expression show invalid when re-edit the row

[Hyman_van_Zyl]

Hey all,
I have a enum list field which is filtered with a valid if select function. It all works well except when you edit the row at a later stage you get the “this entry is invalid” under the enum list field. If you reselect the same values, the error message disappears again until you edit the row again.
Anyway to get rid of the error message?
Thanks,
Hyman

[Steve]

What is the Valid If expression?

[Hyman_van_Zyl]

SELECT(Objectives[Objective Name],[Project]=[_THISROW].[Project])

[Steve]

What is the name of the EnumList column?

[Hyman_van_Zyl]

Objective/s

[Steve]

Is the EnumList column set to Allow other values?

[Hyman_van_Zyl]

Yes

[Steve]

I’m scratching my head on this one–I don’t know what’s wrong. Perhaps reach out to support@appsheet.com?

[Clark_Villocill]

There definitely has to be a problem when dealing with enumlist expressions. In my case, I tried to compare a string from a value taken from a “list of enumlist”, using the formula

ANY(TABLE[Enumlist_Column]) = “STRING”.

No matter what the value is, the expression will always result to false.

I even tried to convert the left hand side to text before the comparison but the same result prevails

TEXT(ANY(TABLE[Enumlist_Column])) = “STRING”.