Unanswered

Avoid saving duplicate records to a SharePoint list

(0) Share

Report

Posted on by janineb

Good day

I have an "Event booking app" and need to check 2 fields when submitting to the SharePoint list - i.e. the Date field and the Time field. One should not be able to submit if those 2 fields have identical data in it.

Also, can you perhaps help me with the delegation warning on the gallery?

Sort(Filter(EventBookingSlots,Date=DatePicker1.SelectedDate), StartTime.Value,SortOrder.Ascending)

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey @janineb

can you please copy /paste the code from the screenshot so we do not need to retype?

thanks in advance

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!

OnSelect of the Submit button:
If(Value(StartTimedd.SelectedText.Value)>Value(EndTimedd.SelectedText.Value),Notify("End Time cannot be less than Start Time",NotificationType.Error), Patch(EventBookingSlots, Defaults(EventBookingSlots),{Date: DatePicker1.SelectedDate, StartTime: StartTimedd.SelectedText, EndTime: EndTimedd.SelectedText, Title: DetailsTxt.Text, EventName: EventnameLbl.Text, Venue: VenueTxt.Text}))

On the gallery:
Sort(Filter(EventBookingSlots,Date=DatePicker1.SelectedDate), StartTime.Value,SortOrder.Ascending)

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
please try this instead:
If( Value(StartTimedd.SelectedText.Value) > Value(EndTimedd.SelectedText.Value), Notify("End Time cannot be less than Start Time", NotificationType.Error), If( CountRows( Filter( EventBookingSlots, Date = DatePicker1.SelectedDate, StartTime = StartTimedd.SelectedText, EndTime = EndTimedd.SelectedText ) ) > 0, Notify("Event with the same Date, Start Time, and End Time already exists.", NotificationType.Error), Patch( EventBookingSlots, Defaults(EventBookingSlots), { Date: DatePicker1.SelectedDate, StartTime: StartTimedd.SelectedText, EndTime: EndTimedd.SelectedText, Title: DetailsTxt.Text, EventName: EventnameLbl.Text, Venue: VenueTxt.Text } ) ) )

and this for ur other issue:
Filter(EventBookingSlots, Date = DatePicker1.SelectedDate)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!
Thank you for the guidance, however I am getting this error:
Also, for the gallery - I need to sort the time in descending order for that specific day so I cannot use
Filter(EventBookingSlots, Date = DatePicker1.SelectedDate)

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

this is no error, its a delegation warning.

you can set the delegation limit in the app settings to 2.000 entried (per default its 500).
if you are below the 500 or 2000 entries this should work without problems.

what is the gallery in your app called?

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!

The gallery is called "galOverview".

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you can try to just put FilteredEvents in your items Property of your gallery

there only the items of the collection called FilteredEvents will show

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!

On this part of your code, I am not too worried about the Delegation warning - but it complains about incompatible type for comparison. It also says "Countrows" is not supported by this connector

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
please try the modified approach:
If( CountRows( Filter( FilteredEvents, StartTime = StartTimedd.SelectedText, EndTime = EndTimedd.SelectedText ) ) > 0, Notify("Event with the same Date, Start Time, and End Time already exists.", NotificationType.Error), Patch( EventBookingSlots, Defaults(EventBookingSlots), { Date: DatePicker1.SelectedDate, StartTime: StartTimedd.SelectedText, EndTime: EndTimedd.SelectedText, Title: DetailsTxt.Text, EventName: EventnameLbl.Text, Venue: VenueTxt.Text } ) )

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!

Unfortunately I am still getting an error - the system does not seem to recognise "FilteredEvents"

Was this reply helpful? Yes No