Hi @Anonymous ,
In a customized PowerApps form for the SharePoint list (it should include a Date only column and a start time column), you can set OnSelect of the submit button, if yes, reset the DatePicker and Hour/Minute dropdowns and also push a notification to user:
If(
IsBlank(
LookUp(
YourList,
DatePicker.SelectedDate = Date
&&
((Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0) >= Start
&&
Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0) < DateAdd(Start,30,Minutes))
||
(
DateAdd(Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0),30,Minutes) >= Start
&&
DateAdd(Time(HourDropdown.Selected.Value, MinuteDropdown.Selected.Value,0),30,Minutes) < DateAdd(Start,30,Minutes)
)
))
),
SubmitForm(FormName),
Reset(DatePicker);Reset(HoursDropdown);Reset(MinutesDropdown);
Notify("Selected Date and Time is busy/unavailable, try some other time",NotificationType.Warning)
)
Best regards,