Answered

Drop down to show available time slots when the date is selected.

(0) Share

Report

Posted on by sut_hkum

Hi all,

I am new to powerapps and i am stuck at where i want the drop down only show the available time slots, when the date is selected.

User is to select the date and then choose the time from the drop down.

I have two drop downs, one for hour and one for minutes. For minutes only 00 or 30.

For the hour, its between 10-17.

In the sharepoint list, i have a date-time column, and to check when the user select a date.

Need help..

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sut_hkum ,

Could you please share more details about your scenario? How do you know a timeslot is available or not?

Generally speaking, in the OnChange property of Hour and Minute dropdowns we use Notify and Reset functions along with an If statement to check the selected date and time. If it available, do nothing, if not, push a notification to user and reset those date picker and dropdown controls.

Best regards,

Was this reply helpful? Yes No
sut_hkum 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni
Thanks for the reply, here are more details.
1. To answer your question, I have yet to figure out how to check if the time-slot is available.
Below are the setup that i currently have.
1. I have a column in the sharepoint list, date_time (mm.dd.yyyy hh:mm)
2. The goal is, when user selsect a date in the powerapp, check with the list on the selected date and return available time slots.
3. Time slot starts form 10:00 to 17:00, each slot is 30 minutes. There will be 15 slots per day.
4. My thought is to have another column with HH:mm for time-slot,
and in the power app, a single time-slot drop down (hh:mm).

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @sut_hkum ,

This will be much simpler than a single date and time column. You can user a Filter function to get available timeslots in the Dropdown Items property according to the selected date.

Filter([15 slots array],DateTimeValue(Concatenate(Text(DatePicker.SelectedDate),",",ThisRecord.Value)) in SPList.DateTimeColumn)

This criteria is for getting available timeslots that cannot be found in the list date and time column.

Best regards,

Was this reply helpful? Yes No
sut_hkum 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni,
I can now get the drop down with the Time slot, but only shows occupied time slot.
I cant figure it out to show available time slots, Infact I also need help to set up available time slots somewhere.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @sut_hkum ,

You need to add a Not function for the criteria:

Filter([15 slots array],Not(DateTimeValue(Concatenate(Text(DatePicker.SelectedDate),",",ThisRecord.Value)) in SPList.DateTimeColumn))

Best regards,

Was this reply helpful? Yes No
sut_hkum 11 on at

Like (0)

Report
Copy link

Link copied!

hi @v-jefferni
Thanks a bunch, it worked.
I added few more filter columns as needed.

Was this reply helpful? Yes No