Answered

Filter Items by Date range

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

For a powerapp that lets my co-workers make a reservation for camera equipment i have created a powerapp that has saved all the equipment in a sharepoint list. If a reservation is made it is getting saved on a different sharepoint list which is collecting the reservations. the reservation of an item is already connected to the item list by obtaining the product id and connecting it to the reservation list.

On the start page of the application there is a vertically aligned gallery that displays the items. now i want to add a date range filter that lets the user filter the items by availability on a specific date range.

My question now is, how can i filter a date range which filters the reservations of its sharepoint list but then outputs the available items of the items displayed?

Here i show you a picture of my powerapp for context:

Bildschirmfoto 2023-06-07 um 17.18.20.png

I hope together we can solve this problem

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

Change your gallery data source Items property to something similar to the following, where spList is the SP list and MyDate is the date column being filtered:

Filter(spList, MyDate >= von.SelectedDate && MyDate <= bis.SelectedDate )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @KeithAtherton Thanks for your response.
Unfortunately this does not work, because the equipment which is being shown in the gallery is a different sharepoint list than the reservations get saved to.
Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, I understand. Change your gallery data source Items property to something similar to the following:

Filter(colProducts As Product, IsEmpty( Filter(colReservations As Reservation, Reservation.ProductId = Product.ProductId And ((Reservation.From >= dteVon And Reservation.From <= dteBis) Or (Reservation.To >= dteVon And Reservation.To <= dteBis)) ) ) )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.