Unanswered

Prevent duplicate submission

(0) Share

Report

Posted on by torasan

I created a PowerApp that reports daily topics for the beginning and the end of the day. **I am new to the powerapp software.

I would like to prevent duplicate submissions on powerapp form.

Within the SharePoint list that is linked to the form, I have following columns I would like to use for unique identifiers:

- "Date" with Date type

- "XX Name" with Choice type (from 2 to 5 choices)

- "Form Type" with Choice type (2 choices)

I have tried to create a unique ID column on SP list to prevent duplicates but it did not work.

Please guide me through how I can achieve this

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @torasan

The reason a unique ID doesn't work as any new submission would have a new unique ID, but you can achieve what you're looking for with an If statement. You could have that before your patch to check that no record exists with the same exact values by using something like this before your patch.

If( Date = ThisItem.Date && Choice = thisItem.Choice && FormType= ThisItem.FormType, Patch(Patch code as normal) )
Ali_Sheraz_77 141 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, @torasan
[
Use this code on OnSelect property of button
Set(varSubmitting, true); SubmitForm(FormName); // Replace with your form's submit function
And use this code on DisplayMode
If(varSubmitting, DisplayMode.Disabled, DisplayMode.Edit)
Implement a timer that starts when the button is clicked. While the timer is running, prevent the form from being submitted again.
Add a timer control and set its duration to the time frame you want to prevent another submission (e.g., 5000 milliseconds for 5 seconds).
On the button's OnSelect event, start the timer and disable the button.
On the timer's OnTimerEnd event, re-enable the button for further actions.
]
Please give a thumbs up if this information is helpful.

Best regards,
Ali Sheraz
torasan 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Where do I put this code on? The "Submit/save" button?
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @torasan,

Yes, that's where it would go 🙂
torasan 20 on at

Like
a
(0)

Report
Copy link

Link copied!

This didn't achieve my goal.
Here is my scenario and goal:

If a form with ("date", "Form Type", "XX Name(choice)" exists already, I want to prevent submitting another form that contains the same data in those 3 categories.
Right now, the setting you mentioned prevents me from submitting a new form.
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @torasan, I can refine my suggestion a little bit then. Try this, replacing the names for your relevant data source.

If(IsEmpty( Filter( DataSourceName, DateColumn = DatePicker.Date, TypeColumn = FormTypeDropdown.Selected.Text, NameColumn = NameInput.Text ) ), SubmitForm(FormName), Notify( "Sorry, either the room name is blank or it already exists. Please correct this and try again.", NotificationType.Error, 3000 ) )
torasan 20 on at

Like
a
(0)

Report
Copy link

Link copied!

It gives me an error putting the code on the button. I attached the screen shot below.
Sickle-Cell 600 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @torasan,

Try this one, should be more what you're looking for. if you get another error, please post the screenshot again 🙂

If(IsEmpty( Filter( DataSourceName, DateColumn = DatePicker.Date, TypeColumn = FormTypeDropdown.Selected.Text, NameColumn = NameInput.Text ) ), SubmitForm(FormName), Notify( "Sorry, either the room name is blank or it already exists. Please correct this and try again.", NotificationType.Error, 3000 ) )
torasan 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sickle-Cell ,

I am struggling with the logical test portion of IF statement...
The screenshot is below.