Unanswered

Checking availability on a date from another table

(0) Share

Report

Posted on by panxkruger

Hi Experts.

I have a desk booking application template from Aprill Dunnam. I wanted to convert it to book cars by the hour, but I can't show the cars available after a given hour in the gallery. Do you know how to fix it?

This is oryginal code:

I tried modifying it this way:

Filter(
 Sort(col_Desks, Title);
 Not(
 Title in 'Desks Reservations'.DeskText
 ) && 
 (
 IsBlank(LookUp(
 'Desks Reservations',
 DeskText = col_Desks.Title &&
 (
 ('Check Out From' >= startTime && 'Check Out From' <= endTime) || 
 ('Check Out To' >= startTime && 'Check Out To' <= endTime) ||
 ('Check Out From' <= startTime && 'Check Out To' >= endTime)
 )
 ))
 )
)

but it still doesn't work, any suggestions?

Thanks 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Shaheer Ahmad 2,194 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this:
Filter( Sort(col_Cars, Title); Not( Title in 'Cars Reservations'.CarText ) && ( IsBlank(LookUp( 'Cars Reservations', CarText = col_Cars.Title && ( ('Check Out From' >= startTime && 'Check Out From' < endTime) || ('Check Out To' > startTime && 'Check Out To' <= endTime) || ('Check Out From' <= startTime && 'Check Out To' >= endTime) ) )) ) )

Was this reply helpful? Yes No
panxkruger on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I don't have a car collection. The tables are called desk in the same way, i.e. Desk Reservation and Desk. Collections are col_desk, col_reservation

Was this reply helpful? Yes No