Showing error while editing and updating

[Sayad]

The function is working but I want this expression to work only while adding. But this function is working even while updating. how can i fix it.

[graham_howe · Accepted solution]

If a record is being added, then it won't exist in the table until the form is saved. That means you can spot an update with the following because the row will exist in the table:

ISNOTBLANK(
  FILTER(
    "My Table",
    ([_THISROW].[_ROWNUMBER] = [_ROWNUMBER])
  )
)

[Joseph_Seddik]

@graham_howe Thank you!

[Steve]

Shorter:

NOT(IN([_ROWNUMBER], My Table[_ROWNUMBER]))