Solved: Change system text message - Page 2

jacopo_spinelli · 06-11-2020 04:48 AM

Hi everyone,
I created an app where I’m using the date column as key since I have to enter 1 dataset only per day. If I enter another set of data on the same day I’m correctly getting the warning message “there is already a row with key mm/dd/yyyy”, I’m wondering if I can customize somehow this message.
Thanks.

Steve

Try:

ISBLANK(
  FILTER(
    "table-name",
    ([_THIS] = [column-name])
  )
  - LIST([_THISROW])
)

Replace table-name with the name of the table, and column-name with the name of the column that shouldn’t contain duplicate values.

Not correct. Valid If is evaluated before the check for a duplicate key. Give it a try!

View solution in original post