search

aprildunnam / PowerApps

Collection of Power Apps template apps, components and examples
Other
413 stars 226 forks source link

Double booking - in combination with several day booking #136

Open Proesel1 opened 6 months ago

Proesel1 commented 6 months ago

Hello, for me its possible to generat double booking if one person books more than one day and the second is booking the first day or the last day of this booking.

E.g. Person 1 books 10.03 - 16.03 (Desk 1) Person 2 can book Desk 1 on 10.03 and 16.03.

For 11-15.03 Desk 1 is not available.

image

I guess this is a filter failure from "DateSelection"

I have some problems to fix this and hope some of you can help me here.

Thaks a lot Bernd

plarochette commented 5 months ago

Hey, i had the same problem. You have to set an option in the sharepoint list to extend the format to Date + Time for "Check Out From" and "Check Out To"

In French>

image

The aim is to satisified this code implemented in the confirmation button to return correct reservation with the correct time/hour in compare opérations

ClearCollect( col_Reservations; Filter( 'Desk Reservations'; Or( And( 'Check Out From' >= startTime; Or( 'Check Out To' <= endTime; 'Check Out From' < endTime ) ); And( 'Check Out To' > startTime; Or( 'Check Out To' <= endTime; 'Check Out From' < endTime ) ) ) ) );;

Best regards