Power Platform Community Forum Thread Details

Hi Community,
I am creating a Power apps solution for booking our company car.

I have a Sharepoint list for storing all the bookings.

I don't want the user to be able to users to double book the car,

So I want the "On change" for the "Start time" date picker and "End time" date picker to check if the selected dates in the booking form is overlapping with the existing bookings in the sharepoint list (Star Time(date+time) to End Time(date+ time)) fx I want to allow booking on the same date if the time is not overlapping

If the date is already booked, I want to activate an error message and disable the submit button.

Do any of you have an idea on how I should write the formular for the Onchange for the date pickers?