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 ,

Where are these error red waves located?

The first error means there is something wrong with these Name, please check if these List Names, Control Names and column Names are correct.

The second error, the notification text should be wrapped by double quotes.

Notify("The date and time have been selected. Please select another time")

Hope this helps.

Sik 

[AB21]

Hi @v-siky-msft ,

This worked perfectly!!! Thank you! 

I have one last thing, I want to put some sort of code in which takes me to a successful page only if the time is available if not this then takes me to another page or stays on the booking page.

I currently have this 

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");Navigate(Screen3,ScreenTransition.Fade)
)

Thanks in advance!

[v-siky-msft · Accepted solution]

Hi @AB21 ,

Please try this. Insert the Navigate() code after the Patch formula to navigate to the success screen.

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});Navigate(SuccessScreen,ScreenTransition.Fade),
Notify("The date and time have been selected. Please select another time")
)

Hope this helps.

Sik

[AB21]

Hi @v-siky-msft,

Thank you so much for your help! 

[Champ14]

Hi All,

I am also currently working on the same thing, only difference was the user can book 3 times a week, either AM and PM, and each day should only have maximum of 7 bookings. How can i do this?

Thank you

[AB1]

Hi @v-siky-msft , 

I was wondering if you can help me, this code works perfectly but now I want to block some days out in the calendar ie all fridays. I have found some code which only works with the calendar screen type of calendar rather than the component. Here is my code with the new calendar part. 

Any ideas? Thanks in advance!