Hide/ Filter invalid entry?

[jinhaninfotree]

Data Validity: NOT(IN([_THIS], Survey[Ticket ID]))

This is a ticketing system, I'm trying to hide or filter the invalid entry (Ticket ID) if the user already filled in the survey form, and show the Ticket ID if hasn't been filled.  

Any suggestions or solutions?

 

[Suvrutt_Gurjar]

The expression will need to remove the existing row from the evaluation when a record is being edited.

It could be something like below

ISBLANK(
FILTER(
"Survey",
([_THIS] = [Ticket ID])
)
- LIST([_THISROW])
)

List expressions - AppSheet Help

Point to note is that such expressions could fail in multi user environments in edge cases.