News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Book A Room Template -...

Power Apps - Building Power Apps

Unanswered

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

(1) Share

Report

Report

Posted on by simsal

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:

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)

)

All responses Img

All responses (2)

Answers Img

Answers (0)

simsal 5 on at

Like (0)

Report

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

I tried plugging those in and nothing seems to happen, although the page is blank now that I altered it a little bit.
rzuber 545 Super User 2025 Season 1 on at

Like (0)

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

In the OnVisible property, do something like:
UpdateContext({ShowCalendar: true})
And the calendar's Visible property, set it to
ShowCalendar