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
ToD: Date Picker
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,
Solved! Go to Solution.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!