Hi guys, i have this formula:
If(
IsBlank(
LookUp(
ReversasUpdated;
DataReserva = DateValue(DateValue1.SelectedDate)
).DataReserva
);
Set(showDialogue; true)
)
On the onselect icon, if do the dates , start 17.00 , end 18.00

it shows this pop up:

Reserve Conclued, it already exites another reserve in this time, 15-05-24---17.00
But i wanted to onselect in the icon✅ to show in the pop up the reservation that is closer to that time, with this time options

as you can see its the first one at 14-05-24------15.00
So i wanted the onselect to check the closest reservation, in this case i wanted the pop up to say: Reserve Conlcued, it already existes another reserve, but in a timespam of 30 minutes max, because if more, the vehicules may be already gone.
Is it possible to the app have this knowledge to see, if there are reservations within a 30 minutes spam?