Nested filter for booking Car

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone!

I am pretty new to power apps and I want to create a car booking system.

I'm having trouble when I want to view the cars available for reservation based on the dates entered by the user.

Here's the Scenario:

In my application I have 2 sharepoint data lists. In one of this list I have all the car master data and in the other list I have all the reservations made.

For example, I have a situation like this with all the car master data. (to simplify the list I indicate only the car plates)

AJ737KI

JY666HT

FR888TT

GG333EE

BB098UI

And also I have this situation with all bookings made

Car plates	Start booking	End booking
JY666HT	20/02/2023	23/02/2023
GG333EE	22/02/2023	27/02/2023

I would like this situation: if the user wants to book a car with a start booking like 16/02/2023 and an end booking like 22/02/2023 he must only view these data

AJ737KI

FR888TT

BB098UI

But the filter I built is not working. I understood that I have to use two nested filters, since I have to take all the reservations contained in the dates entered by the user, take the car plate data and use it as a value key to exclude it from my master data.

Here's my filter:

Filter('Car Master';
Not(Plates in Filter(
'Car Reservation';
START_DATE_RESERVATION < Start_date_Book_User && START_DATE_RESERVATION < End_date_Book_User
).Plates))

What am I doing wrong? I'm wasting a lot of time on this issue. Please help me. Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

mmollet 3,187 on at

Like (1)

Report

Re: Nested filter for booking Car

Try using something like this:
Filter(yourSPListHere, Now() > start_date_book_user, Now() < end_date_book_user)
In english: Filter the SP list named 'yourSPListHere' to display entries only if Current Date/Time is greater than the start time of the booking AND if the current Date/Time is less than end time of the booking.

If this works as a solution please mark is as such for others to more easily find!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report
Re: Nested filter for booking Car

Hello mmollet,

Thank you for the support. I decided to go in this way:

This solution might be useful for someone looking for something like this.

When I select the start booking and end booking dates, I collect all the bookings that have been made in the range of the selected dates.
Collect(CarBooking;Filter('Car Reservation';(START_DATE_RESERVATION >= Start_date_Book_User && START_DATE_RESERVATION <= DateTimeValue(End_date_Book_User)) || (START_DATE_RESERVATION < Now() && END_DATE_RESERVATION > Now())))
And then I do a filter on my Car Master list using the collection that I created earlier with the date selection.
Filter('Car Master';Not(Plates in CarBooking.Plates))

Thank You!

Was this reply helpful? Yes No