Power Platform Community Forum Thread Details

I built an asset reservation system based on a solution provided by @WarrenBelz in this post:
Solved: Asset availability - Power Platform Community (microsoft.com)

It works great with one exception that I can't seem to figure out.

I think the original solution only relied on date values. Mine also uses time. Again, everything works perfectly except for this one thing. When an item that was reserved from, for example, 15 May 8:00 AM to 15 May 4:00 PM then has a reservation attempt for 15 May 10:00 AM to 15 May 2:00 PM, BETWEEN the check out and due date/times, the device appears as available in the dropdown.

This is the code I used for the items in the dropdown control:

With(
 {
 wReserve: Sort(
 VivariumAssetReservations,
 ID,
 SortOrder.Descending
 ),
 wAsset: Sort(
 Filter(
 'Vivarium Assets',
 Status = "Available"
 ),
 ID,
 SortOrder.Descending
 ),
 wFrom: varReservationCheckOut,
 wTo: varReservationDue
 },
 Filter(
 wAsset,
 !(Device in Filter(
 wReserve,
 Device,
 ('Check Out Date' >= wFrom && 'Check Out Date' <= wTo) || ('Due Date' >= wFrom && 'Due Date' <= wTo)
 ).Device)
 )
)

This is the code to set the varReservationCheckOut variable in the OnChange of the check out date control and its time selectors (hours and minutes):

Set(
 varReservationCheckOut,
 If(
 Not IsBlank(ReservationCheckOutValue.SelectedDate),
 DateTime(
 Year(ReservationCheckOutValue.SelectedDate),
 Month(ReservationCheckOutValue.SelectedDate),
 Day(ReservationCheckOutValue.SelectedDate),
 Value(ResOutHourValue.Selected.Value),
 Value(ResOutMinuteValue.Selected.Value),
 0
 )
 )
)

And this is the code to set the varReservationDue variable in the OnChange of its controls:

Set(
 varReservationDue,
 If(
 Not IsBlank(ReservationDueValue.SelectedDate),
 DateTime(
 Year(ReservationDueValue.SelectedDate),
 Month(ReservationDueValue.SelectedDate),
 Day(ReservationDueValue.SelectedDate),
 Value(ResDueHourValue.Selected.Value),
 Value(ResDueMinuteValue.Selected.Value),
 0
 )
 )
)

As seen in the screenshot below, the device is reserved during the times the new reservation is attempted but still appears in the dropdown.

As shown below, it is only when the Check Out and Due Date/Times fall BETWEEN existing reservation date/times that the formula is returning devices that should not be returned. I can overlap or coincide the date/times exactly and the device is not included in the dropdown.