cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OliverV
Helper I
Helper I

disable button based on timeslot availability

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,

1 ACCEPTED SOLUTION

Accepted Solutions

2 REPLIES 2
OliverV
Helper I
Helper I

@mdevaney  any idea ?

@OliverV 

No.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,524)