disable button based on timeslot availability

[OliverV]

Hi All,

I'm having an app built on a Sharepoint Calendar Application, in order to book meeting slots.

So far I'm having a good gallery listing out the events within the FromD (from date) to the ToD (To date), but I strugle in having the filtering expanding to have also the hours and minutes taken in consideration. (Picture Attached)

objects at the moment

FromD: Datepicker

ToD: Date Picker

FromH:dropdownlist

FromM:dropdownlist

ToH:dropdownlist

ToM:dropdownlist

NZA534 Gallery Items:

Sort(Filter(NZA534;
    DateDiff(DateAdd(FromD.SelectedDate;-Weekday(Now()-7));EventDate)>0;
    DateDiff(DateAdd(FromD.SelectedDate;7-Weekday(Now();7));EventDate)<=0
    And 
    DateDiff(DateAdd(FromD.SelectedDate;-Weekday(Now()-0));EndDate)>0;
    DateDiff(DateAdd(FromD.SelectedDate;0-Weekday(Now();0));EndDate)>=0
   );EventDate;Ascending)

What i would like to achieve based on the picture is the following:

1) since if we look at the selected time, there is already an entry, i would like the gallery to write out "Timeslot not available" and not list the times

2) since if we look at the selected time, there is already an entry, i would like to disable the visibility of the "Book" button

Every suggestion is well appreciated,

[OliverV]

@mdevaney  any idea ?

[mdevaney · Accepted solution]

@OliverV 

No.