Answered

Dates in Gallery (as per the Date Picker)

(0) Share

Report

Posted on by rsinha

Hi Folks,

I have a Seat availability App, where users can see the No of office seats occupied in a particular day.
And there I have a small requirement where we have 2 Date Pickers: From Date and To Date; so whatever dates users pick, in the Dropdown Gallery, we must see the the no of seats occupied against the dates.

So if user pick 7 days, gallery should return 7 rows (if he/she picks 10 days, gallery should return 10 days of data) having 2 columns: Date (in Sorted order) and Occupied seats. I can bring the count of occupied seats according to the dates. But how can I bring the Dates in sorted order?

The data is coming from SharePoint Lists.

Kindly help..

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
hi there @rsinha you need to do two things, filter the data by your datepickers and then group them where you will get the number of seats.

I created a dataset to reflect the structure you have in some way ;), its called colComSeats

Step 1

Filter the data by the datepickers.

Filter( colComSeats, date >= DatePicker1.SelectedDate && date <= DatePicker2.SelectedDate //all the items between this date range )

you can add that to a collection.

Step 2

group the data above and count the records per date.

AddColumns( GroupBy( Filter( colComSeats, date >= DatePicker1.SelectedDate && date <= DatePicker2.SelectedDate ), "date", "Seats" ), "No of people...", CountRows(Seats) )

Result

Hope it helps,

R

Was this reply helpful? Yes No
rsinha 2 on at

Like (1)

Report
Copy link

Link copied!

Thanks @rubin_boer it's working now.. 🙂
Thank you for your help..

Was this reply helpful? Yes No
naro_rijal 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @rubin_boer,
Thanks for the solution, it works!
But I have a question: Why isn't the gallery showing the end date that I selected on the datepicker?
The gallery only shows the data from the start date until the day before the end date.
Here's an example:

I would appreciate your advice.
Thanks,
Naro

Was this reply helpful? Yes No
_Nils_ 71 on at

Like (0)

Report
Copy link

Link copied!

Hi @naro_rijal,
it's because of the time. When selecting a date with the datepicker the time is set to 00:00.
So you are currently filterting for a timestamp between 5/19/2023 00:00 and 5/24/2023 00:00.

Was this reply helpful? Yes No