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

Announcements

News and Announcements icon
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
    552 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 600

#2
WarrenBelz Profile Picture

WarrenBelz 478 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 322

Last 30 days Overall leaderboard