Hi ! 🙂
I'm creating an application with Power Apps. I'm using Excel as database. I created a reservations' table with the following fields :
- id
- id_vehicule
- reservation_date
- hour_reservation_start
- hour_reservation_end
- user
- note
I have a screen named Calandar to select a date with a DatePicker and I also list all reservations in this screen. And another one called Form with my form.
(Screen Form)
When I submit my form to create a new reservation I convert my date like this :
Text(selectedDate,"dd/mm/yyyy")
l if I made a reservation for today, I will be write 03/01/2022 in my Excel table.
(Screen Calandar)
I defined the format DatePicker property to
"dd/mm/yyyy"
And to manipulate the selected date :
Text(DatePicker.SelectedDate,"dd/mm/yyyy")
To list all vehicule's reservations in my Calandar screen, I would like to filter my table by id_vehicule and by reservation_date.
On Items gallery property I tried with Filter function and it works when I filter by reservation_date or by id. But it doesn't work when I combine the two.
Filter by reservation_date (it works)
Filter(
reservations,
reservation_date = Text(DatePicker.SelectedDate,"dd/mm/yyyy")
)
Filter by id (it works)
Filter(
rerservations
id_vehicule = id
)
Filter by id_vehicule AND by reservation_date (it doesn't work)
Filter(
reservations,
And(
reservation_date = Text(
DatePicker.SelectedDate,
"dd/mm/yyyy"
),
id_vehicule = id
)
)
Filter(
reservations,
reservation_date = Text(DatePicker.SelectedDate,"dd/mm/yyyy") And id_vehicule = id
)
Filter(
reservations,
reservation_date = Text(DatePicker.SelectedDate,"dd/mm/yyyy") && id_vehicule = id
)
Please can you help me ?
Thank you 🙏
