Checking for duplicates when adding via a form

[Givi_B]

Hello!
Is it possible, when adding some value through the Form, to immediately check the presence of this value in the table? To avoid duplicates.
Formula like:
Not(Table.Filter(ID.Contains(CurrentValue).Count()>0))
does not work.

[Quentin_Morel]

Hi @Givi_B

This formula (for a checkbox for example), will show you quickly which row appear several times (based on ID value)

Is that what you want ? I added it directly inside your doc

Please let me know,

Cheers,

Quentin

[Givi_B]

Yes, this will help sometimes, but here I want to generally prohibit entering text or a number if it is already in the database

[Quentin_Morel]

OK Sorry.
As you cannot auto-refer to a column that you want to fill,
create a list of ID outside of your table

And add this condition to your field in form

[Quentin_Morel]

Hi @Givi_B
Did you have a look on that ? Cheers

[Givi_B]

Hi, That helped! Thank you!
I don’t know yet how much this will slow down a large database, but it works great now!