Appointment booking slots - no double bookings

[AB21]

Hi All, 

Was wondering if someone can help me with the following scenario which I want to implement! 

So I have a Sharepoint list which has the following titles:

And a power app layout as follows 

I have a calendar component, a drop down that contains all the time slots and the name of the person filling this out. 

Here is the issue! I want to connect them together and click to my sharepoint list. Inputting the date, time slot and name!  (keeping a log of the people filling out the app)

I also want the the person filling out this app to not be able to have the same date/ time slot as someone who has previously filled it out. 

Please help! is this possible and can someone show me how to link this all together or put me in the right direction! 

[v-siky-msft]

Hi @AB21 ,

Try to configure some logic condition before saving the data to list. Use LookUp function to check if there is a record with the same Date and Time slot.

If(IsBlank(LookUp('SP list', 'Time slot'=DropdownName.Selected.Value && Date=DateValue(Text(CalendarComponent.StartDate))).ID, 
Patch('SP list', Defaults('SP list'), {'Full Name':TextInput.Text, Date: DateValue(Text(CalendarComponent.StartDate)) ,  'Time slot'=DropdownName.Selected.Value}), Notify('The date and time have been selected. Please select another time'))

Hope this helps.

Sik 

[AB21]

Hi @v-siky-msft ,

Thanks for this! where would this code go? on the calendar, drop down or text input? 

Sorry I'm such a novice!

Thanks in advance

[v-siky-msft]

Hi @AB21 ,

Try to put the code to OnSelect property of SubmitButton.

The code will be triggered when the button is clicked, and check if the Date and Time slot exist in the list before save. if exist a notification will show to warn user.

If(
IsBlank(LookUp('SP list', 'Time slot'=DropdownName.Selected.Value && Date=DateValue(Text(CalendarComponent.StartDate))).ID,
Patch('SP list', Defaults('SP list'), {'Full Name':TextInput.Text, Date: DateValue(Text(CalendarComponent.StartDate)) ,  'Time slot'=DropdownName.Selected.Value}),
Notify('The date and time have been selected. Please select another time')
)

Sik

[AB21]

HI @v-siky-msft 

Thanks again for your amazing help! I am so close! 

here is the code after adjusting it to my details:

If(
IsBlank(LookUp('Parent Booking', 'Time slot'=DropdownName1.Selected.Value && Date=DateValue(Text(Calendar_1.StartDate))).ID,
Patch('Parent Booking', Defaults('Parent Booking'), {'Full Name':TextInput.Text, Date: DateValue(Text(Calendar_1.StartDate)), 'Time slot'=DropdownName1.Selected.Value}),
Notify('The date and time have been selected. Please select another time')
)

but im getting some errors! 

where am I going wrong? 

Thanks again for you help, really appreciate it 

[v-siky-msft]

Hi @AB21 ,

You need to replace the control name in the formula. please try this:

If(
IsBlank(LookUp('Parent Booking', 'Time slot'=Dropdown1.Selected.Value && Date=DateValue(Text(Calendar_1.StartDate))).ID),
Patch('Parent Booking', Defaults('Parent Booking'), {'Full Name':TextInput1.Text, Date: DateValue(Text(Calendar_1.StartDate)), 'Time slot':Dropdown1.Selected.Value}),
Notify('The date and time have been selected. Please select another time')
)

Hope this helps.

Sik

[AB21]

Hi @v-siky-msft 

thanks once again, I now have 4 errors which I'm struggling to figure out:

do you know how I go by fixing these? also in my drop down I want to add times like 10:00, 10:30, 11:00. How do I add it in iv tried [“10:00″,”10:30″,”11:00”] but didnt work.

Can you please help?

Thank in advance

[AB21]

Hi @v-siky-msft 

I have sorted the Drop down errors its just the 4 errors that I screenshot in the last reply! 

Thanks in advance

[v-siky-msft]

Hi @AB21 .

Glad to see it. Is there anything else I can help?

Sik

[AB21]

Hi @v-siky-msft ,

I have two last errors! thanks for your help and was wondering if you can help on these last two? 

here are the screenshots 

code :

If(
IsBlank(LookUp('Parent Booking_1', 'Time slot'=Dropdown1.Selected.Value && Date=DateValue(Text(Calendar_1.StartDate))).ID),
Patch('Parent Booking_1', Defaults('Parent Booking_1'), {Title:TextInput1.Text, Date: DateValue(Text(Calendar_1.StartDate)), 'Time slot':Dropdown1.Selected.Value}),
Notify('The date and time have been selected. Please select another time')
)

Thanks in advance!