Answered

prevent of create duplicate item in powerapps

(0) Share

Report

Posted on by lha1bj

Hello,

I would like to avoid duplicate entries when submitting the form, but only when form is in new mode (edit and submit of existing item with same button is fine). Where should I write the FormMode.New statement?

button OnSelect:

If(IsBlank(LookUp('CAD worklist'; Title=DataCardValue1.Text));
SubmitForm(edit_form);
Notify("Change Nr. already exists";NotificationType.Error);;
SetFocus(DataCardValue1)
)

Thank you very much

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try adding a second condition to your If() statement:

If(IsBlank(LookUp('CAD worklist'; Title=DataCardValue1.Text)) && edit_form.Mode = Formmode.New; SubmitForm(edit_form); Notify("Change Nr. already exists";NotificationType.Error);; SetFocus(DataCardValue1) )

Hope that helps,

Bryan
lha1bj 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, I tried to add the statement, but it is still blocking me to update current items.
Any idea how to correct the code please?
Thank you
Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You can configure additional options on the If() statement to handle these situations:

If( (IsBlank(LookUp('CAD worklist'; Title=DataCardValue1.Text)) && edit_form.Mode = Formmode.New) || edit_form.Mode = Formmode.Edit; SubmitForm(edit_form); Notify("Change Nr. already exists";NotificationType.Error);; SetFocus(DataCardValue1) )