
So i have started building a power apps for my team to book equipment from the inventory .
I created the App from a sharepoint list called 'HELM EQUIPMENT 2024' , Which is the inventory list .
i showed the products in a gallery and added a button to collect the selected Equipment's .
The Equipment ID is collected in a collection called cart 1 and Equipment and in another collection called cart 2 .
I did so to showcase this in a table style on the checkout screen . On the checkout screen i have start date , end date and email and also purpose.
This data are taken to a SharePoint list called ' Booking request' .
what i want help is on how i can validate the availability of the equipment selected using the dates on the list and the input ?
Also don't want to have any overlaps on the booking .