Unanswered

Unique Field when submitting form

(0) Share

Report

Posted on by AlvinCassar

Hi,
I have a form which looks like this:

When creating a new event or editing an existing one, I need to make sure that the Event Name is unique from any others.
On the submit key,

I have this code, which works perfectly when adding a new event, and blocks the user from adding the user the same event name.

This also works perfectly if a user wants to change a current Event Name to another name which an Event already has.

But, this does not work when clicking edit, changing the description for example and trying to resubmit the form with the old Event Name as this name would have already been found in the table as an Event Name.

If(CountIf(Events, 'Event Name' = varEventName.Value) < 1,
 SubmitForm(EditForm1),
 Notify("Event Name cannot be used as it already Exists.", NotificationType.Error));

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AlvinCassar ,

The below formula is meant to check if the eventname already exists and if it is, if it's the event name of the item currently selected in Gallery1 (you will have to change this name to the name of your gallery):

With({ _Temp: LookUp(Events, 'Event Name' = varEventName.Value) }, If( IsBlank(_Temp) || _Temp.ID = Gallery1.Selected.ID, SubmitForm(EditForm1), Notify("Event Name cannot be used as it already Exists.", NotificationType.Error) ) );

Basically this excludes the currently edited record from the rule.

Was this reply helpful? Yes No
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,

Thanks for your response and this works for when editing an existing event, but when adding a new event, it does not care for others and will add no matter what the name is.

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlvinCassar ,

Can you please provide an example and share which of the two conditions is returning a true?

Was this reply helpful? Yes No
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BCBuizer,

Sorry for the late reply, basically the problem occurs when;

If an event is called "Testing 4" I can add a new event called "Testing 4". (which is incorrect)

But, when an event is called "Testing 4" and I want to change it to "Testing 3" while another event is called "Testing 3" this does not let me change it. (which works how it is intended to)

Basically this is my code,

With( { _Temp: LookUp( Events, 'Event Name' = varEventName.Value ) }, If( IsBlank(_Temp) || _Temp.'Event Name' = BrowseGallery1.Selected.'Event Name', SubmitForm(EditForm1), Notify( "Event Name cannot be used as it already Exists.", NotificationType.Error ) ) );

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AlvinCassar ,

How is varEventName populated? Perhaps this should be replaced with at reference to the DataCardValue that has the Title:

With({ _Temp: LookUp(Events, 'Event Name' = DataCardValue1.Text) }, If( IsBlank(_Temp) || _Temp.ID = BrowseGallery1.Selected.ID, SubmitForm(EditForm1), Notify("Event Name cannot be used as it already Exists.", NotificationType.Error) ) );

Was this reply helpful? Yes No
AlvinCassar 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlvinCassar ,

Did you try the formula I shared in my previous post? It seems I accidentally chose the correct name for the DataCardValue, so it should work as it is.

Was this reply helpful? Yes No