Power Platform Community Forum Thread Details

Hello everyone,
I'm currently pondering over a filter function that's difficult for me and I'm hoping someone can help me.

To the background:
I have two lists:

1. Parking spaces: All parking spaces are listed here
2. Reservations: The dates defined for the parking spaces are saved here.

So that only the parking spaces available on a given day are displayed in the list, I have defined the following filtering above the corresponding gallery:

Filter(Parkplätze;Not(Parkplatznummer in Filter(Reservierungen;Startzeit>=startTime && Endzeit <=endTime||Startzeit<=endTime &&Endzeit>=startTime).Parkplatznummer ||'Aktiv?'="Nein"))

startTime and endTime are global variables where I store the selected dates and times to compare with the dates and times stored in the "Reservations" list. In addition, I have defined a yes/no column "Active" in the "Parking spaces" list, which searches for whether a parking space has been set to active. This is the final part of the filtering and it has worked very well so far.

Now a new function will be added: There will be parking spaces that are only available at certain times. To do this, I defined the “Start” and “End” columns in the “Parking spaces” list.

According to an example, the filtering should work as follows:

I have a P1 parking space that is only available from April 1st, 2024 to April 5th, 2024. All other parking spaces that have not yet been reserved should be displayed by April 1st, 2024. From 01.04. until April 5th The parking lot P1 will then also be displayed. And if April 6th. then P1 should no longer be displayed.

How do I expand the filtering so that this additional parking space is shown to me?

Thanks in advance and best regards

Categories:

General Questions