web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Book A Room Template -...
Power Apps
Unanswered

Book A Room Template - Change OnVisible Property to show calendar time availability instead of room availability

(1) ShareShare
ReportReport
Posted on by 5

Hi All, 

 

I am trying to display meeting availabilities on an app I am working on, through tweaking the Book a Room Template. How can I change the OnVisible property on the RoomSelectSreen to show a calendar availability, not a room if that makes sense? Image of the screen(rooms name hidden) and code are pasted below: 

 

simsal_0-1720614589616.png

 

 

Set(CalendarFromSelectMeeting, false);
If(DateTimeRoomChange,
    Set(AvailableRoomsCounter, 1);
    UpdateContext({ShowLoading: true});
    Set(RoomsLeft, Blank());
    Set(DateTimeRoomChange, false);
    If(!NoRoomsList,
        ClearCollect(AllRooms, Office365.GetRoomsInRoomList(RoomsListsGallery.Selected.Address).value)
    );
    If(CountRows(AllRooms) > 20,
        Set(AllRoomsConnector, Concat(FirstN(AllRooms, 20), Address & ";")),
        Set(AllRoomsConnector, Concat(AllRooms, Address & ";"))
    );

    ClearCollect(AvailableRooms, Office365.FindMeetingTimes({RequiredAttendees: AllRoomsConnector, IsOrganizerOptional: true,
        Start: StartDateTimeUTC, End: EndDateTimeUTC, MeetingDuration: DateDiff(StartDateTime, EndDateTime, TimeUnit.Minutes),
        MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"}));

    ClearCollect(AvailableRoomsSorted, SortByColumns(First(AvailableRooms).MeetingTimeSuggestions, "Confidence", SortOrder.Descending));

    ClearCollect(AvailableRoomsConcat, Concat(Filter(First(AvailableRoomsSorted).AttendeeAvailability, Availability = "Free"),
        Attendee.EmailAddress.Address, ","));

    ClearCollect(AvailableRoomEmails, ForAll(Split(First(AvailableRoomsConcat).Value, ","), {Result: ThisRecord.Value}));

    ClearCollect(AvailableRoomEmailName, AddColumns(RenameColumns(AvailableRoomEmails, Result, Email), Name,
        LookUp(AllRooms, Email = Address).Name));

    UpdateContext({ShowLoading: false});
    Set(RoomsLeft, CountRows(AllRooms) - 20 * AvailableRoomsCounter)
)
Categories:
I have the same question (0)
  • rzuber Profile Picture
    545 Moderator on at

    In the OnVisible property, do something like:

    UpdateContext({ShowCalendar: true})

    And the calendar's Visible property, set it to

    ShowCalendar
  • simsal Profile Picture
    5 on at

    I tried plugging those in and nothing seems to happen, although the page is blank now that I altered it a little bit.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard