Power Platform Community Forum Thread Details

Hi all

I am trying to build a straightforward time slot booking system

Patch in SharePoint list
*(Dynamic) Show available time slots by date selected
remove/disable once clicked on Booked

Collection:

ClearCollect(
 colAppointment,
 {
 TimeCol: "11:00",
 Booked: false
 },
 {

 TimeCol: "11:30",
 Booked: false
 },
 {

 TimeCol: "12:00",
 Booked: false
 },
 {

 TimeCol: "12:30",
 Booked: false
 },
 {
 
 TimeCol: "13:00",
 Booked: false
 },
 {

 TimeCol: "13:30",
 Booked: false
 },
 {
 
 TimeCol: "14:00",
 Booked: false
 },
 {

 TimeCol: "14:30",
 Booked: false
 }
);

Patch Btn:

Patch(
 'Solo Protect Appointments',
 Defaults('Solo Protect Appointments'),
 {
 DateOf: _DateOf.Text,
 TimeOf: _TimeOf.Text
 }
);
Patch(
 colAppointment,
 ThisItem,
 {Booked: true}
);
Refresh('Solo Protect Appointments')

App:

Current issue(gif)(when selecting different date "book time slot" not showing)

Thank you

Categories:

Building Power Apps

Hi @moerah ,

You need the buttons' visibility bound to selected dates as well. So, OnSelect of the date button in the Calendar view, you need to update the collection and include the selected date.

Collection OnVisible of Screen, with a new name colAppointment1:

ClearCollect(
 colAppointment1,
 {
 TimeCol: "11:00",
 Booked: false
 },
 {
 TimeCol: "11:30",
 Booked: false
 },
 {
 TimeCol: "12:00",
 Booked: false
 },
 {
 TimeCol: "12:30",
 Booked: false
 },
 {
 TimeCol: "13:00",
 Booked: false
 },
 {
 TimeCol: "13:30",
 Booked: false
 },
 {
 TimeCol: "14:00",
 Booked: false
 },
 {
 TimeCol: "14:30",
 Booked: false
 }
);

OnSelect of date (if see error in LookUp function, you need to press the button once, trigger the Collect function to initialize the colAppointment2):

Set(
 _dateSelected,
 DateAdd(
 _firstDayInView,
 ThisItem.Value,
 TimeUnit.Days
 )
);
If(
 IsBlank(
 LookUp(
 colAppointment2,
 Date = _dateSelected
 )
 ),
 Collect(
 colAppointment2,
 AddColumns(
 colAppointment1,
 "Date",
 _dateSelected
 )
 )
)

Items of collection Gallery:

Filter(
 colAppointment2,
 Date = _dateSelected
)

Hope this helps.

Best regards,

Community site session details

Time slot booking

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates