Unable to save the edit

[fteam]

Hi everyone,

Anyone please help me to find out why after click Edit button then I try to save It give me the validation as attached.

s.

[Aurelien]

Hi @fteam

Welcome to the community !

Can you share the valid_If expression you have used for this field ?

[fteam]

and(
in([_thisrow].[ID],User Auth[Matrix]),
not(in([_thisrow].[ID],User[ID]))
)

[fteam]

User table is the current table to edit
User Auth table is the table to verify if user enter ID that contain in User Auth

[Aurelien · Accepted solution]

Thanks.
Assuming:

• this field is in the table “User”
• [ID] is the key_column of this table
• the 2nd term if for avoiding duplicates

I would suggest:

AND(
  IN([_THISROW],User Auth[Matrix]),
  ISBLANK(
    FILTER("User",[_THIS] = [ID])
    -
    LIST([_THISROW])
  )
)

For reference: last example from:

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.

[fteam]

Ok. It worked. Thank you very much.