Hi @ciprianpopovici,
Do you want to create a car booking system?
Could you please share a bit more about your need?
Actually, you should prepare a SharePoint list including the Car(Choice), ReceptionTime(Date and time) and ReturnTime(Date and time).
Note that you need to make the Car field Required so that each user must select a car before he create a request.
You could generate an app directly based on the data source as below:
Then you could get an app with three different screens:
Set the OnSelect property of the submit button as below:
If(
!(DataCardValue8.Selected.Value in Concat(
Filter(
Actions,
And(
DateValue1.SelectedDate + Time(
Value(HourValue1.Selected.Value),
Value(MinuteValue1.Selected.Value),
0
) >= ReceptionTime,
DateValue1.SelectedDate + Time(
Value(HourValue1.Selected.Value),
Value(MinuteValue1.Selected.Value),
0
) < ReturnTime
) || And(
DateValue2.SelectedDate + Time(
Value(HourValue2.Selected.Value),
Value(MinuteValue2.Selected.Value),
0
) > ReceptionTime,
DateValue2.SelectedDate + Time(
Value(HourValue2.Selected.Value),
Value(MinuteValue2.Selected.Value),
0
) <= ReturnTime
) || And(
DateValue1.SelectedDate + Time(
Value(HourValue1.Selected.Value),
Value(MinuteValue1.Selected.Value),
0
) <= ReceptionTime,
DateValue2.SelectedDate + Time(
Value(HourValue2.Selected.Value),
Value(MinuteValue2.Selected.Value),
0
) >= ReturnTime
)
).Car,
Car.Value,
","
)),
SubmitForm(EditForm1),
Notify(
"Already reserved!",
Error
)
)
Note that the 'Actions' is my data source and the DataCardValue8 represents the Combo Box corresponding to the Car field in your SP list.
DateValue1, HourValue1, MinuteValue1 separately represents the Date Picker and hour picker and minute picker as below:
Here is a demo, you could check the attachment for details.
