Answered

verifying if exist any event before creating a new one

(0) Share

Report

Posted on by jdanielhdezr

hello everyone. I need to create an app that makes bookings for auditoriums and classrooms, but before creating an event or reservation, I need to verify that there is space, both physically and in time. I created a code, but it is not validating the existence of the previous event.

If(CountIf('test calendar';'Ubicación'=Dropdown1.SelectedText.Value;'Hora de inicio'=DateValue1.SelectedDate;'Hora de finalización'=DateValue2.SelectedDate)=0;If(SubmitForm(Form1);;ResetForm(Form1);Notify("Evento creado correctamente";NotificationType.Success;3000);Notify("Ha ocurrido un error. Por favor comunicarse con TI";NotificationType.Error;3000));Notify("Ya existe un evento en el "+Dropdown1.SelectedText.Value+" a esa misma hora en ese mismo día";NotificationType.Error;3000))

any ideas? thks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Hassan_SZ_365 542 on at

Like (0)

Report
Copy link

Link copied!
Hi ,
Here's a refined version of the code you provided:

If(
CountRows(
Filter(
'test calendar',
'Ubicación' = Dropdown1.SelectedText.Value,
'Hora de inicio' < DateValue2.SelectedDate + Time(Value(HourValue2.Text), Value(MinuteValue2.Text), 0),
'Hora de finalización' > DateValue1.SelectedDate + Time(Value(HourValue1.Text), Value(MinuteValue1.Text), 0)
)
) = 0,
// No conflicting event, proceed with form submission
If(
SubmitForm(Form1),
Notify("Evento creado correctamente", NotificationType.Success, 3000),
Notify("Ha ocurrido un error. Por favor comunicarse con TI", NotificationType.Error, 3000)
),
// Conflicting event found, notify the user
Notify("Ya existe un evento en el " & Dropdown1.SelectedText.Value & " a esa misma hora en ese mismo día", NotificationType.Error, 3000)
)
Make sure to replace placeholder text with the actual names of your columns for location, start time, and end time in the 'test calendar' list and adjust the date and time manipulation based on how your date and time are structured in your app.

Best Regards,
Hassan Raza
@jdanielhdezr

Was this reply helpful? Yes No
jdanielhdezr on at

Like (0)

Report
Copy link

Link copied!

Thanks for your solution, it worked perfect in that scenario, but in time ranges it still doesn't respect the booking. For example, if there is a booking from 8 a.m. to 7 p.m., and a new one is added in the same place between 10 a.m. and 3 p.m., it does so as the code allows it, or between 7 a.m. and 11 a.m. How can that be solved?

Was this reply helpful? Yes No