Power Platform Community Forum Thread Details

I have a "BikeBook" list where users can book bikes. When a new item is created, I want to check the values of BikeName, BookingDate, and BookingStartTime. If another item is created with the same BikeName, BookingDate, and BookingStartTime, the item should not be created, and an error message should be displayed. I want to prevent double booking for the same bike, on the same date, and at the same time. How can I achieve this using Power Apps?

Categories:

Power Apps Pro Dev & ISV

To prevent/stop double booking from your Power Apps form, you can implement a validation check before submitting the form.
Let's say, you have a Dropdown for BikeName, Date Picker for BookingDate, and a Time Picker for BookingStartTime. You will have a Button to submit the form.

On the OnSelect property of the button, add the below code:

If(
    CountRows(
        Filter(
            BikeBook, 
            BikeName = DropdownBikeName.Selected.Value && 
            BookingDate = DatePickerBookingDate.SelectedDate && 
            BookingStartTime = TimePickerBookingStartTime.SelectedTime
        )
    ) > 0,
    Notify("This bike is already booked for the selected time and date.", NotificationType.Error),
    SubmitForm(BookingForm)
)

Optionally, you can also disable the Submit button if conflict is detected. This ensures that the submit button is only enabled when there is no conflict.
On the DisplayMode property of the button, you can add below code:

If(
    CountRows(
        Filter(
            BikeBook, 
            BikeName = DropdownBikeName.Selected.Value && 
            BookingDate = DatePickerBookingDate.SelectedDate && 
            BookingStartTime = TimePickerBookingStartTime.SelectedTime
        )
    ) > 0,
    DisplayMode.Disabled, 
    DisplayMode.Edit
)

-------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,
Vipul