BOOK A ROOM APP STOPS DISPLAYING ROOMS

[LEARN_IT]

Book A Room App stops showing all my available rooms for not reason. Only show my top room listed, Meaning only one room comes up. If there any changes that we need dont know? I created a new one from the Template and it's doing the same.

Please help, I did everything at my end and can't resolve this issue. All Available rooms show up in Outlook, no issue there.

Thanks, Learn IT

Here is the code:

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

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

If(CountRows(AllRooms) > 20,
If(CountRows(AllRooms) > 40,
Set(AllRoomsConnector1, Concat(LastN(FirstN(AllRooms, 40), 20), Address & ";")),
Set(AllRoomsConnector1, Concat(LastN(AllRooms, CountRows(AllRooms) - 20), Address & ";"))
);
ClearCollect(AvailableRooms1, Office365.FindMeetingTimes({RequiredAttendees: AllRoomsConnector1, IsOrganizerOptional: true,
Start: StartDateTimeUTC, End: EndDateTimeUTC, MeetingDuration: DateDiff(StartDateTime, EndDateTime, Minutes),
MinimumAttendeePercentage: "1", ActivityDomain: "Unrestricted"})
),
Clear(AvailableRooms1)
)

);
If(CountRows(AllRooms) > 20,
Collect(AvailableRooms, AvailableRooms1)
);
ClearCollect(AvailableRoomsSorted, SortByColumns(First(AvailableRooms).MeetingTimeSuggestions, "Confidence", Descending), If(CountRows(AllRooms) > 20, SortByColumns(Last(AvailableRooms).MeetingTimeSuggestions, "Confidence", Descending)));

ClearCollect(AvailableRoomsConcat, Concat(Filter(First(AvailableRoomsSorted).AttendeeAvailability, Availability = "Free"),
Attendee.EmailAddress.Address, ","), If(CountRows(AllRooms) > 20, Concat(Filter(Last(AvailableRoomsSorted).AttendeeAvailability, Availability = "Free"),
Attendee.EmailAddress.Address, ",")));

ClearCollect(AvailableRoomEmails, Split(First(AvailableRoomsConcat).Value, ","), If(CountRows(AllRooms) > 20, Split(Last(AvailableRoomsConcat).Value, ",")));

ClearCollect(AvailableRoomEmailName, AddColumns(RenameColumns(AvailableRoomEmails, "Result", "Email"), "Name",
LookUp(AllRooms, Email = Address).Name));
UpdateContext({ShowLoading: false});
Set(RoomsLeft, CountRows(AllRooms) - 40 * AvailableRoomsCounter)
);
Clear(AvailableRooms);
Clear(AvailableRooms1)

[LEARN_IT · Accepted solution]

Anyone using this template app has any issue?

[XavierSoh]

I am having the same issue with office365outlook.findmeetingtimes, only the first attendeeavailability is showing value (free/tentative/busy), the others showing 'Unknown'.  My app works perfectly on Monday and issue started on Tuesday 11/10/2022. Tried the meeting capture app and findmeetingtimes from graph-explorer, and both are behaving the same too. Keen to know if there was any update from Microsoft recently or a bug or anything I need to update from my app. Thanks.

[boidos]

Having the same issue here. Booking works in Outlook but in PowerApps it only shows the first result in the roomlist. Checking the collections and the monitor, all rooms are being discovered when the query is run Office365.GetRoomsInRoomList, but when the query FindMeetingTimes is sent only one row is returned. It sees the availability status of the first workspace as free and the rest of the workspaces as unknown.

[martinkubik]

Hi all, we have the same problem here. We also tested it with a newly created app and it is the same there.

 

[ramon_glez]

I am having the same issue with office365outlook.findmeetingtimes and API graph.findmeetingtimes since last 3 days. 

[DanielTaylor]

It's a known issue that Microsoft are fixing. See thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/Book-a-room-template-app-only-shows-first-av...