Announcements
For your car booking app, you need a SharePoint list to store bookings (Car, StartDateTime, EndDateTime). Then on your booking screen, use Date and Time pickers and filter the car gallery like this:
Filter(Cars, IsEmpty(Filter(Bookings, CarID = ThisRecord.ID && SelectedStart < EndDateTime && SelectedEnd > StartDateTime)))
This only shows cars with no overlapping bookings for the selected time — preventing double bookings automatically.
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-date-picker
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 610
Haque 317
WarrenBelz 315 Most Valuable Professional