cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DarkRoboHunter
Regular Visitor

Trying to disable submit button if room is not available.

I am trying to disable a submit button on an edit form if a rooms' time slot is already taken and approved.

 

This is what I am working with:

 

Data Source: SharePoint list (Calendar) called- Calendar_Test

I have an edit form that I am trying to validate the information with the data source.  I am trying to validate the following columns:

*Start Time (date and time column): input on the edit form is dp_NewStartTimeDate and dp_NewStartTimeHours

*Time Slot (single line):  text input on the edit form is txt_NewTimeSlot

*Approved by SSR (choice): (Pending, Approved, Denied) drop down input is dd_NewApprovedBySSR

 

What I am trying to do is disable submit button If(any item that is pending or approved in the data source and at the same time and date with the same time slot not be able to add a new item that matching that criteria) disable button until time or date is changed to not conflict with another item.  I am only working with 1 rooms' schedule.  

 

Is this possible? I have been trying to figured it out for days and I feel close but nothing is working.

 

Any information on this would be greatly appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
DarkRoboHunter
Regular Visitor

I was able to figure it out.  If anyone is interested in what I did let me know.  I don't know if it is the best way of doing it but it worked for me.

 

View solution in original post

2 REPLIES 2
DarkRoboHunter
Regular Visitor

I was able to figure it out.  If anyone is interested in what I did let me know.  I don't know if it is the best way of doing it but it worked for me.

 

shubh1994
New Member

Hello @DarkRoboHunter ,

 

I am working on similar type of book Session app wherein my database is SharePoint list. I want to basically check if the date time slot is already available in  the list then If yes should be able to restrict the booking.

 

My Start Time and End time both the columns are Date time type.

 

Can you please help. 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,943)