How do I prevent duplicate rows?
I have a table with items and the item names are in the [Name] column. I want to prevent adding another row for the same item. I had the [Name] column as the key, which prevents duplicate names, but it appears that the key column is not editable in the form view.
I found this expression in the community, VALID_IF = NOT(IN([_THIS],Item[Name]) which does prevent duplicate name from being added. But again, run into problems when editing a item. I can edit the name and save. But if I am editing any other field and keeping the name the same, I am unable to save the changes.
My third attempt was to make a virtual column that duplicated the name
column and make it the key, but it had the same affect as making the original name column the key. I was unable to edit the name.
Am I trying to do the impossible?