Filter to show availability based on several conditions on bookings in another list

(0) Share

Report

Posted on by rockshah

Hello again

There is this code which removes lines from a gallery list depending if desk has been booked for that day.

Filter(
 Sort(col_Desks,Title),
 Not(
 Title in col_Reservations.DeskText
 ) && Active = 1 && Or(DeskSearchFilter.Text in Title , DeskSearchFilter.Text in Description)
)

However I want to add further conditions based on what time the desk is booked as currently if desk is booked for 1 hour (say from 10am to 11am) it'll remove the listing for that desk for the rest of the day which I don't want.

I need to figure out how where to place the conditions and how.

'startTime' and 'endTime' are variables of what time is selected for a new booking

'Check Out From' and 'Check Out To' are times from and to in the col_Reservations list of existing bookings. Not sure if I'm on the right lines.

'Check Out From' >= startTime && 'Check Out To' <= endTime || 'Check Out From' <= endTime && 'Check Out To' >= endTime

Active is just to say that desk is active and there is a filter on the screen so you can type desk number (via DeskSearchFilter)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @rockshah

Try this formula,

Filter(
Sort(col_Desks, Title),
Not(
Title in col_Reservations.DeskText
) &&
Active = 1 &&
(DeskSearchFilter.Text in Title || DeskSearchFilter.Text in Description) &&
IsEmpty(
Filter(
col_Reservations,
(
('Check Out From' >= endTime && 'Check Out From' <= startTime) ||
('Check Out To' >= endTime && 'Check Out To' <= startTime) ||
('Check Out From' <= endTime && 'Check Out To' >= startTime)
)
)
)
)

(Or)

Filter( Sort(col_Desks, Title), Not( Title in Filter( col_Reservations, ('Check Out From' >= startTime && 'Check Out From' < endTime) || ('Check Out To' > startTime && 'Check Out To' <= endTime) ).DeskText ) && Active = 1 && (DeskSearchFilter.Text in Title || DeskSearchFilter.Text in Description) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
rockshah 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @Rajkumar_404 the second option worked a treat - the only thing I had to was apply DateTimeValue to the Check Out times as they were in text format. Thanks!

Was this reply helpful? Yes No