Power Platform Community Forum Thread Details

HI,

I have a problem with Book a room templet in office 365. Its only show one room not all room in Outlook.

Even when the rest of the rooms are avaliable

No code error, all data source connected.

Any help.

Categories:

Building Power Apps

Hi @Anonymous ,

Did you make some changes to the sample app?
I've made a similar test but not met the same problem like your description.

Please check the formula about this gallery:

Set(CalendarFromSelectMeeting, false);
If(DateTimeRoomChange,
 Set(AvailableRoomsCounter, 1);
 UpdateContext({ShowLoading: true});
 Set(RoomsLeft, Blank());
 Set(DateTimeRoomChange, false);
 If(!NoRoomsList,
 ClearCollect(AllRooms, Office365.GetRoomsInRoomList(ChosenLocation.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, Minutes),
 MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"}));

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

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

 ClearCollect(AvailableRoomEmails, Split(First(AvailableRoomsConcat).Value, ","));

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

 UpdateContext({ShowLoading: false});
 Set(RoomsLeft, CountRows(AllRooms) - 20 * AvailableRoomsCounter)
)

Best regards,

Community Support Team _ Phoebe Liu